Viewing 15 posts - 5,071 through 5,085 (of 5,096 total)
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...
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...
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...
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....
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...
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...
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...
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...
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.
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?
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.
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!
November 10, 2015 at 2:31 am
Toreador (11/4/2015)
Larnu (11/4/2015)
Asking if you would avoid calling an sp 1MyProc, the simple answer is yes, because you can't do it.
But you can do it - I gave you the...
November 4, 2015 at 3:14 am
Toreador (11/4/2015)
tripleAxe (11/4/2015)
I also agree with these comments above. If they give syntax errors then you have no choice but to avoid them.
You do have a choice - you...
November 4, 2015 at 2:16 am
There are clearly 5 rows in the create table script, if "all" the rows are returned, then all = 5.
October 28, 2015 at 2:58 am
Viewing 15 posts - 5,071 through 5,085 (of 5,096 total)