Viewing 15 posts - 901 through 915 (of 1,469 total)
Firstly, there is no need for a cursor to do what you are trying to do.
As a rule of thumb, cursors should be avoided.
The following SQL will...
February 17, 2018 at 9:35 am
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
Viewing 15 posts - 901 through 915 (of 1,469 total)