Quick thoughts, do you have an XSD for the XML? If that exists then it's normally the best starting point for modelling the database schema.

😎

Bulk loading the XML into...

Greg Edwards-268690 (1/21/2016)

---

Steve Jones - SSC Editor (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

It seems he has an elephant on the menu, and a 6 quart pot to cook it in.

But refuses to start...

Sergiy (1/21/2016)

---

MMartin1 (1/21/2016)

---

That would make sense since this table is a heap. The ID column is not really an identifyer in this situation. We are not recommending a practice of...

Here is how

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TEST_STRING NVARCHAR(4000) = N'ABCDEFG?Ô?1234567Ò???HIJKLM]? ?NOP??60987654321';

;WITH T(N) AS (SELECT N FROM ( VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS X(N))

, NUMS(N) AS (SELECT TOP(LEN(@TEST_STRING)) ROW_NUMBER()...

Identify them or simply remove them?

😎

Quick suggestion

😎

select

A.a

,A.b

,DENSE_RANK() OVER

(

...

Roust_m (1/20/2016)

---

Hi,

I am planning to un-partition and decompress some large tables to be able to use standard edition of SQL Server.

Given that not clustered indexes get rebuilt when a clustered...

chuck.forbes (1/20/2016)

---

We're re-examining our database server security architecture, as we are starting to migrate our older databases to MSSQL 2012 and 2014. One of the Developers mentioned that a prior...

+1

😎

Didn't want to open that Pandora's box

Eric M Russell (1/20/2016)

---

Here you go. It's entirely possibly for multiple rows, or multiple columns within the same row, to tie for having highest date, so it will potentially return...

Sorry Gail, didn't see your post, makes mine look kind of daft:-P

😎

bebe022476 (1/20/2016)

---

How to optimise the following query, it's doing a Clustered Index Scan (Clustered).

select document.DocumentID as 'document.document.id',

document.DocFolderID as 'document.document.folderID',

document.FileName as 'document.document.description',

document.FileSize as 'document.document.fileSize',

document.ModifiedDate as 'document.document.modifiedDate',

document.TableName as 'document.document.tableName',

document.EntityCode as 'document.document.entityCode'

from...

below86 (1/20/2016)

---

You could use something like this to just find the max date of those columns, it won't get you the column name though. I found this on another...

abdellahmoh2016 (1/20/2016)

---

HI ALL

I'm new in T-SQL so i need your help

My problem is : After deleting a row , is there a way to retrieve the ID of that row...

Jacob Wilkins (1/20/2016)

---

If all we care about is the max date for each ID, it should be close between those and the CASE, if the CASE version is also modified...