Are these imported using a DTS Package? Do you do a straight copy or do you manipulate with any scripting?

Just cleaned my closet and I had none anymore.

Had

2 Microsoft Shirts

1 Imceda

1 Backup vendor can't remember

However I do still have SQLServerCentral.Com shirt from Orlando (2004) SQL Pass which I still...

I would most likley use a query with GROUP BY and as I recall GROUPING (sorry not BOL right here) to help setup something like this

Invoice  Description Amount...

Try adding PRINT lines in your SP to output the parameters to verify what you are putting in is behaving correctly. Maybe

PRINT '' + IsNull(@Parm1,'IMNull') + ''

so if param1 is...

You might be able to create a local group on the Windows server the sql server is on with the same access as the folks access the current SQL server...

Have you tried the SP from QA to be sure it is the SP first?

Yes, I too Google, and I am ashamed to say I am adicted to Google. Start the 12 step program angain in an hour (take 12 steps back, turn and...

Not sure what Date represents as it looks like when no item the amount is the sum of the related invocies.

Invoice  Line     Amount  Date

1A                25      8/23/2007

1A       Item1   ...

Try breaking it down an see if any particualr line breaks it or if all are failing. Basic concept you have looks right. Are you sure you are passing NULL...

Check out

http://technet2.microsoft.com/Office/en-us/library/5d90076f-bbcc-48c1-a569-bd236862d47c1033.mspx?mfr=true

The section "Port requirements for SQL Server Analysis Services" should help for 2005.

This should b the right method

EXEC INTO #Temp sp_help_jobstep

Oh do keep in mind you need to test further as you thought you had a solution with removing the clustered index and found it ultimately failed. Could be something...

In testing I have actually seen the switch /3GB as smaller physical memory levels prevent Windows from starting. We tried the other options and always found the performance never changed....

If I think of or come across anything else I will pass along.

SetFocus as best as I can determine is a training company and they do charge a lot for their coursework. They offer it for free if ou are willing to...