RBarryYoung (6/12/2009)

---

You know, I've always wondered why the #Temp tables that we create in SSMS (or QA) don't get destroyed when the batch/request ends. Shouldn't they run out of...

Tom Brown (6/12/2009)

---

Florian Reischl (6/12/2009)

---

Tom Brown (6/12/2009)

---

You can use a STATIC cursor instead.

See BOL.

But I couldn't say that without also advising you to look at the numerous articles on this...

You can use a CTE to get a row-number over your order-id:

DECLARE @t TABLE (OrderId INT, StartDate DATETIME)

INSERT INTO @t

...

Tom Brown (6/12/2009)

---

You can use a STATIC cursor instead.

See BOL.

But I couldn't say that without also advising you to look at the numerous articles on this site about cursors and...

Just have a look to MSDN:

FORWARD_ONLY

Specifies that the cursor can only be scrolled from the first to the last row. FETCH NEXT is the only supported fetch option. If FORWARD_ONLY...

If you want to work with a temp-table you have to create it outside your procedure. You can fill it within your procedure but if you create a temp table...

RAW returns data as attributes. You can use...

Glad we could help!

Glad I could help! 🙂

I don't understand your first question.

For your second (if your attribute is not mandatory)

DECLARE @Scores AS TABLE (ID VARCHAR(3), Score VARCHAR(3))

INSERT INTO @Scores

SELECT '15', '95' UNION

SELECT '8', '55' UNION

SELECT '14',...

Avoid the inline query in your SELECT statement. You can use a row-number to work with a JOIN.

; WITH

t (Act, Dt, RowNum) AS

(

SELECT

...

There must be something wrong in your XPath. This works fine:

DECLARE @xml XML

SELECT @xml = N'true'

SET @xml.modify('

replace value of (config/item/enabled/text())[1]

with "false"

')

SELECT @xml

BTW: You don't...

I just tried the SQL Server Import-/Export-Wizard (right click database -> Tasks -> Import Data...) with a Access2007 database - I don't have Access97. Seems to work fine. If you...

I would suggest to use a date column within your logging table to move the data into a staging table (or directly out to your files or other server). Since...

Glad I could help! 🙂