It takes maybe 30 min to learn,

putting your sql into stored procedure not only makes you application more secure but you won't have to dive into your code if any...

Easiest way is to simply write insert into table1 on target database select data from table1 on source database

Better would be use of SSIS packet

This little project has been terminated since we'll be getting new projects in on Monday.

I'll be posting the entire code and files later today, so that those that are interested...

This little project has been terminated since we'll be getting new projects in on Monday.

I'll be posting the entire code and files later today, so that those that are interested...

This little project has been terminated since we'll be getting new projects in on Monday.

I'll be posting the entire code and files later today, so that those that are interested...

Yeah more or less came to the same conclusion,

a way to solve my issue would be to let the stored procedure run and put the result in a temp...

Is there a way to do this, calculate the size of the resultset in kb/mb

I've been thinking is there a) way to calculate the size a temp table has

and b) a way to cap the size of a temp table

off course the new...

Those that have looked at this thank you.

A quick test on my part

DECLARE @SQLa nvarchar(max)

DECLARE @ffd varchar(1)

DECLARE @fvd varchar(1)

DECLARE @s1 nvarchar(max)

DECLARE @t2 nvarchar(max)

DECLARE @FilterFields nvarchar(max)

DECLARE @Filter_Values nvarchar(max)

DECLARE @Database nvarchar(max)

DECLARE @Table...

Did a quick test

DECLARE @SQLa nvarchar(max)

DECLARE @ffd varchar(1)

DECLARE @fvd varchar(1)

DECLARE @s1 nvarchar(max)

DECLARE @t2 nvarchar(max)

DECLARE @FilterFields nvarchar(max)

DECLARE @Filter_Values nvarchar(max)

DECLARE @Database nvarchar(max)

DECLARE @Table nvarchar(max)

DECLARE @j-2 nvarchar(max)

DECLARE @k nvarchar(max)

SET @ffd = ','

SET...

Just tested it, and the null doesn't even cause problems.

DECLARE @rc int

DECLARE @SelectedColumns nvarchar(max)

DECLARE @Database nvarchar(max)

DECLARE @Table nvarchar(max)

DECLARE @Rows int

DECLARE @FilterFields nvarchar(max)

DECLARE @Filter_Values nvarchar(max)

-- TODO: Set parameter values here.

EXECUTE @rc...

no the dynamicsqlfilter2 can never return more then 1 column

Since it just does the following

What's the datatype passed (@par)

Is @f3 which would be the filtervalue correct for the...

I don't know where I read it anymore & don't have the linke, as for calculating it daily i don't think that's an option as some databases on our server...

The new stored procedure, a whole lot more elegant and readable then the last version.

USE [master]

GO

/****** Object: StoredProcedure [dbo].[DynamicSQL3] Script Date: 12/15/2010 10:26:16 ******/

SET ANSI_NULLS ON

GO

SET...

Since this will in the end all serve to make a semi-dynamic report, so there might be many requests (I read somewhere that the use of datelength could affect network...