try this.

SELECT S.IssuedDateTime,

S.ResponseId,

Convert (int, MAX(CASE WHEN S.DisplaySequence = 1 THEN S.Response END)) AS DailyReading

SUM(Convert (int, MAX(CASE WHEN S.DisplaySequence = 1 THEN S.Response END)))

FROM z_v_Information

WHERE ResponseId <= S.ResponseId

GROUP BY S.IssuedDateTime, S.SurveyResponseId

Order...

try this.

select * from #temp where empno in (select top 1 empno from #temp where empno > (select top 1 empno from #temp))

Assume #temp is table instead of EMP.

thanks,

vijay

hi,

You can create parameter in reporting services. I hope you know how to create that. Say u have some date parameter - named it as @startdate and @enddate. when you...

hi,

can it work with varchar(7999)

declare @test-2 varchar(7999)

is ur @test-2 variable store more than 8000 character?

regards,

vijay

Hi,

Just refer to following link as well.

http://www.sqlservercentral.com/articles/Administering/sqlserverjobscheduling/2288/

regards,

vijay

Hi,

I hope you already prepare stored procedure which does whatever you want. You can easily schedule this stored procedure into Job.

Just go to Jobs in Mannagement studio and schedule -...

Hi,

i know how to find about MVP. it is given on microsoft website. Select appropriate technology and it will give you list.

https://mvp.support.microsoft.com/communities/mvp.aspx

Along with that we can find out how...

Hi Steve,

it was typing mistake. sorry about it. i m in UK. so i can say when number starts from '07%' or '7%' then it is mobile number only. Home...

Hi Lynn,

Yes i read it when i started to post my query in this group. I will better do it for this kind of situation because in some cases it...

I have both opened. We have some server on 2000 and some on 2005. so can use 2005 and enterprise manager as well.

When i take jason's code i need...

Hi,

Right. i have one table that is phonenumber which is live table. it having id, mobile, home, and work number. Now i need to find out how many person gave...

Hi,

Yes Lynn. you are right. It works. I said i m not sure because i never come up with the situation.

It is just bracket. ()

DECLARE @DB varchar(25)

DECLARE DBCursor CURSOR...

Hi,

I dont care about Home number or work number. I do care about mobile number only. When i take backup from main phone number table, i can only those ID...

Here you go

CREATE PROCEDURE [dbo].[VD_TEMP_0506] AS

DECLARE @DB varchar(25)

create table #t ([name] varchar(50))

insert into #t

SELECT [Name]

FROM master.dbo.sysdatabases

Where [name] like '%NCR%'

...

Hi,

I believe cursor dont like order by. I am not sure. But i tried to run same thing and it didnt work. What you can do is before your cursor...