Ninja's_RGR'us (2/22/2009)

---

You're giving up already????

My solution will work, you just need to figure out a way to make a permanent connection to the server without tying up someone or a...

Ninja's_RGR'us (2/22/2009)

---

You're giving up already????

My solution will work, you just need to figure out a way to make a permanent connection to the server without tying up someone or a...

Ninja's_RGR'us (2/22/2009)

---

You can make a script like this and start it... then just forget about it :

while 0 = 0

begin

Delete FROM...

waitfor delay '00:20:00'

end

I don't know any way to...

Thnaks

I bought some database space and I dont have any permission to setup SQL...

Ninja's_RGR'us (2/22/2009)

---

Make a job and schedule it to run every 20 minutes.

Then in the job, simply do a

Delete FROM Orders WHERE datediff... >= 20

Search for datediff in bols for...

Thanks for your quick reply

could you please give me more description, like where i need to write code

Thank You Very Much

It does work.

Thank you very much

It does work

Jeff Moden (6/7/2008)

---

Of course, you also realize how dangerous this is? If you were to change the price on an item list, you would change all orders that referenced...

Lynn Pettis (6/7/2008)

---

I'd have to agree with Jeff. I did take your code, and after some adjustments (my system at home is case sensitive) I have the following working,...

Dear Rum

Query you sent me it doesn't work when I put it on Orders.M1...

ramkumar (6/7/2008)

---

Hi..

Just try like below example..

This is working fine..

-- Suppress data loading messages

SET NOCOUNT ON

-- Create Sample Data using a Table Varable

DECLARE @OrderDetail TABLE

(orderid int,

productname varchar(30),

productqty...

Thanks Ramkumar

Create Order Table query

USE [testSZ]

GO

/****** Object: Table [dbo].[orders] Script Date: 06/07/2008 07:16:14 ******/

SET...

Hi ramkumar

Thanks for your reply, is it possible to get the menu total price automatically?

If yes then how?

Just think Menu1_Price is compute column and would like to get summation from...

thanks everybody

i have done my task, code is below

[font="Verdana"]DaysDelay AS (CASE WHEN SubmitDate IS NULL THEN DATEDIFF(DD, DUEDATE, GETDATE())

ELSE DATEDIFF(DD,Duedate,SUBMITDATE) END ),

FINED AS (CASE WHEN SUBMITDATE IS NULL AND...