Viewing 15 posts - 4,306 through 4,320 (of 5,109 total)
Ok, well if it's your 2014 installation that has a problem then you're using the wrong software, you're attempting to use the SQL server 2012 installer to repair a 2014...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 3, 2017 at 6:18 am
Jeff Moden - Friday, February 3, 2017 1:01 AMHave I mentioned that I'd like them to stop deprecating and discontinuing useful stuff? 😉
I...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 3, 2017 at 3:40 am
My only concern with BWFC's is if the OP's data includes numbers other than 4 and 0.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 3, 2017 at 3:10 am
sqlquery29 - Friday, February 3, 2017 3:02 AMCan i do it without using PIVOT ?
Yes, as your Width and Length have defined...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 3, 2017 at 3:08 am
Why are you storing comma delimited strings in a table? It's really not a good idea.
I've got it working using the DelimitedSplit8K function, but what is...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 3, 2017 at 2:52 am
You've posted in the SQL Server 2014 forum, but your message box is for 2012. Are you running the correct Installation Centre for your Version? I assume you have tried...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 3, 2017 at 2:26 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 2, 2017 at 8:44 am
The result set you're getting is to be expected. You're trying to assign multiple rows to a single variable. Thus the result from the final row is assign (In this...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 2, 2017 at 8:39 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 2, 2017 at 8:31 am
Let me elaborate a bit more. We've not had a lot of information on your SSRS report set up, so I'm running on guesswork here however.
I assume you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 2, 2017 at 8:28 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 2, 2017 at 8:22 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 2, 2017 at 7:58 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 2, 2017 at 7:51 am
Does @TS have a value of '', or does it not have a value (NULL)? To test for an empty value (variable or field), you need to use@Field IS...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 2, 2017 at 7:28 am
SELECT T1.ID,T1.NUMBER,T1.DESCRIPTION,
CASE WHEN T2.GRADE='0000000822' THEN T2.VALUE END AS GRADE_LENGTH,
CASE WHEN T2.GRADE='0000000823'...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 2, 2017 at 7:25 am
Viewing 15 posts - 4,306 through 4,320 (of 5,109 total)