yes there is no actual addition I just want to move selected b data to a after moving data the table b should not hold whatever is moved to a...

ok I have a table named Order_A, which has data stored in it which has columns as shown in query

SELECT [OrderID]

,[OrderDate]

...

Lowell (5/27/2010)

---

i formatted your SQL and converted it to use some CTE's;

look at the final sql and tell us what is not working: how is the data incorrect?

WITH t2 AS...

Hari.Sharma (5/27/2010)

---

I guess your OR conditions should be placed inside parenthesis "()"

But I dont understand why are you replacing characters from both left and right side since its same in...

hey any clue on how to add this query in above procedure

after select query.... it should update saying:

UPDATE B SET hotemailflag = 1 where ISNULL(available_qty,0) = 0 and ISNULL(available_qty_temp,0) =...

it should be like this " select count(*) "

THANKS IT HELPED AND WORKS NOW

Dan.Humphries (5/6/2010)

---

Something like this

DECLARE @tableHTML NVARCHAR(MAX);

SET @tableHTML =

N'<H1>Hot Item(S) out of Stock <H1>' +

N'<table border="1">' +

N'<tr><td>Brand Name</td><td>Category Name</td>' +

N'<td>Product Name</td><td>Color Name</td>' +

N'<td>Color Code</td><td>Sizes</td></tr>' +

CAST ( ( SELECT td =...

Dan.Humphries (5/6/2010)

---

Declare a varialbe as int

set the variable to count of records with your where clause so something like this.

Select count(*) from yourtable where column=cluase

then add an if statement before...

i have one problem how i can implement if result set is null in this stored procedure than it wont sent out any email...

DECLARE @tableHTML NVARCHAR(MAX);

SET @tableHTML =

N'<H1>Hot...

I used one of the column having date and ADDDATE so it works... thanks for reply

thanks, I understand that

well I dont have time stamp in my table I want to generate resultset using select and providing condition like what happened in last hour

I appreciate you all for replying... thank you!!

adalberto-339588 (5/5/2010)

---

Try this one and let me know.

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'ebayOchkee',

@recipients = 'adventorworks@gmail.com',

@query = ‘SELECT categoryname,brandname,productname,colorname,colorcode,psizename...

not more hardly in 100's