Viewing 15 posts - 3,106 through 3,120 (of 5,109 total)
Ahh, I see what you're saying now: you worded your post easlier as if to say that LAG was returning multiple results, which it is not. You mean you want...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2017 at 5:08 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2017 at 4:09 am
P.s. It's always important to post in the forum that is relevant for...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2017 at 4:07 am
LAG isn't a command available in 2008, it was first brought in in 2012, so the above should have presented you with an error.
You'll need to JOIN back...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2017 at 3:31 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2017 at 3:14 am
Are you really still using SQL Server 2000? That version hasn't been supported for over 4 years now. If you had a more recent version (2012+) you could easily achieve...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2017 at 2:44 am
What are the errors you receive? We can't run your SQL and we don't have access to your data, server or environment, so I'm afraid only supplying your SQL doesn't...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2017 at 2:41 am
SELECT
[SqlParameters].value('declare namespace ns="http://www.any.com/WebFramework/WorkflowParameters.xsd"; (/ns:Parameters/ns:Addendum2)[1]','varchar(50)') AS TEST
FROM [WorkflowInstances]
but erring on...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 19, 2017 at 9:03 am
The MT* tables will likely only have values for Branch 3 and 0 (or they should do!). 0 being the live branch and 3 being the test. If they're on...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 19, 2017 at 6:06 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 19, 2017 at 2:43 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 4:10 pm
Yes, you can. There are a lot of examples on the internet on how do so. I, myself, have to Google everytime I work with XML, as the syntax never...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 12:52 pm
You can install both SSMS 2016 and 2012 on the same machine, yes. Not sure why you would want to install an older version though, as SSMS 2017 is compatible...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 10:07 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 8:51 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 8:26 am
Viewing 15 posts - 3,106 through 3,120 (of 5,109 total)