Yes, your welcome!

Before you start looking deep into partitioned tables I have one question for you, are you running SQL Server 2005 Enterprise Edition or SQL Server 2005 Standard Edition? This...

Instead of the above, I'd use the following in MS SQL Server:

select dateadd(dd, datediff(dd, 0, getdate()), 0)

Gus, you beat me and you provided additional info that is quite appropriate. Three thumbs up!

You can easily answer this question yourself. Before running the query in SSMS, set it to also return the Actual Execution Plan and review the plan. You should...

Works on my computer at home.

Edit: Except you need to change the varchar(18) to varchar(19) or varchar(20) as I originally posted. You could also...

Okay, I bit the bullet and I am now on twitter, @LynnPettis. So, who else is out there?

JonJon (11/3/2009)

---

Im loading a datawarehouse with many dimension tables.

WHen I moved to sql 08, I added more indexes but things were working well for a month.

My issue just started. When...

Not with the information provided. lease read Gail's article about asking for help with performance issues (the second article I have referenced below in my signature block).

Here is the code I developed.

declare @time decimal(4,2);

set @time = 14.23;

select right(convert(varchar(20), dateadd(mi, (@time - floor(@time)) * 100, dateadd(hh, floor(@time), 0)), 100), 7)

Being in the US, I am assuming the comma (,) is just like the decimal point (.)...

Okay, it is a decimal value, how is it stored? Please provide a sample of the data.

I'm not sure what you are asking. Can you explain better what you are trying to accomplish.

True, which is why I would actually try the other way first.

Of course, the right way to do it is to rewrite the process as a set-based query.