ooops, I didn't put a space after the quote that preceded the clause DROP. Now I am getting different error that has to do with the fact that one...

So, my statement was very similar, although I was using sp_executesql. (I believe this is interchangeable with EXEC). Also, I believe the word CONSTRAINT is not needed in...

Thank you Siva! I had been working on it and reading about Dynamic SQL for hours yesterday. I'm sure that there will be benefits from doing so but I...

Just got this. Appreciate it. I have read that performance-wise, because cursors operate row by row, that cursor based solutions should be used with care, yet because it...

That's a pretty broad topic, can you be a little more specific about what I'm looking for? It would be helpful also, if you explained whether that will help...

well, mince and dice however you like, it was exactly what I needed. Thanks.

ps. AND made my day, in fact made my two days.

MysteryJimbo, however this doesn't retrieve views that make reference to the column in areas other than column headings. In many cases, my views are not pulling in the...

oh, it's an IN, simple!~:kiss:

Kindly show me the edit that would include stored procedures in the result set:unsure:

Unbelievable. Beautiful. I plugged my column name into variable and voila, totally awesome. Thanks.

post moved to general sql server 2008 forum

wonderful! Thank you.

I like your own creativity.

The only additional thought I have is to automate your solution with SSIS which will apply the formatting to each file in a folder, so that...

I just put Conditional Split back on the palette and I remember the problem: It will only allow one arrow for output. So, am I to use two conditional...

Funny, ha ha 🙂 I was using these exact ones for that problem with some difficulty. Now I know I was on the right track.

I will work on...