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.

I had a brief experience with a server showing High CPU usage. With the basic sp_who2 I found the suspect process ID and plugged it into

DBCC inputBuffer(pid)

That clued...

You'll have to tell me about how this is a push to the destination. Normally you query the change data capture tables to see what rows changed and get the...

I am not too knowledgeable on that level. I can say the capture job runs continuously but somehow knows when there is idle time in the system. Only then does...

Hi, I am not clear on your context here. CDC runs on a database where the data is being monitored for changes. How does this relate to your "destination "?

Change Data Capture (CDC) is a SQL job that crawls the sql server transaction log looking for changes. When a change is read it writes an entry to its...