Viewing 15 posts - 1,471 through 1,485 (of 5,109 total)
No, T-SQL doesn't permit the OVER clause to be defined anywhere else other than in the expression that requires it. That will mean repeating it, if you have multiple columns...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 8, 2018 at 3:22 am
Please advise
I get this error twice every week and does not look like a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 8, 2018 at 1:58 am
one of...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 8, 2018 at 1:43 am
It seems like you're looking for a reason, rather than having one. Based on the little detail we have, it seems there's little reason why you wouldn't add the index.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 7, 2018 at 9:33 am
Does the index have a significant improvement? If it does, what reasons do you have to not add it? Why do you beleive that the report will never have any...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 7, 2018 at 9:05 am
Only just noticed this, but for those that still have 2012 instances and use SSDT, be careful about updating your version. I just noticed that V15.8.1 removes support for SQL...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 7, 2018 at 4:54 am
For SQL Server 2008 you'll needs BIDS on VS2008 (which, if i recall correctly is on the installation media for SQL Server 2008(R2)). For SQL Server 2016, you can use...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 7, 2018 at 4:44 am
I agree with Phil here, I don't see anything wrong with your query. You can compare columns regardless of their names and datatypes (just that with the latter implicit conversions...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 7, 2018 at 2:46 am
If you want to find out where the data is coming from then best thing to do would be to open the SSIS Project in the relevant version of SSDT....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 7, 2018 at 2:31 am
In the documentation for the latest servce pack released last week it states that the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 6, 2018 at 5:35 am
That's very open to injection as well, you should be using QUOTENAME, not wrapping the object names with brackets ([]); the latter can easily be got around. I'd recommend using...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 3, 2018 at 8:51 am
Jo Pattyn - Friday, November 2, 2018 10:29 AM
Looks like that...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 2, 2018 at 11:16 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 2, 2018 at 9:50 am
GilaMonster - Friday, November 2, 2018 9:27 AMFunctions need the schema name.
Not sure that's actually the case any more Gail (at least...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 2, 2018 at 9:44 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 2, 2018 at 3:55 am
Viewing 15 posts - 1,471 through 1,485 (of 5,109 total)