query should return if 10 continues nos is available in unused state ...

Sean Lange (12/19/2013)

---

vignesh.ms (12/19/2013)

---

Hi There,

Please consider the following data

create table #sampletbl

(

Category varchar(100),

Numbers varchar(100),

Status varchar(100)

)

insert into #sampletbl values ('A','29710000001','0')

insert into #sampletbl values ('A','29710000002','0')

insert into #sampletbl values ('A','29710000003','0')

insert into #sampletbl values...

All I know is ,

It will give us the dirty data ...

(ie)if update is going on, then it would not care about current values.. it will result whatever there on...

PSB (12/18/2013)

---

Fi,

I have a table with the Group name and Total Count by group . I need to add a 'Total' and summation of all counts at the end ....

GilaMonster (12/18/2013)

---

Because it occurs before execution starts....

I agree with...

oh okay...

thanks for the reply

Can I have query for creating triggers to achieve this ???

Thanks. good one teaches me a lot.

Thanks Lowell exactly what i need...

@ Cadavre :

Thanks for your understanding

Please explain how it works...?

Cadavre (11/6/2013)

---

Here's some code that replaces your loop and does the same job: -

-- Sample data

IF object_id('tempdb..#sample') IS NOT NULL

BEGIN;

DROP TABLE #sample;

END;

CREATE TABLE #sample (saledate DATETIME,...

Thanks for your replies friends...

* My query works what I'm intended to do.

* My expectation is I dont want to hard code the date.

I tried myself, following is...

Erland Sommarskog (9/17/2013)

---

In addition to Sean's comment - you also help yourself by using a more descriptive subject line for your post. I've noticed...

Sean Lange (9/17/2013)

---

When something is really urgent it would benefit you to provide more details. Doing this quickly is going to depend on your meaning of quickly. Certainly using a...