Viewing 15 posts - 1 through 15 (of 707 total)
Will do. Currently the report that uses the existing non-pivot query takes up to 5 minutes to render on screen even though the source query it uses completes within a...
May 6, 2022 at 2:02 pm
Thank you for replying. After posting this I tried searching via google for the answer and to my surprise the search terms I used were correct, somethin that rarely happens...
May 5, 2022 at 6:27 pm
UPDATE: Since getting back from being out sick I've not had a chance to catch up on all the feedback for this post but I did want to take a...
June 25, 2021 at 8:43 pm
Thank you all for taking time to provide feedback. I haven't been able to go thru these yet because I'm out sick but I did want to take a minute...
June 21, 2021 at 7:38 pm
Thank you to everyone who took time to respond. My point of the post was to verify that every plain/vanilla Begin (a BEGIN that is not followed by something like...
June 18, 2021 at 2:53 pm
I was able to successfully connect today from with VS2015. I selected (from the Menu) Tools>>Add SQL Server and it let me add and connect to this SQL Server I...
March 4, 2021 at 5:29 pm
The MS Doc I'm using for these SQL commands is https://docs.microsoft.com/en-us/sql/t-sql/statements/create-login-transact-sql?view=azuresqldb-mi-current
I really appreciate your replying but there is a disconnect somewhere and I'm sure its because of my...
February 5, 2021 at 5:53 pm
Jeff - We're still in the mock-up stages of this so I don't have any actual DDL to share but I did make a mock-up in Excel of what the...
January 28, 2021 at 5:10 pm
Steve - The problem is if I try to use that in the same query as traditional aggregate like Min and MAX it throws a fit because PrimaryKey is not...
January 8, 2021 at 5:35 pm
15 replies already And here I was initially concerned this might be a dumb question to even ask
November 17, 2020 at 5:58 pm
I think its what Brian Gale is speculating, personal preference/style. We use an accounting software package that is for a very vertical market and to my knowledge their philosophy is...
November 16, 2020 at 5:40 pm
Nope. The source code I was reviewing was exactly as I showed I just replaced the literal names with dummy variables. It had no BEGIN~END and for the life of...
November 14, 2020 at 1:43 am
Per recommendation I created 3 temp tables by breaking up the 3 queries and adding an INSERT command to create temp tables. I then compared the 3 temp tables using...
November 11, 2020 at 8:03 pm
Not that it matters for this but just to be clear this is not something I made and if we figure out whats wrong with it I can't make any...
November 10, 2020 at 9:44 pm
So could not upload the XML plan as a txt file so I'll see if it will let me do it if its archived (winrar)
So the site will not let...
November 10, 2020 at 4:30 pm