At this time of the morning? :unsure: ok then...

andrewd.smith (11/10/2010)

---

Either of these will work and stand a chance of using an index (if such an index exists) on the OrderDate column:

SELECT *

FROM dbo.ZNodeOrder NO

...

Richard put the knife down, and the user 😀

Mornin' Ray. Smoke?

SELECT

OriginalMinutes= Minutes,

INTHours= Minutes/60,

INTRemainingMinutes = Minutes%60,

CHARHours= REPLACE(STR(Minutes/60,2), ' ', '0'),

CHARRemainingMinutes = REPLACE(STR(Minutes%60,2), ' ', '0'),

HoursAndMinutes= REPLACE(STR(Minutes/60,2), ' ', '0') + ':' + REPLACE(STR(Minutes%60,2), ' ', '0')

FROM (

SELECT 25...

El Gato (11/10/2010)

---

Hi guys, our developer is not in today and I need help to generate the following query in a dynamic fashion:

SELECT *

FROM dbo.ZNodeOrder NO

INNER JOIN dbo.ZNodeOrderLineItem NOLI

ON...

sdabiri881 (11/10/2010)

---

Sorry, I have added the #Staging Table that the #Results table is pulling from for the OrganizationName field. Hope this makes sense. Thank you for your assistance...

Wise move - but you could make some up.

Alvin Ramard (11/9/2010)

---

Alvin Ramard (11/9/2010)

---

What a useless write up that was. ...

Thanks Alvin.

Steve you need to whack the quoted link too.

Sorry, don't...

A bit? You're so lucky - it's all we ever get!

Colour Ereader announced (newscientist.com). I know there are interested folks here - you can now buy one.

Award-winningly sketchy spec, but here goes:

SELECT

offenders = Agg.OffendersOfThisTypeInThisCounty,

m.County_Name,

m.Web_Desc,

'1' AS 'Address_Type'

FROM (

SELECT c.County_Code, c.County_Name, t.Offender_Type_LKP_ID, t.Web_Desc

FROM SPGlobalLookups.dbo.County_LKP c

CROSS JOIN dbo.Offender_Type_LKP t

) m

LEFT JOIN (

SELECT o.Offender_Type_LKP_ID, a.County_Code, OffendersOfThisTypeInThisCounty = COUNT(*)

FROM...