Nice question ... learned something

Sachin.Nandanwar

From Books On Line: (Emphasis added by this poster)

When SET XACT_ABORT is OFF,in some cases only the Transact-SQL statement that raised the error is rolled back and the transaction...

taking into account the comment posted by scott.pletcher Posted Yesterday @ 6:15 PM

The folloing additional code should handle possible duplicates in the input data.

--Create prior entries in xMast

INSERT INTO dbo.xMast(CustomerCode)

SELECT...

Ann Cao

Your welcome.

If it works or does not work - come back and let us know .. so others might benefit from your experience

Not knowing how you transmit the data from the web application, I am imitating with a temporary table (#T) Prior to what is below, I inserted into my...

GilaMonster (11/12/2010)

---

I swear this project is going to drive me to drink.

Email from BA/architect:

Urgent! Business confirms that it is possible to have more than one X per Y. Out design...

chaudharyabhijit

Without the table definition, sample data it is most difficult to attempt to answer your question. Please click on the first link in my signature block to read...

Oops misread what version of SQL being used.

Sorry about that.

Is this what you are seeking:

SELECT DATEADD(mm,-3,DATEADD(day, 1, GETDATE()))As '3 months ago',GETDATE() AS 'Today',

DATEADD(day, 1, GETDATE()) AS 'Today plus 1 day'

Results:

3 months ago ...

Might I suggest this article by Jeff Moden, complete with...

Check out the EXECUTE AS command in Books On Line. Here is a sample from BOL.

CREATE PROCEDURE dbo.usp_Demo

WITH EXECUTE AS 'SqlUser1'

AS

SELECT user_name(); -- Shows execution context is set to...

Thanks for the heads up .....

Looking at the MERGE statement .. be aware that you can use two(2) statements in the WHEN MATCHED action, the gotcha is that each statement must contain an "AND'. ...

Good question ...

NOTE - first I do not have anywhere near the experience and or skill set of most denizens of the thread. In fact I consider myself a "newbie", that...