Viewing 8 posts - 1 through 8 (of 8 total)
Guys, thank you both for your insight and direction. January 18, 2019 at 10:32 am
Would creating case statements be a better approach? I've looked into Transpose functions and Pivot but still can't seem to get the output. How about looping through the set of...
January 17, 2019 at 1:27 pm
To fahey.jonathan - Yours does give me accurate counts but the OpName...
January 17, 2019 at 10:42 am
To Jeffrey Williams 3188 - Thank you, but that originally...
January 17, 2019 at 10:08 am
The reason I have T1.OpName commented out in the 2nd insert was to not have the Operator Names appended to the same column already existing. I would need to create...
January 16, 2019 at 1:55 pm
The database type is Oracle that we have a linked connection to in Microsoft Sql Server Management Studio. We also have Oracle Sql Developer running on our server that we...
April 13, 2017 at 8:30 am
Thank you for the helpful tips SSChampion. I do care about my code, very much so. It has been a rough year learning as I go. The company I work...
April 13, 2017 at 6:34 am
Direct on the server in SQL Developer its only about 30 seconds quicker. SQL server with the query above takes 3-4 minutes. This query is running inside ADO connection...
April 12, 2017 at 4:53 pm
Viewing 8 posts - 1 through 8 (of 8 total)