Viewing 15 posts - 16 through 30 (of 182 total)
The select in your CASE is just selecting @valicolName as text. As a result, SELECT DISTINCT @valiColName as
SELECT DISTINCT @valiColName as
FROM DIM_Product is functionally the same...
January 25, 2019 at 2:00 pm
I don't know if this will solve your particular problem, but in the past I've had some luck with aligning objects by placing them in Rectangles.
January 24, 2019 at 3:17 pm
WHERE Val IS NOT NULL gives you your expected results. However, in your example, 1003 doesn't look like a NULL value - it is just the word "Null." The query...
December 5, 2018 at 2:13 pm
AFAIK this is nature of the beast with MHTML output. All the MHTML subscriptions I have arrive with resized and smooshed columns, and it's just something I have to tell...
December 3, 2018 at 3:50 pm
For question 2, there shouldn't be any problem keeping two versions of Visual Studio. I have both 2005 and 2008 on my workstation (yeah, I know, we're supposed to be...
August 16, 2018 at 2:41 pm
You're treating everything as INT, but there must be a VARCHAR field in there somewhere. Here are the fields you are treating as INT - are they all in fact...
June 11, 2018 at 1:23 pm
When you successfully export other reports to Excel, are they in .xls or .xlsx format? Excel.xls files have a 65,000 row limit, and for many years that was SSRS's export...
May 31, 2018 at 12:47 pm
The IIF statement doesn't look like it follows the conditions, but it's hard to be sure. You have an OR in your conditions that could parse a couple of different...
May 3, 2018 at 4:31 pm
This is a VERY clunky way of doing it, but in the past I've put something like this at the begin of my query:IF @paramA IS NOT...
April 10, 2018 at 1:44 pm
Have you tried passing the dates in 2017-09-30 format instead of 9/30/2017? Depending on the language settings, SQL or SSRS could be interpreting the dates as DD/MM/YYYY..
March 21, 2018 at 1:30 pm
It returns three rows because they all match your WHERE clause. The question is by what logic do you expect to only get your single result? Do you only want...
March 16, 2018 at 12:44 pm
if(@years_old = 4 and @Gl >= 15)
January 8, 2018 at 4:12 pm
My impression is that all 12 will run concurrently. AFAIK this won't cause any extra subscription blockage, just the usual "multiple processes accessing the same data" blockage. These are just...
December 27, 2017 at 1:23 pm
I don't think the header needs to have the same number of boxes as the tablix. It's just that the ends of the header box should line up with columns...
September 15, 2017 at 1:07 pm
OUTPUT needs to go between the DELETE and WHERE:
Delete from X OUTPUT DELETED.[PKey], DELETED., DELETED.[C], DELETED.[D], DELETED.[E], DELETED.[F] INTO Ywhere X.Pkey...
August 30, 2017 at 3:30 pm