You need to debug this sql using standard techniques. I suggest that the first thing you do is find out what the value of @i is in your while...

Hi,

The time datatype isn't really for durations, it represents the time of day, so if I'm reading your data correctly it'll throw an error when converting 335 hours to...

Indexed view - or is that nuts?

I think the following sentence is wrong or could be misinterpreted-

If you use an expression in the GROUP BY clause the same exact expression must be used in the...

Hi, there is a mistake in the 'Stairway to T-SQL DML Level 6: The Basics of Sorting Data Using the ORDER BY Clause' - I'm sure this is as a...

Could be a 3rd-party generic backup app with a SQL plug-in.

This was a head scratcher. I think that because you used a table variable in your example, you need to use an alias so that sql can make the...

@ErrorMessage doesn't get populated in the code shown. Can you show how that gets built?

I know you said 'combine into one query' but don't you really want to combine the results from the 2 separate queries into one result set?

declare @payables decimal(10,2), @ledgerbal...

I might be wrong but I think you may be trying to run the Windows Server Best Practice Analyser against the database when you really want to run the...

try sp_refreshview as a start.

I'm assuming when you say 'infinite' you mean a long time. Does it actually return with the data you need or does the query finish...

We need to see the columns in your trace.

The sp_trace_setfilter applies filters to numbered columns. That's the 10 and 13 part.

Did you create the trace with profiler...

Without seeing the correct table structures you have, it is impossible to give you a full answer BUT it looks like the UID is a unique surrogate key for...

what service pack are you on? There were historical issues that were fixed with updates from MSFT.

http://thesqldude.com/tag/mdw/[/url]

Ok, we are getting somewhere now. You have a data warehouse and it is running on data extracted from an OLTP database presumably.

Is your ETL process (extract,transform, load) process...