ColdCoffee (9/28/2010)

---

craig 33233 (9/27/2010)

---

I have a source text file that for one type of record (inactive) has 25 fields, but for another type of record (active) has up to 36...

Kit G (9/27/2010)

---

Kit G (9/27/2010)

---

steve-893342 (9/27/2010)

---

Kit G (9/27/2010)

---

Thanks Steve for the code. That date at Los...

Kit G (9/27/2010)

---

Thanks Steve for the code. That date at Los Mules where the Event date...

I don't think you can do this very easily using BULK INSERT because of the irregular first row. You can instead use OPENROWSET BULK and treat the first row as...

I use a method here which taps in to Phil Factor's sp_scriptfor stored procedure.

http://www.simple-talk.com/sql/t-sql-programming/exploring-sql-server-table-metadata-with-ssms-and-tsql/

Using this stored procedure we can populate the table #HOLD_Scripts with all the scripts...

Check out this query and see what you think

;WITH cte1 AS

(

SELECT ROW_NUMBER() OVER (PARTITION BY ProdDate, Line, Model, ProdNo, SSerial, Lot, Period, UploadDate ORDER BY CASE WHEN SUBSTRING(SerialNoStart, 4, 1)...

Paul White NZ (9/24/2010)

---

I tend to agree. I'm patiently waiting for Jeff to post the new Tally...

This might give you an idea of how you could use a PIVOT query

IF NOT OBJECT_ID('tempdb.dbo.#t', 'U') IS NULL DROP TABLE #t;

SELECT 'Excel' AS Application, 'Bob Jones' AS [User], 10...

I think you can solve this one with a PIVOT and some splitting

;WITH cte AS

(

SELECT ROW_NUMBER() OVER (PARTITION BY Venue, Address1, City, State, Zip, MenuChoices,...

Jeff Moden (9/23/2010)

---

steve-893342 (9/23/2010)

---

Jeff Moden (9/22/2010)

---

steve-893342 (9/22/2010)

---

Jeff Moden (9/22/2010)

---

The problem with the Tally Table related splits is that I forgot :blush: to add 1 to the length....

WHERE N...

Jeff Moden (9/22/2010)

---

steve-893342 (9/22/2010)

---

Jeff Moden (9/22/2010)

---

The problem with the Tally Table related splits is that I forgot :blush: to add 1 to the length....

WHERE N BETWEEN 1 AND...

Mark-101232 (9/22/2010)

---

steve-893342 (9/22/2010)

---

Shouldn't...

Shouldn't that be

WHERE...

Paul White NZ (9/22/2010)

---

The SQLCLR solution works correctly:

DECLARE @CSV NVARCHAR(MAX) = N'A,B&C,,C,?,',

@Delim NVARCHAR(255) = N',';

SELECT S.sequence,

...

Paul White NZ (9/22/2010)

---

:laugh: Well there is some reasoning behind the example...