If I try to use what I showed it fails. I get an error on WO.dtCall, says multi-part identifier could not be bound.

Thanks

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...

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...

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...

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...

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...

UPDATE:

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...

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 lack of...

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...

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...

• This reply was modified 4 years, 8 months ago by YSLGuru.

15 replies already And here I was initially concerned this might be a dumb question to even ask

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...

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...

• This reply was modified 4 years, 9 months ago by YSLGuru.

FYI...

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...

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...