Viewing 15 posts - 2,971 through 2,985 (of 5,111 total)
I'm not sure that is correct. For example, one item I noticed is:IF GETDATE() >='2018-01-02' AND GETDATE() <'2017-01-03'
How can the current date be both greater or equal...
October 5, 2017 at 3:25 am
This sounds like what your trying to do is make some parameters display only if required, but if they are making them compulsory. SSRS does not support "optional required" parameters,...
October 5, 2017 at 3:18 am
October 5, 2017 at 3:01 am
Thanks for the suggestions. Thanks a lot.
One thing, came into my mind,...
October 5, 2017 at 2:36 am
The reason for this is that due to data type precedents. In your UNION statement all the values are in the same column and you are providing integers...
October 5, 2017 at 2:24 am
October 5, 2017 at 2:00 am
October 4, 2017 at 4:19 pm
yrstruly - Wednesday, October 4, 2017 11:26 AMIt is SQL SERVER 2014!
SSMS 2017 is compatible with all currently supported versions of SQL...
October 4, 2017 at 4:15 pm
Most likely you didn't select it as part of the Installation items. SSMS was removed from the Install process from SQL server 2016 and and SSMS 2017 is free to...
October 4, 2017 at 11:19 am
Although I'll admit, maybe it is a bit odd, but it is easy to add a constraint on a JSON column:--Create sample table
CREATE TABLE SampleJson (JsonString...
October 4, 2017 at 8:47 am
One method, using Jeff's DelimitedSplit8K function:WITH PT AS (
SELECT *
FROM t3
CROSS APPLY dbo.DelimitedSplit8K (t3.c1,'|') DS)
SELECT...
October 4, 2017 at 5:39 am
October 4, 2017 at 4:18 am
Dear all,
I have a problem when trying to rename a package name. I get this...
October 4, 2017 at 3:55 am
October 4, 2017 at 3:53 am
October 4, 2017 at 1:43 am
Viewing 15 posts - 2,971 through 2,985 (of 5,111 total)