Viewing 15 posts - 1,186 through 1,200 (of 4,087 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...
March 13, 2018 at 11:09 am
February 28, 2018 at 12:52 pm
Hello SQL Experts,
I have interface with 3 TextBoxs and 3 CheckBoxes that will be...
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
February 28, 2018 at 12:28 pm
February 28, 2018 at 10:31 am
I'm doing this:
...
union
select 'EVY', 'Everyone', ...
from ...
where ... and @Grouping = 'false'
That @Grouping = false still...
February 28, 2018 at 9:17 am
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.
February 28, 2018 at 8:48 am
February 28, 2018 at 8:42 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...
February 28, 2018 at 7:35 am
February 27, 2018 at 1:28 pm
February 27, 2018 at 12:23 pm
February 27, 2018 at 9:59 am
Viewing 15 posts - 1,186 through 1,200 (of 4,087 total)