DTS is probably considering the column a string, while in your format file you have it specified to a numeric value. You may have to import the column as...

As Matt said, I would not hard code the % sign. I would send a string, with percent signs, if needed.

exec searchfilterbycolumn2 'Sale','%Title%'

This way if you do not need...

Your query looks good. Thanks for the clarification though. I was a little confused :hehe:

I am not sure I understand what you are trying to do. You say that you want a subset of data, but you also want to return all the...

How big is your largest udf_value and do you ahve any special formatting in the nvarchar return?

I would simply use a different method. This one works quite well. Note that if you do not filter the routine type you will return functions and stored...

Ah, so you just need to make the data in columns 1,2,3,5, and 7 null.

UPDATE TABLENAME

SET COL1 = NULL,

COL2 = NULL,

...

VARCHAR(MAX) stored 2^31-1 or 2gb of data. Nvarchar(max) holds the same amount of data 2gb but actually holds half as many characters. This is because unicode characters require...

If you should choose to store images in the database versus storing image paths, you can use the new datatype varbinary(max). You can insert an image into your table...

I am not quite sure what you are asking for. You can drop columns by using...

Adam Haines (2/19/2008)

--------------------------------------------------------------------------------

DECLARE @IDString VARCHAR(MAX)SET @IDString =(SELECT (ID) + ','FROM MYTABLE--WHERE FILTER CAN GO HEREFOR XML PATH(''))

This leaves a trail comma. I usually do something likeDECLARE @IDString VARCHAR(MAX)SET @IDString...

Your absolutely right, somehow my code got stripped. ...

That is because it thinks the type is an integer. Try casting it as a varchar.

SELECT CONVERT(VARCHAR(10),MYCOLUMN)

or

You could even try to pad and convert the column

SELECT RIGHT('0000000000' +...

You cannot pass a table variable into a stored procedure using SQL Server 2005 (that I am aware of); however, this feature is available in SQL Server 2008.

article

http://www.sqlservercentral.com/articles/News/3182/

I agree with John. For the specs you are suppling, it sounds like you want to produce a SSRS report. SSRS allows you to group data together without...