Viewing 15 posts - 1 through 15 (of 926 total)
Great question, Thanks for sharing.
December 20, 2018 at 5:58 am
There's an article somewhere on the site about using CROSS TAB queries instead of pivots. Search the Articles portion of this site...
Steve is referring to following...
April 23, 2018 at 1:21 am
March 12, 2018 at 8:23 am
March 12, 2018 at 4:24 am
Whole point of creating a dynamic query is to avoid this kind of scenario. So instead of creating a dynamic query with IF ELSE you should be implementing this flag...
March 9, 2018 at 12:43 am
December 18, 2017 at 5:21 am
A calendar table can help a great deal for such working and also some other calculations. Just type Calendar table on the search SSC and you will see tons of...
December 17, 2017 at 11:39 pm
Seems like you have manual partition and your report is a comparison between this two years. Which means you have fair amount of data to play with. How much...
November 22, 2017 at 6:26 am
First thing first, lets format your sp in a readable form so that if someone interested to help, he/she could easily read the code.
November 22, 2017 at 5:51 am
Its looks more like a formatting issue when exported to excel from SSRS. I believe the filter on that particular column contain only one row reset are on the other...
November 22, 2017 at 4:55 am
Well if its not the permission issue (which seems not the case) i would suggest the following method.As the error suggest this might not be the exact issue. there...
November 22, 2017 at 4:30 am
November 20, 2017 at 10:40 pm
November 17, 2017 at 3:59 am
Just want to share few comments might help the OP
If you are running in your ssis package in the Designer mode i.e. in SSDT then you need to...
November 17, 2017 at 3:47 am
Do you have any control on LinkedServer and is it a SQL SERVER ? If yes then you can use sp_whoisactive SQL Server Monitoring Stored Procedure by Adam...
November 17, 2017 at 3:37 am