How do I automatically insert commas between the values that come into the OtherColumns column from the 4 checked columns check1 ,check2 ,check3,check4 ? Thanks

Thanks...Thats exactly what I identified and it worked.

No

Error :

[Microsoft][ODBC SQL Server Driver][SQL Server Mail Sent.

[Microsoft][ODBC SQL Server Driver] String or Binary Data would be truncated.

[Microsoft][ODBC SQL Server Driver]The statement has been terminated.

Thanks Mate..that helped !!

Thats where I guess I need some assistance . Appreciate your response .

Thanks

I am trying to create a report in visual studio and also using sql server reporting services .

Thanks

It gives me this error :

Server: Msg 256, Level 16, State 1, Line 5

The data type int is invalid for the substring function. Allowed types are: char/varchar, nchar/nvarchar, and...

There is no sort in the query.Just a simple select statement .how do I find out the speed of my network connection ?

Appreciate your response. I am sorry , should have mentioned initiall,I am using sql server 2000 /Reporting services 2000 and visual studio 2003 .

Thanks

Appreciate your reply.

Can we change the datetime setting for a particular table or database without effecting other data (table if we are setting for only 1 table or databases...

Appreciate your response.

I cant replace IN with = since I am searching for a value in a list of values.

The exact scenario is I search for a value from...

Thanks for the response but I am kind of confused now .

Can you edit this procedure and tell me exactly what you mean.

CREATE PROCEDURE [dbo].[ABCCDE]

(@inputparam varchar(3))

AS

SELECT DISTINCT

desc...

I have a list of distinct values in Table3.col11 which are part of the IN operator list

IN('A','B','C'....)

From sql server reporting services I will be passing one of values in the...

Yes , thats exactly what I am looking for . I need to search for values which I will pass as a parameter in a list of values. I tried...