Ok from lookups on google I've learned that set-based will work on the entire set and not row by row.

For me this is quite a new concept, so I'm not...

OK,

I believe set-based query to split my columns was already in my stored procedure

SET @truncatedChar = REPLACE(@SelectedColumns,',','')

SET @occurenceChar = (LEN(@SelectedColumns) - LEN(@truncatedChar))

...

WHILE (@counter < @occurenceChar +...

bump

Ok reading it now

Found also what went wrong when I clicked the link it went to http://www.sqlservercentral.com/Forums/www.sommarskog.se/dynamic_sql.html

I have read the areticle and seen some good idea's to prevent...

Server Error

404 - File or directory not found.

The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.

Is what i get from that...

The @SelectedColumns are passed along to the stored procedure

In the example

'ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone, PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate'

Are the...

Example on Adventureworks

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 = [master].[dbo].[DynamicSQL2]

...

The udf IsGetal will check fo the filter function if a value is a real number, since we can get filters on fields with money stored in them we want...

The udf dynamicSQLFilter2 will give the sp dynamicSQL2 the filter back along with an error message if needed. (Atm this function can pick up int,float,varchar and datetimes filters)

USE [master]

GO

/****** Object:...

OK First is dbo.DynamicSQL2

Please note its a work in progress so if you things that could be better done, please note but I'm also working on it.

DynamicSQL2 builds the...

Yeah I should clarify a bit, the parameters for the stored procedure are: Selected Fields, Table, Database, number of rows,filter fields and filter values.

If the number of rows is 0,''...

Ok I was wondering the same thing

OK the first problem has been result

It gives off an error since refresh of an input box by parameters gets refreshed when hitting enter.

So maybe I should replace the input...

Ok I now understand a few things I wasn't getting

For instance I was getting errors on cl_ix, and I hadn't the fogiest idea why.

So now that I know why, I...

checking if the connections are available is the priority

the script to loop through all connection managers will help with that

see my boss claims the following

let say you have a...