Nice one Frank... it's nice to see you back here. Where have you been?

I'll remember to check for that someday... good thing you're there .

Or there's always the trick of dividing by a decimal :

Select 2 / 1000 as [int], 2 / 1000.0 as [decimal]

int ...

Not really a strange way.. but I would suggest you try to write a stored proc to resolve this search problem Read this for more details : Dynamic...

HTH.

Here's where the 24 thing comes in handy :

DATEADD(hh, DATEDIFF(hh, 0, TIME_STAMP), 0) % 24

BTW my name is Remi, ten centuries is because I posted 1000+ message. Just like you'll be flagged as a newbie untill you post your 10th message.

Well this is really something that should be done on the client side of the app... but if you insist on doing this on the server :

Select C1.Name, (Select...

Select Y1.Org_Name, Y2.Org_Name from dbo.YourTable Y1 inner join dbo.YourTable Y2 on Y1.Region_Key = Y2.Org_Key

I understand that, but the fact is that the query is still wrong. You can use select into in combinaison with the inner join.

Also if this is something that will...

can you post the table definition along with some sample data?

Declare @StartDate as datetime

set @StartDate = DATEADD(M, DATEDIFF(M, 0, getdate()), 0)

select * from dbo.transmast where trans_date between @StartDate and GetDate()

You'd need a self join in this situation but wouldn't it be better to have the region in a separate lookup table? Would be uch simpler to access the...

It's the same as doing a cross join (

SELECT DEkeyValue AS JobNumber, DEentryTypeID, DEenteredDate AS PayDay

FROM Diaryentry cross join workrequest

WHERE WRenteredDate BETWEEN '2005-04-03 00:00:00' AND '2005-05-20 00:00:00'

AND DEentryTYPEID='ENRPAY'

)

You'll need to...

It's not quite true... you can get only 1 value at the time, but you can use datediff to get the hours and then recall it to get the minutes......