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...

This is...

Here is another addition to the code, identifying the gaps more efficiently.

😎

USE TESTDB;

GO

;WITH BASE_DATA AS

(

SELECT

ST.STG_ID

...

There are few options and which is...

Not much of a change needed from last time, adding a second conditional in the last part to allow for missing HardDrink did the trick.;-)

😎

USE tempdb;

GO

CREATE TABLE #TEMP (UserName varchar(20),Drink...

ChrisM@Work (9/5/2014)

---

Eirikur Eiriksson (9/5/2014)

---

ChrisM@Work (9/5/2014)

---

Meatloaf (9/3/2014)

---

Hello,

I trying to figure out the logic to add a number to the end of an ID to create a series.

For example, I have an...

It is more a question of...

Quick question, can you post the two execution plans?

😎

More for fun, I'm tossing three more spanners in the works

😎

USE tempdb;

GO

/********************************************************************

Sample data

********************************************************************/

DECLARE @SAMPLE_DATA TABLE

(

SD_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED

...