Viewing 15 posts - 2,941 through 2,955 (of 5,109 total)
How about using LAG?SELECT *,
CASE WHEN LAG(Orderid) OVER (ORDER BY orderid, seq) = prev_orderid THEN LAG(quantity) OVER (ORDER BY orderid, seq) END AS Prev_quantity
FROM...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 8, 2017 at 10:47 am
SSMS 17.2 is the most recent version and is compatible with all currently supported versions of SQL server (2008 - 2017).
It's unlikely you're going to get any...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 8, 2017 at 10:42 am
Out of interest why did you start a new topic, when you have asked the question 5 days ago and others had answered? Were those answers not good enough, did...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 8, 2017 at 10:35 am
When you say "it does not work", what do you mean? Are you presented with an error? Does the Constraint no actually drop? Does the SQL Server crash?
Personally,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 8, 2017 at 10:31 am
Could you explain your logic here? Why are Developers linked to the Maintenance and Director roles, why is Admin linked to Food Servies (Should this be Services?) and Manager? Why...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 8, 2017 at 10:26 am
You say you received an error when trying to re-enable the sa account. What was this error?
Do you have any other accounts that have sysadmin privs? Generally, if...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 8, 2017 at 10:11 am
What do you mean by "suppose another table"? Does this mean the table does not exist at this moment in time and we need to imagine that one does exist?...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 8, 2017 at 10:02 am
mjdemaris - Saturday, October 7, 2017 4:13 PMExcuse my ignorance, but what is that and where do i find it?
In SSIS (in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 8, 2017 at 6:28 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 7, 2017 at 4:10 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 7, 2017 at 5:14 am
I made the assumption that a call ends on WrapUp. It's a common term...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 11:31 am
Thanks Chris, but the problem was resolved. One with changing a single part of the WHERE to = 0, rather than != 3, and then my most recent post an...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 11:25 am
Thanks, but that table definition doesn't match the table you've provided. Could you please provide CREATE and INSERT statements that work together?
I've had a look at your data,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 10:15 am
Could you provide a CREATE statement for your sample data please?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 9:48 am
Thom,
This poster will first need to determine duration from multiple records within a given...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 9:39 am
Viewing 15 posts - 2,941 through 2,955 (of 5,109 total)