You mean smalldatetime?

Yup that does it.

It's not that hard to do for the time part... but I wouldn't want to code the functions to handle the date part :

Declare @ms as int

Set @ms =...

Wouldn't it be better to extract the hour part and do a % 12 on it so that you don't get 23H15:13 PM?? >> we know it's pm by that...

Check this out :

Retriving host IP Address via T-SQL

Is synchronised replying a new olympic event now?

Sorry for the late reply... forgot the hit send :

Select convert(varchar(8), GetDate(), 108) as 24H_Time

Hey noeld, do you have an short exemple that makes that select work?

To what question?

Should be the same speed... with the wildcard at the front of the like, a scan is required to find all possible matches. Using charindex will always result in...

Real nice observation Badeau

I reran the code with @DateInt = 200505 and it runs slower (somewhat) than the date version. So looks like I'm back to square one on...

Can't wait to get an answer to that one (sort of application generates 700mb worth of transaction data in an hour but doesn't...

Noeld will probabely have a better solution but this works (even if it's a little slow) :

Select distinct name from dbo.SysObjects O inner join dbo.Numbers N on len(name) <=...

What problem are you trying to solve?

Do you have an exemple of that??