Viewing 15 posts - 3,346 through 3,360 (of 5,109 total)
Just chiming in here, but want to understand something. In your original post you mention you want the load "this month and last month's". So, for the current month that...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 8, 2017 at 7:30 am
Ok, maybe I should elaborate a bit more.
With the sample data you provided, and solution I gave, you received the correct answer (good). However, when applying it...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 8, 2017 at 2:19 am
Thanks for the reply
How do I reinstall the feature ? I know how...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 8, 2017 at 1:50 am
[/quote]
Been prepping for this...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 7, 2017 at 10:11 am
gazy007 - Monday, August 7, 2017 8:54 AMApologies Thom, Please see attached file.
That's one table. Your above SQL has 7. Where are...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 7, 2017 at 9:57 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 7, 2017 at 9:39 am
12GB isn't really a lot for a SQL Server. Especially if you have SSAS, SSIS and SSRS all on the same instance. YOu also say you have RAM ring fenced...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 7, 2017 at 9:23 am
Most of the stuff I work on are request from other staff members, which has to go through a web application we use. This normally works fine, as the staff...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 7, 2017 at 9:19 am
DDL, Sample data and Expected output is really important here. I'll need all of this, showing the problem you're having to be able to trouble shoot. You're returning data from...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 7, 2017 at 8:06 am
You can upgrade VS now if you wanted. VS 2015 with SSDT 2016 can deploy to SQL Server 2012+, you just need to ensure you select the right TargetServerVersion in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 7, 2017 at 7:27 am
A repair isn't a reinstall. Have you tried uninstalling and reinstalling the feature?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 7, 2017 at 4:04 am
Nevermind, what I was working on suddenly wasn't wanted anymore just after I made the above post. Love it when that happens :D.
Again, this is untested : Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 7, 2017 at 3:32 am
The only way I can really see this, unfortunately, is by using a Cursor. This isn't quick, and thus I'd strongly recommend Changing your set up (I'm not sure that...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 7, 2017 at 3:15 am
Also, that SP wide open for injection.
Edit: Ok, honestly, that entire SQL is a mess. You have a table [Employee] and a SP called [Employee] You can't do...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 4, 2017 at 12:53 pm
What is your question here exactly?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 4, 2017 at 12:51 pm
Viewing 15 posts - 3,346 through 3,360 (of 5,109 total)