Viewing 15 posts - 4,741 through 4,755 (of 13,871 total)
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
I need some help with a project we are working on.
I have a table containing...
January 30, 2018 at 6:57 am
Does anyone know if the latest version of SSDT designer (15.5.1)supports 64 bit providers? ...
January 30, 2018 at 6:49 am
January 29, 2018 at 8:20 am
Mostly I want to know for personal education and understanding, but it seems to me,...
January 29, 2018 at 6:50 am
January 28, 2018 at 3:14 pm
Did you even read my response?
January 28, 2018 at 2:55 pm
2,147,483,647 is the maximum value for an INT, so the error makes sense.
As you have not asked a question, I'm not sure whether that is the answer you were...
January 28, 2018 at 8:47 am
I think that you need to be updating the value of @execimport within your While loop, otherwise the same dynamic SQL will be executed repeatedly.
January 26, 2018 at 11:43 am
Viewing 15 posts - 4,741 through 4,755 (of 13,871 total)