| RESULTSET |
| query |
| |
CALENDARDT |
CALENDARTIME |
CANCELREASON |
CATEGORYID |
CATEGORYID |
CLOSEDHOURSPRIOR |
DURATIONHRS |
EVENTENDTIME |
FULLNAME |
ID |
ISCANCELLED |
ISCLOSEDNEWENTRIES |
ISREADONLY |
OPTION1 |
PRODDESC |
PRODID |
PRODNAME |
QTY |
QTY2 |
REGISTERLINK |
SKUNOTE |
UNIT |
UNIT2 |
USERID |
| 1 |
2026-03-16
|
1970-01-01 19:00:00.0
|
[empty string]
|
1
|
1
|
0.00
|
2.00
|
1970-01-01 21:00:00.0
|
[empty string]
|
1989
|
0
|
0
|
0
|
I am a heeler and do not intend to bring a header
|
This team roping practice is split between mechanical steer and live cattle.
One session is intended for one horse, no exceptions.
Heelers, you must have a header to rope live cattle. They need to sign up just the same.
No solo heelers. It's +$20 if you show up as a solo heeler.
|
1989
|
Trainer TR Practice
|
10
|
10
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
0
|
| 2 |
2026-03-16
|
1970-01-01 19:00:00.0
|
[empty string]
|
1
|
1
|
0.00
|
2.00
|
1970-01-01 21:00:00.0
|
[empty string]
|
1989
|
0
|
0
|
0
|
I do not intend to help unwrap steers and clean lead-ups
|
This team roping practice is split between mechanical steer and live cattle.
One session is intended for one horse, no exceptions.
Heelers, you must have a header to rope live cattle. They need to sign up just the same.
No solo heelers. It's +$20 if you show up as a solo heeler.
|
1989
|
Trainer TR Practice
|
10
|
10
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
0
|
| 3 |
2026-03-16
|
1970-01-01 19:00:00.0
|
[empty string]
|
1
|
1
|
0.00
|
2.00
|
1970-01-01 21:00:00.0
|
[empty string]
|
1989
|
0
|
0
|
0
|
I do not intend to pick up my horse manure inside and outside
|
This team roping practice is split between mechanical steer and live cattle.
One session is intended for one horse, no exceptions.
Heelers, you must have a header to rope live cattle. They need to sign up just the same.
No solo heelers. It's +$20 if you show up as a solo heeler.
|
1989
|
Trainer TR Practice
|
10
|
10
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
0
|
| 4 |
2026-03-16
|
1970-01-01 19:00:00.0
|
[empty string]
|
1
|
1
|
0.00
|
2.00
|
1970-01-01 21:00:00.0
|
[empty string]
|
1989
|
0
|
0
|
0
|
Practice Heat 1 - 7pm
|
This team roping practice is split between mechanical steer and live cattle.
One session is intended for one horse, no exceptions.
Heelers, you must have a header to rope live cattle. They need to sign up just the same.
No solo heelers. It's +$20 if you show up as a solo heeler.
|
1989
|
Trainer TR Practice
|
10
|
10
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
0
|
| 5 |
2026-03-16
|
1970-01-01 19:00:00.0
|
[empty string]
|
1
|
1
|
0.00
|
2.00
|
1970-01-01 21:00:00.0
|
[empty string]
|
1989
|
0
|
0
|
0
|
Practice Heat 2 - 8pm
|
This team roping practice is split between mechanical steer and live cattle.
One session is intended for one horse, no exceptions.
Heelers, you must have a header to rope live cattle. They need to sign up just the same.
No solo heelers. It's +$20 if you show up as a solo heeler.
|
1989
|
Trainer TR Practice
|
10
|
10
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
0
|
|
| SQL |
SELECT Product.prodID as ID, product.prodid, product.categoryID,Product.prodName, Sku.Option1, Product.prodDesc,
Product.CalendarDT, Product.CalendarTime, 10 as qty, '' as unit, 10 as qty2, '' as unit2,
case when product.durationhrs > 0 then product.durationhrs else max(sku.durationhrs) end as durationhrs,
case when product.durationhrs > 0 then DATEADD(n, product.DurationHrs * 60,product.calendartime)
else DATEADD(n, max(sku.DurationHrs) * 60, product.calendartime) end as eventendtime,
isClosedNewEntries,ClosedHoursPrior,
0 as UserID, categoryID,'' as skunote,
'' as fullname,iscancelled,ISREADONLY,cancelreason,registerLink
FROM Product
LEFT JOIN Sku ON Product.prodID = Sku.ProdID
WHERE isactive = 1
-- and categoryID = 1
and product.clientid = 100
and Product.prodID =?
group by product.prodid,categoryID,prodname,option1,proddesc,calendardt,calendartime,
isClosedNewEntries,ClosedHoursPrior,categoryid,product.durationhrs,iscancelled,ISREADONLY,cancelreason,registerLink
order by calendarTime |
