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...

CREATE TABLE [dbo].[MYTABLE] (

[MYDATE] [smalldatetime] NULL ,

[MYDEPT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[MYNUMBER] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[MYAMOUNT] [int] NULL ,

[MYTOTALAMOUNT] [money] NULL

) ON [PRIMARY]

GO

Thanks

Thank you,

It does return the required results.

Data type is char(12) does not allow nulls .

Eg of a few primary keys...

3BQWDL0000K0

3BQWEB0000K0

3BQWEX0000K0

Is there any formula behind it that is generating this ? If so how do I find...

Thanks..But the issue is I would like to track the changes that have already been done . Not from now. Basically I want to track the past. Any thoughts .

Thanks!

Yes exactly I want to trace the activity of a particular database role(StoredProcExecutor) .Audit everything for the past week . Who used it etc.I am looking for something easier other...