Viewing 15 posts - 901 through 915 (of 1,464 total)
You have a classic Catch_all type query.
GilaMonster as a great blog post about this.
This type of code is true for every record in the table/index,...
February 14, 2018 at 3:59 am
You can look at the following SQL Functions to assist you in transforming your data
ROUND
CEILING
FLOOR
February 13, 2018 at 5:12 am
February 13, 2018 at 5:02 am
February 5, 2018 at 11:06 am
The expected results that you provided do not match the data that you provided.
From the sample data, how do we know that 'a1117' and 'a1120' both map to...
February 2, 2018 at 11:10 am
HappyGeek - Friday, February 2, 2018 9:16 AMHome
Base
February 2, 2018 at 9:21 am
The LAG function was introduced in SQL 2012, which would allow you to do it like this
SELECT [Emp ID], [time]
, [prev time] =...
January 31, 2018 at 9:47 pm
Since this is a SQL 2008 board, I am assuming that you are 2008.
The following should give you the correct resultsWITH cteTime AS (
...
January 31, 2018 at 9:45 pm
January 29, 2018 at 9:23 pm
Why not use a table-value type as a parameter. Then you simply select from the parameter into the destination table
January 23, 2018 at 10:40 pm
Viewing 15 posts - 901 through 915 (of 1,464 total)