I got the same results as Dung Dinh when I set up a similar test scenario, I only got one row from the resulting query. You might want to look...

Heres a fairly literal approach. However, I'm sure theres more interesting ways to go about it!

select s.id, s.name1,s.name2,d.[desc]

from dbo.Test_Join_Source s

inner join dbo.Test_Join_Destination d

on

s.name1=d.name1

union

select s.id, s.name1,s.name2,d.[desc]

from dbo.Test_Join_Source s

inner join dbo.Test_Join_Destination...

ALZDBA (5/21/2012)

---

and of course, your function causes any indexes defined on that column not to be used as efficient as possible, if used at all.

No doubt, change the code or...

Lowell (5/21/2012)

---

because you are putting a function on thee column, SQL has to convert the WHOLE table to give you results.

with a TOP, it can shortcut and convert fewer...

when defining your cursor, maybe you could use nvarchar(max) instead of varchar(max), just a thought!

DECLARE Exp_cursor CURSOR for

select x.nodeValue

from

(

-- this line I would change each occurrence of 'varchar(max)' to...

I would have a first look at the networking side. How does remote desktop to the server work for instance, does that work fine?

Steve Thompson-454462 (5/3/2012)

---

patrickmcginnis59 (5/3/2012)

---

I...

I would have a...

Sean Lange (5/2/2012)

---

patrickmcginnis59 (5/2/2012)

---

Sean Lange (5/2/2012)

---

Well unless you are doing on the most god awful things I have seen some sql people do...which is to create a temp table and...

Sean Lange (5/2/2012)

---

Well unless you are doing on the most god awful things I have seen some sql people do...which is to create a temp table and then call a...

rarara (4/30/2012)

---

(snip)

1) Is there any way for me to determine the size of TEMPDB needed based on the table sizes, and how many rows might be getting selected prior to...

I know that when I write report queries, I often use:

SELECT COL1, COL2, COL_W_CRITERIA WHERE COL_W_CRITERIA = @criteriaparam OR @criteriaparam = 'all'

Then if the user enters 'all' for the criteria...

What I would do is ask the vendor how they prefer their application's database indexes get maintained without interfering with their cursors and then follow through with what they advise.

I ran it by chopping off the insert portion as I didn't have a table definition and the code seemed to run ok, returning a bunch of rows with date...

@adrian.facio

nice solution!