Viewing 15 posts - 901 through 915 (of 1,468 total)
Try changing this full outer join fi on bii.bistamp = fi.bistamp
full outer join ft on fi.ftstamp = ft.ftstamp
full outer join pn on fi.fistamp...
February 16, 2018 at 11:13 pm
February 16, 2018 at 10:58 pm
February 16, 2018 at 12:23 pm
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
Viewing 15 posts - 901 through 915 (of 1,468 total)