Cadavre (10/16/2012)

---

Lowell (10/16/2012)

---

ok, adding WITH SCHEMABINDING to my scalar function cuts half a second off of my performance, so it goes to 7.5 seconds or so instead of over 8...

Lowell (10/16/2012)

---

ok, adding WITH SCHEMABINDING to my scalar function cuts half a second off of my performance, so it goes to 7.5 seconds or so instead of over 8 seconds....

russellolson (10/16/2012)

---

The example code above showed this statement:

SELECT RowData + ''

FROM Groups b

WHERE a.rn = b.rn FOR XML PATH('')

Why...

You're welcome. I forgot something though.

WHERE a.rn = b.rn ORDER BY RowID FOR XML PATH(''))

Need to make sure the rows are concatenated in the right order.

ChrisM@home (10/15/2012)

---

deba_20032004 (10/15/2012)

---

Dear Sir,

I am in great trouble, my problem is I have a vendor Table

which consist of some fields. I explaining the structure below

Table<Vendor>

--------------

fields name

-----------

PKID int

VENDORID int

VENDORNAME...

Instead of creating a special function for the purpose, I just went with Jeff Moden's community DelimitedSplit8K (http://www.sqlservercentral.com/articles/Tally+Table/72993/) to get this:

DECLARE @T TABLE

(DETAILS_ID VARCHAR(100), DETAILS VARCHAR(100))

INSERT INTO @T

SELECT 'EA22749B180C41D09B4CC986D21C8F02','2006-11-28|1900-01-01|1||PL625245|'

;WITH MySplit...

Could there be more than one date per...

How about something like this?

DECLARE @ComboFactor INT = 3 --The number of rows to combine

;WITH Groups AS (

SELECT RowID, RowData

...

Not 100% sure but perhaps something like this?

Create Table #ClaimSummary

(ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

ClaimNumber varchar(5),

TotalPaidAmount money)

INSERT INTO #ClaimSummary

SELECT '12300',10.00

UNION ALL SELECT '12301',0.00

UNION ALL SELECT '12302',15.00

UNION ALL...

No need to use dynamic SQL or a PIVOT for this.

;WITH GroupsGrouped AS (

SELECT DISTINCT Groups=STUFF((

SELECT ',' +...

Gopi Muluka (6/4/2010)

---

ColdCoffee,

Here the reason for the error message he received is whenever there is no '-' found in the string then CHARINDEX('-', @FieldName)-1 will return -1 , which...

greenantim - Thanks for...

hkflight (10/11/2012)

---

Hi all, I am using stored procedures and potentially temp tables for the first time. What I am trying to accomplish is to check the database for certain data...

jasona.work (10/10/2012)

---

Brandie Tarvin (10/10/2012)

---

jasona.work (10/10/2012)

---

WayneS (10/10/2012)

---

Steve Jones - SSC Editor (10/9/2012)

---

jasona.work (10/5/2012)

So *YOU'RE* the reason the wifi packed it up after the first 15 minutes!

All joking aside, I did enjoy...

Something like this perhaps?

DECLARE @T TABLE

(Customer VARCHAR(5), sn INT, val1 INT, val2 INT, Val3 INT)

INSERT INTO @T

SELECT 'A', 1, 31, 54, NULL

UNION ALL SELECT 'A', 2,...