For completeness, here is a complete solution to the problem using the method I posted earlier and the sample data set posted.

😎

;WITH QUERY_BASE AS

(

SELECT

...

DAVID.MANGATAL (9/7/2014)

---

I use SSIS Business Intelligence Development Studio 2008R2 to handle ETL tasks from relational databases and flatfiles.

One client has asked me to extract from a third parties RESTful API...

In short: A clustered index can be thought of as the structure of the table, it can only have one structure at the time. In other words, it determines the...

Here is an example code demonstrating a method but not a solution. For a full solution, follow Lynn's advice on supplying further information.

😎

USE tempdb;

GO

;WITH SAMPLE_DATA(ACTIVITY_DATE) AS

(SELECT ACTIVITY_DATE FROM (VALUES

...

Luis Cazares (9/7/2014)

---

Isn't that...

Just a thought, what about the ability to rate questions? Could be something like "splendid question" all the way down to "interesting" or "PICNIC".

😎

...but it works for Joe in HR (that's his default schema);-)

😎

Luis Cazares (9/7/2014)

---

This is like torture. I'm at the office, unable to watch the first games of the NFL season and can only see all the spam promoting supposed pages...

Some options on the Enterprise edition, in case of a very large set, an option would be to export the content of the attribute...

Depends on how large, system specs, tempdb configuration etc. A general answer given that it is an untyped XML would be...

srikanth.baskaran (9/7/2014)

---

Dear experts,

Im new to sql server and got stuck in the following .

Ive a stored procedure A which has data has a result of split function from a column...

Quick thought, it's likely that this is not a problem of any sort, if the action is...

lvbntapasvi (9/6/2014)

---

Hello All,

I am new to SSIS, and have started using it from the past 3 weeks. I have a task where in I am supposed to access the flat...

sakthikarajen (9/7/2014)

---

thank u...you helped me a lot..:-)

one more query....

now in case i want to update my xmlfile i.e i want to add an <result> after <abstract>...how do i perform?

if i...

There is a more efficient method of solving this problem by partitioning the set on the log-in-out action. When a driver is logged in, it increments the login sequence by...