You're right. I may have jumped to conclusions about what the generic columns here represented.

If you don't need it proceduralized, you can also use sp_helptext to quickly get that information.

ex.

exec MyDB.dbo.sp_helptext myView

exec MyDB.dbo.sp_helptext myProc

I should point out that #NewThings is itself not normalized (Metric1 and Metric2 should really be distinct rows in a separate table). That said, you can unpivot this data to...

What's the nature of the function you're trying to apply to the data? As Koen says, using functions against large sets of rows can have serious performance implications. If you...

Nevermind, I found the answer to my own question. From BOL...

"When an option is not explicitly specified, the current setting is applied. For example, if a FILLFACTOR setting is not...

Ah, that's right. All the non-clustered indexes would end up being re-built essentially twice; once after the drop, and once after the re-creation, rather than just once if you drop...

Firstly, you actually dont need the "Use ?" at the start. sp_msforeachdb effectively assumes that as it iterates through the database.

Also, unless you actually need those strings exactly as you...

Thanks guys, those look like good places to start. I'll check them out!

No problem . Again, sorry if its sort of complex looking sql. I'm not much of a reporting guy, so Report Builder and SSRS are not my forte. If I...

Hi Yvonne, I hope this is helpful. Unfortunately, I am very much a SQL coder, which may be a detriment in this scenario, given that you are not, but I've...

Mac1986, are you trying to aggregate the rows or the columns?

i.e are you trying to aggregate...

4216,2|4215,2|4280,5|4282,3

4271,5|4094,3|4216,1|4215,1

4276,5|4216,2|4215,2|3964,2|4215,1

4271,5|3994,3|4216,1|4215,1|4215,1|4215,1

or

4216,2|4215,2|4280,5|4282,3

4271,5|4094,3|4216,1|4215,1

4276,5|4216,2|4215,2|3964,2|4215,1

4271,5|3994,3|4216,1|4215,1|4215,1|4215,1

Thanks Sean,

I'm actually already familiar with that splitter. I'm just playing around with his data and seeing what I can do to help.

You probably need a string splitter and an unpivot. let me see what I can come up with.

To my dismay, I used to be an IT Recruiter before seeing the pearly white light of database development. If you happen to be going that route (i.e. through a...

What you're describing is a union. If you are truly just looking for

ID,

FirstName,

EventType,

Event Location

then you can perform you union on just those. You don't need...