UPDATE AttributeTABLE

SET VAL = @PASSEDINVAL

WHERE PKEY = @PKEY

...

I asked about splitting of bunch of quoted delimited...

Jeff Moden (9/15/2008)

---

Sorry for the delay...

Absolutely the easiest way to read a "properly formed" CSV file is using OpenRowSet. If the file is called "ImportTest.csv" and it's stored in...

So, according to your request you need:

1) select all rows where CustomerID = 3

2) select all rows where CustomerID <> 3 and TestID does not exist in derived table returned...

It's a size of 1 page (8k) minus size of row overheads.

Size of pages used by SQL Server cannot be changed.

Normalizing of your attribute storage would be much more effective and much more simple in terms of coding.

Yes, it would be not so comfortable for editing from EM.

But you data...

Single quotes are for test strings.

They are not from file, of course. 🙂

And, I believe, there are 7 columns in both strings.

1st one should be split into:

1Pick-up

2

3

41234

52008-08-24

6 "2008-08-24"

717", unknown brand

Only sysadmin users on Windows Server can access registry.

If you cannot change the account your SQL Server is started with you may login not as "sa" but as appropriate Windows...

I guess it has nothing to do with SQL.

You need to find why your method CmdPlaceOrder_Click could call procedure without supplying that parameter.

Jeff Moden (9/13/2008)

---

Absolutely... what do you want to do? Split a true CSV parameter or a tru CSV column in a poorly formed table that needs a bit of...

Jeff, performance is good.

But did you see a solution for splitting string with quoted values?

Like in CSV files?

Convert table split function to scalar one.

Add another parameter - @ElementNo and return only value from the table within function with correlated ID.

The you may use it like this:

SELECT dbo.SplitScalar(StringValue,...

What continues to be a mystery is why a procedure that has been running since 2005 for 20 minutes would increase to 11+ hours. (It appears to me that...

This is your problem.

Replace those functions with views and join your...

Try different set of queries:

1 - select count(*) from import_cc_payments where reference IS NULL

2 - select count(*) from import_cc_requests R where EXISTS (select 1 from import_cc_payments P WHERE P.reference =...