Viewing 15 posts - 106 through 120 (of 284 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),
...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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.
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 ...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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,...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
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...
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 29, 2015 at 10:16 am
Viewing 15 posts - 106 through 120 (of 284 total)