Viewing 15 posts - 1,186 through 1,200 (of 4,085 total)
Use GROUPING SETS. The example is based on Piet's sample data since you didn't provide your own sample data. It will be more efficient if you use the grouping sets...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
March 13, 2018 at 11:09 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 28, 2018 at 12:52 pm
Hello SQL Experts,
I have interface with 3 TextBoxs and 3 CheckBoxes that will be...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 28, 2018 at 12:35 pm
declare @SearchVal varchar(10) = '1234.00'
select 'yes'
where @SearchVal NOT LIKE '%[^0-9.]%'
AND @SearchVal NOT LIKE '%.%.%'
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 28, 2018 at 12:28 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 28, 2018 at 10:31 am
I'm doing this:
...
union
select 'EVY', 'Everyone', ...
from ...
where ... and @Grouping = 'false'
That @Grouping = false still...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 28, 2018 at 9:17 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 28, 2018 at 9:06 am
Part of the problem you were running into was your choice of using PIVOT instead of the more flexible CROSS TAB, which Luis used.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 28, 2018 at 8:48 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 28, 2018 at 8:42 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 28, 2018 at 7:53 am
You treat your output as a single field and create a delimited file. The delimiter separates fields and there are always one fewer delimiters than fields, so if you are...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 28, 2018 at 7:35 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 27, 2018 at 1:28 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 27, 2018 at 12:23 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 27, 2018 at 11:12 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 27, 2018 at 9:59 am
Viewing 15 posts - 1,186 through 1,200 (of 4,085 total)