ak (12/17/2008)

---

Thank you very much for the response. I will try it out.

As to the reason for asking....a client has suggested that they suspect rows are mysteriously disappearing from a...

Also, if it is actually a TEXT field, just change the RIGHT to a substring

SELECT SUBSTRING(AText,PATINDEX('%X-Ray%',AText)+5,DATALENGTH(AText)-PATINDEX('%X-Ray%',AText)-5)

Something like this?

DECLARE @A TABLE(

ATextvarchar(1000))

INSERT INTO @A(AText)

VALUES('This is some sample text. It is almost ChristmasTime! X-Ray Results look uh... good... (I''m a programmer, not a doctor)')

INSERT INTO @A(AText)

VALUES('This...

This is just a preliminary guess...

Although *you* can access the share... can the sql server login account that is doing the backups access it?

Jason White (12/17/2008)

---

For me it's either tweak the application or tweak the views currently used. I simply choose to tweak the views. Thus I need to split...

Please refer to the link in my signature for an example of how to supply table structure and sample data for this request. What version of SQL Server are...

First of all, please post SQL 2000 topics in the appropriate forum. This is a 2K5 forum. (Don't repost this, just try to post in the right one...

I see no reasons listed why you'd...

jcrawf02 (12/17/2008)

---

mcphillipsjohn (12/17/2008)

---

Seth,

3. I have noticed it's more common to use the JOIN keyword, I just learned it the other way and find it hard to break the habit. Maybe...

b.b (12/17/2008)

---

Thanks for your reply and I take on board about your first link. I am a little confused about your 2nd link as this seems to be talking...

You can do it, you just need to create your temp table explicity, and not using a 'select into' from the dynamic sql (as it's not in the scope of...

So, let me make sure I understand. You've written a recursive, cursor driven dynamic sql query... on purpose?

Looks good John. A few comments:

1. There's really no reason to order the data going into the table variables, it just adds cycles to your query.

2. You...

Try this one?

[font="Courier New"]SELECT  -- 1

        RRSPRB1.LRETAIL,

        RRSINV1.INVCAT,

        RRSINV1.BARCODE,

        RRSINV1.PRIMVENREF,

        RRSINV1.CONFACT,

        RRSINV1.PACKQTY,  

        RRSINV1.TAXABLE,

        -- 2

        RRSINV2.SHELFLOC,

        RRSINV2.ITEMCOST,

        RRSINV2.LISTPRICE,

        -- 19

        RRSINV19.REFERENCE,

        RRSINV19.LOCATION,

        RRSINV19.RECNO,

        -- 20

        RRSINV20.POSTED,

        RRSINV20.RETPERUNIT,

        RRSINV20.UNETCOST,

        RRSINV20.PARTNUM,

        RRSINV20.DESCRIPT,

FROM

    RRSINV2

    INNER JOIN RRSINV19 ON RRSINV2.LOCATION = RRSINV19.LOCATION

    INNER JOIN RRSINV20 ON RRSINV2.REFERENCE = RRSINV20.PARTNUM AND RRSINV20.REFLINK = RRSINV19.RECNO

    INNER JOIN RRSINV1 ON...

Can you post the solution that you've come up with?

This is another way to get the beginning of the hour from 2 days ago:

SELECT DATEADD(dd,-2,DATEADD(hh,DATEDIFF(hh,0,GETDATE()),0))