Ooops!

Thanks Wayne, forgot about that in my haste. :blush:

CREATE TABLE #header (Data varchar(max))

CREATE TABLE #result (dummycolumn int)

BULK INSERT #header FROM 'C:\TEMP\CSV1.csv' WITH (DATAFILETYPE = 'char',ROWTERMINATOR = '',LASTROW = 1)

DECLARE @sql varchar(max)

SELECT @sql = COALESCE(@sql+',['+SUBSTRING(Data, N, CHARINDEX(',', Data +...

GSquared (10/29/2010)

---

To answer the original question, yes, wrapping a script into a UDF does usually cause a performance hit all by itself. But, it's usually in terms of about...

Meh! Jeff probably hasn't heard the saying 'Nobody likes a smart a$$' 😛

doug 40899 (10/27/2010)

---

David,

Then can you give me an example of max being used? This query is being included in an application that's being built and if I can improve it...

Notwithstanding...

jez.lisle (10/26/2010)

---

Sorry I dont know what you mean, how would this be...

Do you have a proxy set up for xp_cmdshell?

If so does it have access to the file?

Wow! All these negative vibes :pinch:

I come in this morning and the thread has gone serious :angry:

Now I have to find a dark room to lay down and contemplate a...

Try using DelimitedSplit8K function described here and the following query

SELECT test.CuS_id, split.ItemNumber, split.Item

FROM test

CROSS APPLY

(

...

askquestions (10/8/2010)

---

This is why I was thinking of something to check each “fullname” against the corresponding “surname” - if the surname does not exist as a string in the fullname,...

Another alternative (although will cause a scan)

SELECT VendorId

FROM Vendors

WHERE CountryId = @CountryId

AND CHARINDEX(','+CAST(CityId as nvarchar(10))+',',','+@CityId+',') > 0

ORDER BY CreatedDate

UMG Developer (9/30/2010)

---

Duh. I was so...

Or...

ORDER BY SIGN(DATEDIFF(day,GETDATE(),EventDate)) & 0x80000000 DESC,EventDate ASC

sangeethu (9/9/2010)

---

Hi Lutz,

Thanks for the reply. I have gone through Cross Tab and Dynamic Cross tab and found that it involves aggregation of a column. But in my case every...