Overwriting it probably just forced a rebuild on the execution plan. That's probably the only difference. I'd have to see the function and any related tables to get...

If you have a Numbers table, you can select from that, and join it to a count from your reports table.

select Number as Hour,

(select count(*)

from reports

where report_date >= '1/1/2009'

and report_date...

It's looking for a table variable in that case. That's why you're getting the specific error.

Yes, you can do this, but what you have to do is build the...

Iterating through the parameters would definitely be better. Heck, even I managed to do that in an Access app I used to operate, and I'm far from a skilled...

You'll need to modify this a bit to get exactly what you want for columns, but it does the job on the sequence and should be easy enough to make...

Why does James come before Kevin in the desired output? Why split that department (Development) in two and interject Web in the middle?

chris.warriner (10/14/2009)

---

Hi, this is an interesting post for me as I am one of the "newbies" that perhaps one or two of you may be referring to. I am not...

"For XML" should be able to do the XML conversion you need. Then (as mentioned), bcp would allow you to automate the export.

I'd need more details on table structure...

You could use the Pivot operator to turn the rows into columns and then you'd get rid of the sub-queries. I don't see a way to get rid of...

That seems like a fairly trivial issue for a recursive CTE to handle. It also looks like homework, though that could just be a side-effect of you annonymizing the...

What problem are you having with it? I just tested a variation (since I don't have your table or your data, I can't test exactly what you're testing), and...

In the upgrade process, are you setting up a test environment and putting the database and all its procs through their paces?

If so, you'll know with total certainty that this...

You have valid points. It does cost some bandwidth, and resources. RAM does have to be allocated to hold null values that will never be populated. I...

Grant Fritchey (10/13/2009)

---

Since most of the denizens of The Thread are not on Twitter, I should spread the word here as well. In my absolute dictatorial power as no one...

I'd say go ahead and include them. It means a little extra RAM being allocated, but it doesn't hurt anything beyond that.

It allows the dev to build a more...