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??

Queries like this often end up as clustered index scan because there's no index that covers all columns.

Can we see the rest of the query and the execution plan?

Also is...

I'm pretty sure that this is not what you mean but...

Declare @a varchar(10)

Declare @b-2 varchar(10)

Set @a = 'any value'

Set @b-2 = @a

Select @a, @b-2

any valueany value

"A previous post says that dates make good indexes. I tend to disagree."

I can't say that this comment didn't make me jump from my seat. But apprently you are...