OTF (5/22/2013)

---

phc (5/18/2013)

---

I have gotten a bit further on by nesting a query, but I am not sure I have the distinct right

SELECT C.first_name"Provider", Count(C.provider_no) "Diabetics with over 1 BP...

Sergiy (5/8/2013)

---

Alan.B,

I think you missing the point.

The question was not about use of XML in real life, but about why we cannot store XML files using good old nvarchar/ntext data...

Shadab Shah (5/7/2013)

---

Hi all experts,

Every now and then i am learning something new in SQL Server. Latest in that series is XML Datatype. While learning XML datatype i came to...

Thanks Ben and sorry for the late reply. I am able to find 8.5 (and 7.0) via download but not 8.0. Not a big deal, thanks for checking!

Eddie Wuerch (4/27/2013)

---

This is pretty much what the NTILE() windowed function is for - equally dividing a results set into x number of pieces. Unlike throwing calculations at the min...

What I have here won't be a complete solution but...

This is a tricky one. You could use Regular expressions for this; there is a good script for this in the Regular Expressions Cookbook by O'Reilly which I will try...

I'm glad that worked for you. It is worth noting that my query was pretty...

Lynn Pettis (4/19/2013)

---

Here is the testing:

set nocount on;

-- sample data

IF OBJECT_ID('tempdb..#x') IS NOT NULL

DROP TABLE #x;

CREATE TABLE #x (id int identity primary key, val nvarchar(100) NOT NULL);

GO

INSERT INTO #x...

I am...

It's work noting that wolfkill and I are using the same splitter[/url] (I mine just has a different name).

-- sample data

IF OBJECT_ID('tempdb..#x') IS NOT NULL

DROP TABLE #x;

CREATE TABLE...

I created some test data to show a different way using the patternSplit function from here[/url].

--Setup sample data

IF OBJECT_ID('tempdb..#temptesttable') IS NOT NULL

DROP TABLE #temptesttable;

CREATE TABLE #temptesttable (EventText varchar(100));

INSERT #temptesttable

VALUES('Receiving...

See the notes in my code. My understanding, too, is that you will always get a scan (index or table) unless you provide a filter. E.g. Select * FROM x...

kpann (4/18/2013)

---

I'm working on a SSIS project that will automate every process. I still want to give it a try...

When you download the zip files, you'll notice that I have...

RexHelios (4/18/2013)

---

venkyzrocks,

I agree with Sean Lange. More clarity and some ground to get others started would be nice to have.

Having said that, I have created table variables to simulate...