Cadavre (9/27/2011)

---

Charlottecb (9/27/2011)

---

Hi All,

I'm having a problem constructing a SQL Server 2008 stored procedure and any help would be gratefully received...

A bit of background info...

I have a list of contractors...

Thanks Elliot:-D

Elliott Whitlow (9/22/2011)

---

Can I offer something else..

A trigger to do the work could easily cause unnecessary waits in the application. I would probably use the trigger to write an...

Sean Lange (9/22/2011)

---

Charlottecb (9/22/2011)

---

Sean Lange (9/21/2011)

---

That looks like a good start but you will have to add some of looping to handle multiple line inserts. If Lowell doesn't have time...

Lowell (9/22/2011)

---

ok check this out please.

this has worked correctly on all 5 of my tables which happen to have picutres/images in either image datatypes or varbinary(max) datatypes.

i could correctly guess...

Sean Lange (9/21/2011)

---

That looks like a good start but you will have to add some of looping to handle multiple line inserts. If Lowell doesn't have time I can give...

Lowell, Thanks for your continued responses.

After doing a bit of googling, this is what I've put into an insert trigger on the table...

DECLARE @folderPath VARCHAR(MAX)

SET @folderPath = 'C:\' --...

Lowell (9/21/2011)

---

Charlottecb (9/21/2011)

---

I'm probably being very simplistic \ ignorant in my outlook here, so please bare with me as I've never had to do anything like this before... Why can...

Sean Lange (9/21/2011)

---

Well then as Lowell said you can't do this with sql alone. This is more Lowell's expertise than mine but that is going to be pretty painful. You...

Lowell (9/21/2011)

---

here's some .NET code i posted from a different post on the same issue;

you can use it as a model if you have the file name and binary data...

I don't have the filename with it, I will generate the filename. The varbinary data will always be in the same format. I am trying to acertain what image format...

Hi, thanks for the response. I have no control over the original dumping of the varbinary data - it' done by an external system which I have no control over.

Ahh, I'm with you now - yes, that's very clever and a lot simpler to maintain in the future. I'll have a go implementing it your way.

Many thanks.:-)

Hi, thanks for the calendar code, however, I'm not sure how this will help me.

I've got it working I think using a nasty Case statement.

I would welcome comments on this...

stewartc-708166 (1/24/2011)

---

Would something like the following help?

DECLARE @StrStart NVARCHAR(MAX), @StrFin NVARCHAR(MAX) = '', @RecordCount INT = 0

SELECT @StrStart = '123.89;1400;107;-1.98;124.9001;103.67;12;-40;'

WHILE DATALENGTH(@StrStart) > 0

BEGIN

SELECT @StrFin += LEFT(@StrStart, CHARINDEX(';',@StrStart)-1),

@StrStart =...