Viewing 15 posts - 106 through 120 (of 283 total)
You can try this and see if it does what you are looking for.
declare @t table
(
MD_key int,
Provider_ID int,
FName char(10),
...
September 15, 2015 at 11:28 pm
2 things jump out.
1. Why do you need to use cast or convert if the data type is already smalldatetime?
2. I (and this is just me speaking) never use a...
September 15, 2015 at 5:41 pm
I'm not to good at theoretical queries based on partial information. Plus, the question as posed, generates more questions which could be answered by clicking on the link in my...
September 15, 2015 at 4:05 pm
sqlfriends (9/9/2015)
I should change a little in my original post with the bold part.Could you explain a little bit?
thanks
If you have a = 3 and b = 4 before the...
September 9, 2015 at 3:28 pm
pietlinden (8/26/2015)
Nice solution, but where did OrderDate go?
Slight oversight on my part!:-P
Looks like the OP was able to make the necessary adjustments.
August 27, 2015 at 6:45 am
sdownen05 (8/26/2015)
Now I want to run a query that will give me these results:
OrderDate JobNumber ...
August 26, 2015 at 7:48 pm
ramana3327 (8/26/2015)
Hi,Is there any affect of using readuncommitted while it is RCSI other than dirty reads?
Why even get near the problems associated with dirty reads and/or missing data? Since you...
August 26, 2015 at 3:48 pm
kk.86manu (8/19/2015)
Hi All,I have requirement to do an update + insert operation and planning to use MERGE statement.Are there any limitations or known issues with MERGE?
Here are a couple of...
August 19, 2015 at 3:58 pm
If the ordering is indeed the alter_msg, then I would create another table to define the sorting method. Hard coding each possibility could quickly become a nightmare! :w00t:
Here is a...
August 1, 2015 at 3:42 pm
Please do not cross post. It fragments the thread and any answers you may receive.
Click on this link for original thread.
http://www.sqlservercentral.com/Forums/Topic1707709-2799-1.aspx
August 1, 2015 at 1:22 pm
Please do not cross post. It fragments the thread and any answers you may receive.
Click on this link for original thread.
http://www.sqlservercentral.com/Forums/Topic1707709-2799-1.aspx
August 1, 2015 at 1:19 pm
sushantkatte (8/1/2015)
the o/p should look like
first row - 873939, 'Meter', '7/24/2015 3:31:22'
second row - 873939, 'Tamper', '7/24/2015 3:30:00'
third row - 873939,...
August 1, 2015 at 1:16 pm
My brothers and I consider the movie Independence Day to be one of the great comedies of our time!
Jeff Goldblum gets to the Mother ship, he is able to dock...
July 3, 2015 at 3:03 pm
jcobb 20350 (6/29/2015)
In all the posts, I completely missed the solution posted by LinksUp. This works great. Thanks so much.
Glad it helped.
When you get SQL 2014 installed, you can use...
June 29, 2015 at 5:04 pm
jcobb 20350 (6/29/2015)
I don't think LEAD LAG is quite the answer though. I looked at Pinal Dave's...
June 29, 2015 at 10:16 am
Viewing 15 posts - 106 through 120 (of 283 total)