Viewing 15 posts - 1 through 15 (of 25 total)
July 5, 2018 at 9:32 am
July 5, 2018 at 9:14 am
Yr
...
July 5, 2018 at 8:56 am
Ok thanks Jeff.
With regard to Paul's code or the Cross Apply you have to pardon my ignorance as I have not used either before. So using my prior query...
July 4, 2018 at 1:23 pm
As in a select of the 60 million rows without any DISTINCT or group by from the #Paid temp table?
As I am using a temp table to pull...
July 4, 2018 at 11:51 am
Jeff I will certainly look info this. I know the process with my IT department to get something through code review and in to production is a very long process.
July 4, 2018 at 9:23 am
As I was afraid....it looks like I am limited to SELECT permission. Attempted to create a view and got the dreaded....
CREATE VIEW permission denied in database
July 3, 2018 at 9:15 pm
Thank you Jeff. I will look through the information on indexed views and attempt to implement. I also need to make sure that I have permissions to create views. If...
July 3, 2018 at 9:11 pm
After reading some other forum posts I am thinking that I might be able to write the metric ranges (High, Mid-High, Mid-Low, and Low) to variables. Would that be the most efficient...
May 10, 2018 at 1:09 pm
I apologize if I did not providing enough information. By not working I mean I am getting an error stating "incorrect syntax near the keyword group".
To demonstrate the error I have put...
October 14, 2017 at 5:14 pm
October 3, 2017 at 3:59 pm
October 3, 2017 at 3:30 pm
Unfortunately, my permissions do not allow me to get the query execution plan otherwise I would provide. The #Product table has one record per Id. The Detail and Payment tables...
October 3, 2017 at 3:20 pm
That is why I was hoping that I could put the values from the LIKEs in a temp table, and then incorporate it into the join as the values versus...
August 21, 2017 at 2:13 pm
Viewing 15 posts - 1 through 15 (of 25 total)