Viewing 15 posts - 886 through 900 (of 1,464 total)
I will consider these options and see what I can...
February 22, 2018 at 9:55 pm
I was recently assigned to convert an Access database to Sql Server. I have...
February 22, 2018 at 4:58 am
February 22, 2018 at 1:21 am
Des, would be interested in...
February 21, 2018 at 12:31 pm
IF you do a PRINT @SQLPivotQuery
, you will most likely get something like this,[deceased_date], [201801], [201802] as [n1], [n2]
where, in fact, you are looking...
February 21, 2018 at 12:02 pm
Table B
ID Active Values
1 1,2,3,4,5
2 2,3,4,5,6
3 1,6,7,8,6
SO i want to...
February 20, 2018 at 1:00 pm
Can you please provide the test data in a consumable format.
What is your comparison logic and expected output?
February 20, 2018 at 11:31 am
February 20, 2018 at 8:08 am
You may also need to scrub the production data before making it available to dev/qa.
Do your devs REALLY need to see real PI data? GDPR could really bite you...
February 19, 2018 at 1:01 am
Jason A. Long - Saturday, February 17, 2018 6:03 PMDoodad
Wajamacallit
February 17, 2018 at 11:59 pm
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
Viewing 15 posts - 886 through 900 (of 1,464 total)