Viewing 15 posts - 4,741 through 4,755 (of 13,876 total)
February 6, 2018 at 6:33 am
Steve has got it right, despite his 'not much of an SSIS guy' disclaimer 🙂
Use a FOREACH loop to process the file, even though you know that there...
February 6, 2018 at 5:50 am
February 5, 2018 at 2:48 pm
February 5, 2018 at 2:43 pm
While I am sure that there are good reasons for doing so on occasions, including DDL to modify your database schema within a stored procedure is not best practice. For...
February 5, 2018 at 10:39 am
February 5, 2018 at 9:12 am
February 5, 2018 at 9:08 am
Can you try changing the connections from project level to package level?
February 5, 2018 at 3:29 am
You posted in the SQL Server 2017 forum. In 2017, Lead is a true SQL function ?
January 31, 2018 at 3:09 pm
UniqueID
Sequence
BeforeStatus
AfterStatus
HistoryStatusDate
Sample data looks like :...
January 31, 2018 at 1:50 pm
This sort of thing should work:CREATE PROCEDURE pr_Prize_Winner
AS
SET NOCOUNT ON;
DECLARE @User_Id INT = (
SELECT TOP 1
u.User_ID
...
January 30, 2018 at 11:28 am
January 30, 2018 at 7:31 am
January 30, 2018 at 7:29 am
Before you go ahead with this, are you aware of possible issues with shrinking databases?
You may like to read here for more information.
January 30, 2018 at 7:13 am
Viewing 15 posts - 4,741 through 4,755 (of 13,876 total)