you do wonder sometimes what people actually...

suggest you use TRY_CONVERT...iirc it wont throw error but pass NULL instead on data that cannot be converted

CREATE TABLE #Invoice (Invoice_number NVARCHAR(10),

...

Welsh Corgi (12/9/2016)

---

The following will output to a CSV but I do not want a CSV Format.

What are my options?

bcp "SELECT Col1,Col2,Col3 FROM MyDatabase.dbo.MyTable" queryout "D:\MyTable.csv" -c -t , -S...

what script did you use......?

as an example....maybe something like this ?

CREATE TABLE somedata(

BoxID VARCHAR(2)

,BottleID VARCHAR(4)

,ItemCode VARCHAR(4)

,Batch INT

);

INSERT...

robert.sterbal 56890 (12/2/2016)

---

J Livingston SQL (12/2/2016)

---

I'd like to understand...

robert.sterbal 56890 (12/2/2016)

---

This exchange is why I'd like to have a discussion:

robert.sterbal 56890 (12/1/2016)

How is the script licensed?

The Author:

Hi Robert

I do not have any problem someone using the script...

sgmunson (12/2/2016)

---

sac.nan (12/2/2016)

---

John Mitchell-245523 (12/2/2016)

---

Yes, the answer was kind of "that's the requirement", which is fair enough, I suppose. I'd still love to know what this is for, though....

John Mitchell-245523 (12/2/2016)

---

J Livingston SQL (12/2/2016)

---

sac.nan (12/2/2016)

---

J Livingston SQL (12/2/2016)

---

maybe...???

WITH C1

AS (SELECT id,

...

sac.nan (12/2/2016)

---

J Livingston SQL (12/2/2016)

---

maybe...???

WITH C1

AS (SELECT id,

p2pid,

...

maybe...???

WITH C1

AS (SELECT id,

p2pid,

...

how are you intending to order the rows as you have shown? do you have other columns that can be used to guarantee the order?

mack53nico (12/1/2016)

---

I noticed that the link posted uses 'sp_executesql'. Is there any other method that uses a process that is more secure? This search function is to be web based...

this is well worth a read......http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

robert.sterbal 56890 (11/30/2016)

---

Here is a good discussion of recipes and copyright law:

http://opensourcecook.com/recipes-copyright-law

(I'm republishing the book: https://cookbooks.leannebrown.com/good-and-cheap.pdf as a set of wiki pages: https://sterbalfamilyrecipes.miraheze.org/wiki/Category:Good_and_Cheap_Recipes)

I needed permission to post the images, not...