BCP is a good candidate for this kind of work. It can...

bozzybox (4/7/2011)

---

Thanks for all the replies. Looks like what I am trying to do is not do-able in SQL Server.

As requested by Mr or Mrs. 500, here is an overview...

That's good info, thanks for your responses.

Do you have any experience using the technique? Can you speak to how well it scales?

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...