Hi,

Try this this will give you the missing ID's.I am Creating and Populating a Tally table and comparing the IDs with it.

SELECT TOP 11000 --equates to more than 30...

Hi Preetha,

Your Query will Replace the Null Values by 0 and not the expected Result.

Thanks for your Support and taking time to help me.

Rajesh

Thanks Vladan,

It worked Fine and i got the expected result,

is there is any other way without doing group by Id to move the column values upwards by using coalesce or...

Hi,

The Following May be useful

declare @Table table (c int)

insert into @Table

select 103 union

select 104 union

select 105

insert into @Table

select 103 union

select 104 union

select 105

insert into @Table

select...

Hi,

Will this be useful or this also fails anywhere/

select count(RESNO) from RESERVATIONROOMS

where checkin not between Datein and Dateout and checkout not between DateIn and DateOut

Regards,

Rajesh

Hi,

Could you provide the table Design along with DataTypes to understand better

Regards,

Rajesh

Hi,

Look at this query below

Declare @Temp Table (Date datetime)

dECLARE @DD datetime,@dd1 datetime

set @dd ='03/01/2010'

set @DD1 = '06/01/2008'

while (@dd1 <@DD)

begin

set @DD1 = (select dateadd(day,1-datepart(dw,'06/01/2008'),@dd1))

insert into @temp

select @DD1

set @dd1 =dateadd(day,7,@dd1)

end

select * from...

can you post your query details,so we will come to know where you went wrong?

Rajesh

Hi,

what about the Datas in each and EVERY Column while Combining?

Do you want to concatenate all the datas in all columns into a single Column

Can you examplain what would you...

could you able to provide some Table declaration along with sample datas and expected Results

It will be better to help you

Rajesh

Hi Prakash,

Have you analysed your Condition before posting ,it is not possible to select only ravi because you have given Inboxenabled for Admin,Dev as Y,

How can the query select...

Hi,

Hope this query will help you,Awaiting your Response

Declare @Value nvarchar(10)

set @Value = (select substring (max(code),7,4)+1 from tableB where code like (select substring (code,1,6)+'%' from Tablea where Code Like 'a%') and...

Hi,

Provide us some TableDefinitions along with sample Datas and expected Results from them along with the conditions to match in the Table to help you in querying

Rajesh

Hi,

Look at the Article, this will help you in passing the tables as parameters into a stored procedure.

http://www.sqlservercentral.com/articles/Stored+Procedures/2977/

Rajesh

Hi,

This code will Help you

SELECT SystemID , Confirmation, MAX (RecordDate) as RecordDate

FROM TimeTable

WHERE Confirmation = 'True' and CameraID not in (select SystemID from TimeTable where recordDate >=(getdate()-2))

GROUP BY...