Viewing 15 posts - 1,636 through 1,650 (of 3,221 total)
Nice question ... learned something
November 14, 2010 at 8:16 am
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...
November 13, 2010 at 1:33 pm
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...
November 13, 2010 at 8:42 am
Ann Cao
Your welcome.
If it works or does not work - come back and let us know .. so others might benefit from your experience
November 12, 2010 at 4:12 pm
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...
November 12, 2010 at 2:15 pm
GilaMonster (11/12/2010)
Email from BA/architect:
Urgent! Business confirms that it is possible to have more than one X per Y. Out design...
November 12, 2010 at 12:25 pm
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...
November 11, 2010 at 10:51 am
Oops misread what version of SQL being used.
Sorry about that.
November 10, 2010 at 4:39 pm
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 ...
November 9, 2010 at 11:02 am
You can find pleny of examples on this site of code to insert the values from a delimited list into table.
Might I suggest this article by Jeff Moden, complete with...
November 9, 2010 at 9:49 am
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...
November 4, 2010 at 7:59 am
CirquedeSQLeil (11/1/2010)
In case anybody is interested...Steve is Presenting to my UG this Thursday. Meeting starts at 6:30 Pacific Nov 4th.
https://www.livemeeting.com/cc/usergroups/join?id=PPBZ4S&role=attend
Please use meeting ID: PPBZ4S
Thanks for the heads up .....
November 1, 2010 at 4:19 pm
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'. ...
October 31, 2010 at 7:45 am
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...
October 30, 2010 at 9:12 am
Viewing 15 posts - 1,636 through 1,650 (of 3,221 total)