Lowel,

That looks interesting, I'm looking for something similar except based on a restore of the database, the reason is that we have a partially locked down Dev box where...

Red gate do an addin for SSMS http://www.red-gate.com/products/sql-development/sql-test/?utm_source=google&utm_medium=cpc&utm_campaign=sqltest&gclid=CKb0gOzo1bICFQMNfAod1kYAkw

Have you seent DataConversion task in SSIS pipes, as this seems to be what you are looking for. simply place it after the extractor, and do the conversion on the...

sorry for not replying sooner.

The Insert and Delete from the table are fairly straight forward, this issue is that you need to be able to move people in sub...

I think to help with the substitution we're going to need sample data, and the rules.

I take it sys_user has a column or lookup to another table to show when...

This should do the trick, but with out example data it might be off the mark, luckily I was at a loose end for an hour or to and pus...

Its really a simple solution with all you need to do is add a column that conactinates the fixed string 'This city name is ' and the Name Column.

Assuming that the fn_GetOrgIdList returns a table then surely You're better doing something.

INSERT INTO @table(ID)

SELECT Table2.ID

FROM Table2 WITH(NOLOCK)

JOIN dbo.fn_GetOrgIdList(@StrId) org on org.<col>=Table2.ParentId

You might get...

SSMSBoost looks interesting, though looking at the list of features you dont seem to get what phil is looking for, and seems very similar to SSMSTools, all be it has...

It would help if you provided the results that you were expecting as there are a couple of ways of doing this.

Using the previous sample data (except that Year is...

Phil,

what about using the Results to File option in SSMS, its a bit cumbersome but should will allow the results to be stored.

Also switch on "Include the Query...

Sorry misread, ignore post..... Caffine needs extra time to kick in on a monday morning.

Eugene Elutin (9/19/2012)

You wouldn't...

I take it that your reports and SSIS use stored procs to encapsulate the logic?

Do you use Visual Studio (VS2008 GDR/VS2010 Premium) database projects for storing your Database code? Or...

The point of XML is to transfer complex data between systems in a uniform way, its not really meant for passing simple data and is overkill for the case given.

If...