Viewing 15 posts - 4,921 through 4,935 (of 4,949 total)
Hi All,
Is anyone able to suggest which driver/files I may be missing to be able top get this operation to start running locally again? I've not had much success so...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 22, 2016 at 3:43 am
Environment did change late last month, as we installed sharepoint designer on my PC, but we removed it later on, as it didn't meet our needs. That did seem to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 12, 2016 at 7:52 am
dfine (12/29/2015)
ALTER TABLE dbo.MySales ALTER COLUMN orderstatus VARCHAR(20);
OPTION 4 will fail as there is no such column in the table.
+1
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 30, 2015 at 2:48 am
Jeff Moden (12/1/2015)
You don't need OR. Please see the following article.
Mmm, you're right, I should really be using a case statement instead to be honest, only one trip to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 2, 2015 at 2:07 am
GilaMonster (12/1/2015)
No, but generally a better (easier, less prone to errors) way of getting a DB from SQL 2008 to SQL 2012 is backup/restore. Is that an option?
What we've been...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 2, 2015 at 1:55 am
There is a Web service task which you can call the Web Service from, and a File System task which can copy files.
You'll need to configure each node appropriately for...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 1, 2015 at 9:59 am
faulknerwilliam2 (12/1/2015)
I have tried:
WHERE ...
AND ((job.orderdate BETWEEN (@odate1) AND (odate2))
OR (job.completeddate BETWEEN (@odate1) AND (odate2)))
Which nearly works in that it brings through the correct completed total....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 1, 2015 at 9:40 am
What happens when you click the link to amend the subscription? I can't say I ever experienced this issue when we had SQL 2008, however, it sounds a bit like...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2015 at 9:37 am
Resender (11/30/2015)
I've solved it by making a duplicate of the requested report with the filters they wanted.
Hmm, do you mean you created a second report? If your report could be...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2015 at 9:29 am
FridayNightGiant (11/26/2015)
Larnu (11/26/2015)
Unless I'm doing something funny, when I run D, I actually get 27/11/2015 (when i run it for this year, sorry, I forgot to mention that). Just me?
It...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2015 at 2:25 am
Managed to fix this in the end by exporting to a .doc rather than a .docx. not really ideal, but it solves the problem. I'm guessing it's a problem with...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 27, 2015 at 4:31 am
Are you running enterprise? If I recall correctly Conditional/Dynamic subscriptions are only available on Enterprise, not standard.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 27, 2015 at 2:10 am
Unless I'm doing something funny, when I run D, I actually get 27/11/2015 (when i run it for this year, sorry, I forgot to mention that). Just me?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 26, 2015 at 3:23 am
Does anyone know what edition this is likely to be shipped with? I'm guessing enterprise, but I can live in hope that it might be the BI or Standard.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 16, 2015 at 2:10 am
You could also use format (as below), if using SQL Server 2012 or later.
where js.next_run_date = cast(format(GETDATE(), 'yyyyMMdd') as int)
Cheers!
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 10, 2015 at 2:31 am
Viewing 15 posts - 4,921 through 4,935 (of 4,949 total)