Thanks for the response. That's not exactly what I was asking. I know how to get data out of a database using an OLE DB source into a variable or...

Here too is an article from Kim Tripp on the topic: http://www.sqlmag.com/blogs/sql-server-questions-answered/sql-server-questions-answered/entryid/76182/dynamic-sql-vs-option-recompile

trevor.howe (4/7/2011)

---

Hi

I have been trawling the web to find out if there is a way to create a simple string manipulation udf that returns a variable length string after the...

To rename login someone to someone_else:

ALTER LOGIN [someone] WITH NAME = [someone_else];

To rename database user someone to someone_else in database some_database:

USE [some_database]

GO

ALTER USER [someone] WITH NAME = [someone_else] ;

misiekbest (4/7/2011)

---

Hi.

Question is simple. What does sqlsrv engine do with table after truncate command?

Someone told me, that it just rename that table (internally?), create new one and drop renamed...

Well,...

It sounds like CTEs might help you avoid staging tables and allow you to get results with one pass over the data...but it's hard to tell. I am sure it's...

The aggregate I posted will not prevent duplicates from entering the concatenated string. You can however provide the DISTINCT keyword. The example in my attachment has this query:

SELECT DocID,

...

Not surprising given the usual finds on the internets but the CLR code would not compile out the box...however after some polishing the little nugget works.

Mark, sorting is a can...

I hear ya Jeff...I am planning on addressing Mark's question and testing the CLR method for performance...it would be cool to have this as a drop-in but I must admit...

Your original post references a file with a .csv extension...did you switch to using a real Excel Workbook file?

David is going to get you there...but you completely missed that I added a...

Brandie Tarvin (4/7/2011)

---

Wow. I wonder if they had permissions to reprint that article. I found it yesterday at Simple Talk.

Or maybe it was the guy at Simple Talk who...

Great, I am happy you found a solution. Would you mind posting what you did so others who find this post from a search engine can benefit as well?

Nope...I think you;re good...misunderstood what you were doing. You can open the package you saved out of the I/E Wizard in Visual Studio and continue to build it out using...

JimS-Indy (4/6/2011)

---

@ninja -- I'm an old guy. Be nice to me.

My issue is with scope. I lose the SS variables when the query is executed. What's the strategy for...