Actually, your code is working just the way it is supposed to based on how it is written.

Would you please take the time to explain what it is you are...

As this is posted in a SQL Server 2005 Forum, the following will work as well:

if object_id('tempdb..#TestTable') is not null

drop table #TestTable;

create table #TestTable (

...

Phil Parkin (3/9/2013)

---

daniel-johnsson (3/8/2013)

---

Hi Phil,

Yes that is exactly what I want to accomplish. Basically that I have Audit_ID with identity (1,1) that works as a PK in my Audit table...

Okay, I was just curious as I haven't looked at Always On as yet. Thanks for the tip.

Why a copy only full backup? Why not a normal full backup?

How about you provide us with the code you have written so far in an attempt to solve your problem.

We are volunteers on this site, willing to help you in...

What component(s) are you using and what edition of SQL Server are you running?

Don't apologize for your post. I've looked at the code you posted, it's just that there isn't enough there to really work with. Since we don't know the...

No promises as you did not provide the DDL for the tables or sample data:

SELECT DISTINCT

[Rxo].[SYS_ID]

, [Rxo].[PATIENT_ID]

, [Rxo].[DESCRIPTION]

, [Rxo].[RX_NUMBER]

, [JRxf].[MAX_FILL_NUM]

, [Rxo].[PT_CASE_PHYSICIAN_SYS_ID]

, CONVERT(VARCHAR(12) , [Rxo].[DATE_WRITTEN] , 110) AS DATE_WRITTEN

,...

Was actually talking to Sean and his code subtracting 1 millisecond.

Sean Lange (3/8/2013)

---

Erin Ramsay (3/8/2013)

---

So you're just looking to update each date to the end of the day?

Will this help you get started?

declare @datefield datetime

set @datefield = GETDATE()

select @datefield originalDate,...

Would help if we know what the income record looked like for one. Also, if you could provide the DDL (CREATE TABLE) statement for the table, the sample data...

Sean Lange (3/8/2013)

---

That is because you concatenate values to the previous subject each pass through the loop.

Change you loop to this.

--@emailSubject = @emailSubject + @sku

...

GilaMonster (3/8/2013)

---

Lynn Pettis (3/8/2013)

---

GilaMonster (3/8/2013)

---

opc.three (3/8/2013)

---

You know I am...

Need to see the code that builds this table: dbo.tbl_STOCK_safety_check