Seems pretty straightforward. Gathers data from the other server and stores it on yours. There's nothing glaring about this that is inefficient or wrong. There are some...

Jeff mentioned on another thread yesterday that he's been really busy. There's a few he hasn't had time to reply to yet. Give it time :P.

Read this forum. Look at the problems and the solutions. When you see something you don't understand, Google more information on it, or look and see if there's...

And that you're using 2005 or above. (Different error message if you're on 2K, but figured it was worth mentioning for anyone else who might read this and try to...

Unfortunately, not right away, no. I know that normally doing any kind of data access in an inline function is a "bad idea", in the same respect that playing...

How about this?

[font="Courier New"]

CREATE FUNCTION dbo.fnGICSPFParseGICCatalog_Test(

   @string  VARCHAR(8000),

    @TrimAll BIT)

RETURNS VARCHAR(8000)

AS

BEGIN

DECLARE @b-2 VARCHAR(8000)

SET @b-2 = '' -- Initialize @b-2

IF @TrimAll = 1

   SELECT @b-2 = @b-2 + SUBSTRING(@String,N,1)

   FROM Tally

   WHERE N...

I actually run into this issue a lot with Crystal. If you run the report with parameters that return no data, the whole thing blows up. As Gus...

This is basically gap finding, and it seems like you should be able to use a variation of Jeff's identity gap finding technique for this. I've been trying to...

I get it now. Great explanation. So you've also found that it's quicker to dump repeatedly into the slightly bigger varbinary's than just dumping into one big one...

RBarryYoung (1/24/2009)

---

So here's my code using the SELECT pseudocursor hot-wired to act like an UPDATE pseudocursor, plus every trick I could think of to remedy the problem of SQL string...

The article in my signature describes how to set this up, but let's say you have tableA with one column Aval.

Your table / sample data script would look like this:

DECLARE...

WAIT WAIT WAIT.

Blew a pork chop out of your nose?

So.......

Phil,

Your providing of sample data is much appreciated, as are the expected results from your requests. However, if you find that you're not getting a lot of...

Jeff Moden (1/24/2009)

---

Heh... I'm getting closer... normally, you beat me to this on providing...

Loops, cursors, complex correlated subqueries, inline functions with data access, functions in the where clause (I believe, don't see this one much)... all are examples of RBAR. In other...