This is a very big "catch all" procedure.

First off you are running the final query upto 3 times, I suggest you run it once , cache the results to...

I wouldnt say that that is an error. SqlServer has shutdown because it was requested to.

Is windows update running ? , check the windows event log for more pointers...

Anyone else going to be at SqlBits this week, have to say ive still got no idea how i got onto the Friday (Well known Speaker ?!?!) day. ...

Well , you could make the best of a bad job by unpivoting (either by using UNPIVOT or using a case statement) the data first to fake a correct structure.

Have you tried it ?

Did it run fine ?

It is possible that you can change the design of the table ?

A table with the structure of

Location

Year

Month

Quantity

Would be easier to process.

Whenever I see a table with repeating column...

Profiler will be fine , as long as only SQL:StmtCompleted events are used and not ...

Just the necessities are kept alive then 😀

Not tough at all , i know exactly WHY that error has occurred.

BUT, i dont know why your instructor has forced that error to occurred.

I do not know what is...

Well , since i dont know what is expected of you (and the point your instructor is trying to make here) im ducking out of this.

You need to go back...

Homework ???? Do i get partial credit ?

Looks like someone else has exactly the same issue

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_26433433.html

Try this link

http://odetocode.com/Articles/70.aspx

Do you have an index on that column ?

Are you reading 100% of the data in table ?

The returned number of rows is irrelevant , what is more pertinent is the source number of rows.

Select distinct SourceDomainName from ITM_Alerts where SourceDomainName like '%CSC%' OR

SourceDomainName like '%BHP%' OR...

Im lumping the multi-statement TVF in with scalar functions, my bad terminology. My 'mental' division is "Multi Statement Function" = Scalar = Bad , "Inline Function " =...