Problems like this are usually security/access restrictions on the Windows Login that SQL Server is executing the file access under. What account that is, depends on the installation and...

You'll probably want to go with one of the more general "Split" methods then.

john.arnott (8/25/2008)

---

This raises a red flag about testing. The script works fine in SSMS against a SQL 2000 database. This implies that even in a SQL2005 db, it...

How so? I cannot find any forums there?

mmcginty (8/24/2008)

---

Wouldn't that be, "GO x" means return the value x, as the only [and unnamed] column, in the only row of...

Good one. I got everything else right, except that I missed that "GO;" would correctly execute the "GO" sproc (since it usually returns the aforementioned error).

By the way, I...

Oops, I got the order of the last 2 fields of the index wrong. Should be:

[ShiftID]

,[TableID]

,[StationID]

,[EmployeeID]

,[CounterDateTimeStamp]

,[CounterTimeSpan]

,[MusselCount]

I think that this is a much easier way:

Select Parsename(strg,4)

, Parsename(strg,3)

, Parsename(strg,2)

, Parsename(strg,1)

From (

Select Replace(

Replace('\ Application \ Microsoft Office \ Word \ Error ',' \ ','.')

, '\ ',...

I think that you should do what the error message is telling you:

Jeffery, Shouldn't that be:

SELECT [columns]

FROM table

WHERE column LIKE 'user1 %';

?

Try this:

Select [ShiftID]

,[TableID]

,[StationID]

,[EmployeeID]

,[CounterDateTimeStamp]

,[MusselCount]

,[CounterTimeSpan]

,MusselCount - Coalesce( (Select B.MusselCount

From [ShiftCountersRawData] B

Where B.ShiftID = A.ShiftID

And...

You know it brother! 😀

Jeff Moden (8/24/2008)

---

Heh... the thing I absolutely "love" about the idea of ANSI standards is... if we all do it their way, there will be no need for competition amongst...

Matt Miller (8/24/2008)

---

I realize I'm getting to the party late (you know - after Billy spiked the punch and got expelled for mooning the principal), but - isn't the PIVOT...

Jeff Moden (8/24/2008)

---

I've seen lots of folks try to salvage code that have cursors in it. A few are able to pull it of with some degree of success...