Actually what i was trying to do is ( As discussed in my previous Query) transposing a table which is having 24 Columns and 2500 Rows,

In that case , if...

Am I having a deja vu or is the above post more or less the same as Jonathan already said three posts above????

Not to be offending, but once in a...

I don't know the book and after this review I certainly never will.

But let me say respect for stating your honest opinion instead of writing some nice marketing blahblah!

Default for the server is the last one you connected to.

Default db you set via sp_defaultdb.

One out of two is not bad

I see. I thought you wanted to have those two identical tables permanently.

Thousand posts!!

Big congrats to you, Jonathan

May I ask why you have two different tables with the same structure and the more or less same data in two different databases?

Ok, now I got it.

I'm not sure if I would do this in T-SQL.

Measures of dispersions are measured as the deviations around the mean. The variance and standard deviation,...

For your second question, search this site for crosstab. Should return some scripts that will do this.

For your first question, can you explain a bit more what you mean?

To add to Andy, you should really prefer having multiple small sp_procs rather than passing such a parameter to one generic sp_proc. Why? This should explain it.

Although dynamic sql seem to be a solution, one might be inclined to read this for the pitfalls of that approach. Moreover I would also recommend reading the article...

I would first think about the actual need to change everything.

VARCHAR(n) makes sense when you expect significant differences in the length of the information to store. If that is not...

That one I have already. Next will be to have an include file I pass an array of values (parameters) that returns the recordset to work with.

Does ASP support...

Now that's a nice way to smartly save some typing. Thanks, I'll try it!

John,

Well this is what the microsoft ratbastards passing themselves off as product developers excel at: changing fundamental functionality from version to version and causing people to have to go...