Viewing 15 posts - 1,711 through 1,725 (of 5,109 total)
NikosV - Thursday, August 23, 2018 11:28 PMQuick question, what does CASE WHEN THEN 1 mean? What's the THEN 1 doing exactly?
It's...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 24, 2018 at 1:34 am
The fact that they are using it suggest that the view (I assume it's a view with a suffix of _vw), performs poorly with the new estimator. I think the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 23, 2018 at 10:06 am
It's the users you need to change, not the logins. A user is a database object, while a login in Server based.
You could use some dynamic SQL to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 23, 2018 at 9:24 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 23, 2018 at 4:41 am
I can't see any sample data in your SQL, only DDL definitions. I'll need sample data and expected results too please (note that many users, including myself, are unhappy to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 23, 2018 at 3:05 am
Really need to have sample data and expected result now. And, if you have 2 status it can be, have you considered using IN in the CASE expression?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 23, 2018 at 2:37 am
YOu really need to get away from using a subquery for EVERY expression (I.e. a WHERE, a JOIN, etc it's awful practice and makes your SQL very difficult to read....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 23, 2018 at 1:56 am
Have you tried anything so far? If not, consider the simple + operator and FOR XML PATH. Have a go, and if you get stuck please do reply with your...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 22, 2018 at 1:36 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 22, 2018 at 10:50 am
sikka.sourav - Wednesday, August 22, 2018 9:51 AMI don't have access to BCP. Can we do it using Procedure ??
SSIS then? Otherwise,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 22, 2018 at 10:02 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 22, 2018 at 7:53 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 22, 2018 at 3:59 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 21, 2018 at 2:31 pm
It's worth noting that if you've upgraded your instance to 2017 (from 2016 or prior), Microsoft also recommend you regenerate your Service Master Key. To quote the documentation: Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 21, 2018 at 1:20 pm
SUM(CASE WHEN...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 21, 2018 at 12:58 pm
Viewing 15 posts - 1,711 through 1,725 (of 5,109 total)