Uhhm....guys...this may be asking for too much..... :crazy:

But, can send "some kind of a response" to the client...

dwain.c (5/11/2012)

---

Vinus - I think there's a simpler solution with no need for dynamic SQL in the trigger.

--drop table temptable

Create Table temptable (id int not null primary key, val1...

These are the queries based on your requirements:

--Creating Table

Create Table Ex

(RecNum Int,

Patient_ID int,

Patient_FirstName varchar(10),

Emp_ID int,

Emp_FirstName varchar(10),

App_Datetime DateTime )

--Inserting Sample Data

Insert Into Ex

Select 1, 1234,...

anthony.green (5/11/2012)

---

this will do the job with the sample data provided, but if you dont know the logic then we can only guess at what you want and how it...

sachince61 (5/11/2012)

---

I have a table with two column

out put date is like this...

mnemonicId customerID

1402 140201

1402 ...

ACinKC (5/10/2012)

---

Mebbe he was sitting in an interview for a DBA position and had to post to SSC quickly to get the answer...someone walked in just as he was about...

Thanx Jeff. The link was very useful.

Is this better Swan?

--Creating Tables

Create Table Ex

(id int not null primary key Identity(1,1), -----=====Identity Column is required for...

This will do it:

--Creating Table

Create Table Ex

(IDint,

FileCount int,

FileSize int,

Country char(1) )

--Inserting Sample Data

Insert Into Ex

Select 1,2,150,'X'

Union ALL

Select 2,9,500,'A'

Union ALL

Select 2,2,100,'B'

Union ALL

Select 2,3,200,'C'

Union ALL

Select 2,1,50,'D'

Union ALL

Select 3,10,800,'P'

Union...

This might work:

select

Count(case when void = 0 then count(ID) Else NULL end) as Countofsuccess,

Count(case when void = 1 then count (ID) Else NULL end) as countoffailure

from test

If you are...

Thank you very much.

Seems like "WaitForDelay" was what I was looking for.

You're welcome. 🙂

Sean Lange (5/9/2012)

---

vinu512 (5/9/2012)

---

Are you implying that you need a Trigger?

here is something that I worked up. Hope it helps:

--Creating Tables

Create Table Ex

(id int not null primary key Identity(1,1), ...

drew.allen (5/9/2012)

---

vinu512 (5/8/2012)

Todd's Logic is very nice. Didn't hit me when I was trying it.

But it was just lacking something.

I tweaked it a little and got it working. 😀 Here's...

OK Jeff.

I was expecting it to work the other way round. It can be really useful. 😛

Thanks 😎