Since SSIS isn't designed to run interactively, I would recommend running this as a report in SSRS, so that users can pass in the required date as a parameter. ...

Without seeing your data, I'd be just guessing. But I think you need a splitter function. Search for that and see whether you find anything that helps.

John

Mark

It's not just performance - if columns are added to or removed from a table then your application may break.

But with regard to performance itself, get a copy of your...

GO isn't a T-SQL command - it's a batch separator. It's recognised by SSMS but not by many other providers. When you use EXEC('...'), you're not running your...

Right-click on the table in SSMS and go to the storage tab. You'll see the size of the table and the number of rows: from that you can calculate...

Have a look at this. Make sure you do this on a test server.

John

Yes, as you acknowledge, you never quite know what you're getting when you use the GUI, which is a good reason to shy away from it in many circumstances. ...

OK, so for the operation to be allowed, you need City to be other than Sandnes, or you need P_ID to be other than 0. So just change the...

I think he's confused his requirement: he mentions "already inserted rows" and "already inserted columns" almost in the same breath. I think Gianluca's solution will work for him; alternatively...

Have a read through this[/url].

110 is the compatibility level for SQL Server 2012. You need to change to it to ensure you can use all the new features.

You can...

You'll need SQL Server to be running under a domain account on the source server and for that account to have write permission on the share.

RESTORE FILELISTONLY won't restore the...

Unless there's something I've missed, I think you just need to use the REPLACE function.

John

Don't know whether this[/url] helps?

John

To make it more flexible, you might consider doing it like this:

SELECT 'databaseA', columnlist FROM databaseA.dbo.table UNION ALL

SELECT 'databaseB', columnlist FROM databaseB.dbo.table UNION ALL

SELECT 'databaseC', columnlist FROM databaseC.dbo.table UNION ALL

etc...

I...

Have you looked at extended events? I don't know if it's possible to do what you're trying to do, but it's worth investigating.

John