Viewing 15 posts - 3,136 through 3,150 (of 4,820 total)
Sue_H (10/7/2016)
sgmunson (10/7/2016)
October 7, 2016 at 7:47 pm
Finally got past the version difference by editing the package on the server where it was failing, and then after a couple other quick edits, it worked okay. ...
October 7, 2016 at 1:08 pm
Well, I've now discovered that the versions of SQL Server are just slightly different. Here are the version details:
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Feb 10 2012...
October 7, 2016 at 12:08 pm
The moment you said "almost the same code", I had to conclude that there's no way to know if the changes might have caused your grief or not. ...
September 21, 2016 at 4:52 pm
I know this topic is a bit old, but I'm wondering if anyone can recommend a particular testing platform or particular website that does SQL testing, whose results have been...
August 4, 2016 at 7:15 am
This will do the job:
DECLARE @a AS TABLE (
[Type] varchar(30),
SubType varchar(30),
dates date,
datesdiff decimal(19,4)
);
INSERT INTO @a VALUES('a','ab','2016-04-01',0);
INSERT INTO @a VALUES('a','ab','2016-04-01',2);
INSERT INTO @a VALUES('a','ab','2016-04-01',3);
SELECT *
FROM @a;
SELECT REPLACE([Type], CHAR(9), '') AS [Type], SubType,...
May 6, 2016 at 1:45 pm
What if I don't want to log to a file, but instead just have the output go into the text you see in Job History, as well as seeing it...
April 8, 2016 at 5:04 pm
PJ_SQL (3/23/2016)
SSIS package runs from when I execute it manually or from VS. But it fails from the agent with the truncation error.What could be the issue?
You didn't say whether...
March 23, 2016 at 9:52 pm
jewel.sacred (3/22/2016)
I would be very happy if there will be such a simple solution, but this is not giving the desired results. 🙁
How about the following:
CREATE TABLE #Data (
PrimaryKeyID INT...
March 22, 2016 at 11:45 am
Just wondering if you've got some NVARCHAR data that is a problem because of the data length, or perhaps there's data in production that's not in your testing instance?
March 21, 2016 at 1:10 pm
Your query uses T-SQL language features that are NOT a part of SQL 2008. Perhaps this needs to be posted in the forum appropriate to the version of...
March 21, 2016 at 1:08 pm
Check to see what security context the SQL Agent uses to run jobs. If it's not the same as when you run in SSMS, that might be your problem...
March 21, 2016 at 12:52 pm
drew.allen (3/10/2016)
sgmunson (3/10/2016)
March 10, 2016 at 9:53 pm
You're welcome. Enjoy... Some thoughts on potentially improving its performance:
1.) Perhaps generate the additional 6 months in the 2nd CTE instead of in the WHERE clause...
March 10, 2016 at 10:39 am
I don't have a 2012 instance handy, or I could have tried using LEAD or LAG with some GROUP BYs, but here's a query that only uses 2008 syntax that...
March 10, 2016 at 9:20 am
Viewing 15 posts - 3,136 through 3,150 (of 4,820 total)