chris.laxdal (11/5/2014)

---

Have you tried setting up the SQL Agent task to use 32-bit runtime? I have seen this many times where it fails to open the package if it...

Just a quick note here for anyone interested, surrogate keys are a data warehouse concept and not in the operational data system. Surrogate keys protect me (for instance) from the...

Is this still an ongoing issue. I wouldn't mind DDL statements with some sample data if so. Are the columns in your where clause properly indexed and statistics current? Could...

Jack Corbett (8/18/2014)

---

If you read the 1st link in my signature and post using those suggestions you'll get more and probably better answers because what you have posted...

The thing to keep in mind is why proxy accounts exist. When you schedule a package, the agent account (by default) on the machine you deployed to runs your IS...

It is good to know the LEFT function is there in the 2012 version, thank you Lynn.

Vimal Lohani (8/17/2014)

---

I didn't find any error with the code :

DECLARE @i TABLE( mychar VARCHAR(50)

,deriv as SUBSTRING(mychar,1,3) --Use this

,newderiv as left(mychar,3));--Or use this

INSERT @i VALUES ('Steve'), ('Stephan'), ('Stephanie')

, ('Sterling'), ('Steppenwolf'),('Ab'),('Abc')

SELECT...

The author of this article makes use of the sql variant. When capturing configuration baseline data one column is the configuration name and another the value. Of course the configurations...

The CTE has a default max recusrion of 100. I can easily create a on the fly set of 100 consecutive days from a start date with something like :...

Most of the time I see systems having Sunday's as the first day of the week, as is the default for the Outlook calendar.

Have a look with this :...

I wonder if they were seeing the issue of a stored procedure returning one of many temp tables/record sets (created within the procedure), depending an an argument passed. If...

You mention that only Sheet1 is where the problem is. Is this because once the package fails you are not able to get to the data flow task for the...

I think there is good potential in BI. From what I've seen there is a want from employers to have a background or understanding of basic statistics. BI turns data...

Take a look at the MERGE operator in Books Online. It will insert into the table when the record is not there and update the DESC or whatever other non-key...

select CAST(sum(saletotal) as money) /NumberofDays;

Should give you the correct significant digits.