You're welcome. Thanks for providing enough information to crack the problem.

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.