Forum Replies Created
Viewing 15 posts - 31 through 45 (of 347 total)
-
RE: Permissions for different AD Groups
Current security :
AD Group : Database_Reader
Members : AD Group 1
AD Group 2
Individual User 1
Individual User 2I grant read...
-
RE: SSRS Subscription
The procedure just checks if there is any data returned by the view then send to Person A else Send to person B.
-
RE: Sort already comma separated list
ok. That's what I did. Changed them back to individual rows . Then back to comma separated using STUFF .
Thanks
-
RE: Get count for changed value
Works perfectly . Tried the first solution . Thanks!
-
RE: Sort comma separated value in SQL Table
All right, I have changed the compatibility level to 140 for my database .
I have different Line items for Country column
Astrakhan, Azerbaijan, Kazakhstan, Russia Land,... -
RE: Sort comma separated value in SQL Table
If I change it to 140, will there be any implications ?
Thanks,
PSB -
RE: Sort comma separated value in SQL Table
. Set at 110 -
RE: Sort comma separated value in SQL Table
;WITH Split
-
RE: Sort comma separated value in SQL Table
I need to grab these values from a certain column of a table . Do I need to store these values in variable then USE STRING_SPLIT with sql CURSOR ?
-
RE: Sort comma separated value in SQL Table
Thanks ! This worked perfectly .
DECLARE @SomeText VARCHAR(8000) = 'Astrakhan, Azerbaijan, Kazakhstan, Russia Land, Sakhalin, Uzbekistan, Turkmenistan'
-
RE: Update Row for same ID
It is one table .
-
RE: Update Row for same ID
Thanks, Works perfectly.
-
RE: Update max value in one row rest 0
It doesn't matter about the value of ChangeVal. I want to just update one row with the MAX of Value1 and make all others 0 for each ID.
Similarly update... -
RE: Add missing data
Thanks All. It works perfectly .
Viewing 15 posts - 31 through 45 (of 347 total)