Start by reading this article: http://www.sqlservercentral.com/articles/Advanced+Querying/3181/

dlautwein (3/23/2010)

---

Sorry - I replied to a much earlier post that said people in New Jersey thought of Colorado as cowboys and Indians in the 50's, and thought my post...

Here is some sample code, pay attention to the second select query, it doesn't use the in-line TVF.

CREATE TABLE #TestTable

( id INT,...

Just to be sure we are all on the same page, could you post an example of the input and expected output?

Also, could you show us how you see this...

lmu92 (3/23/2010)

---

@Lynn:

Why would you use two functions for this task rather than doing it all at once?

My wild guess would be that the pure UNPIVOT solution should be more efficient....

T-Bone

Thank you for the feedback, and you are welcome.

Lutz was close and gave me what I needed to write the following, hope this helps:

CREATE TABLE #TestTable

( id INT,

...

You may also need to take out the t2. from this line:

insert into softlandsoporte2.softland.nwcotiza(t2.CotNum,t2.CodAux,t2.NomCon,t2.CodMon)

igngua (3/23/2010)

---

thanks!!

it worked!

select t1.cotnum, t1.codaux,

t2.cotnum, t2.codaux

from hermes.lab0708.softland.nwcotiza t1

left join softlandsoporte2.softland.nwcotiza t2 on t1.cotnum = t2.cotnum

where t2.cotnum is null

Now i´ve to update T2 with all the columns from 1...

Robert.Smith-1001156 (3/23/2010)

---

I know there are a lot of former Dungeons and Dragons players in our business, but please can we not call it a "guild"? 😉 I...

Not exactly sure what you are looking for here, but here's a shot.

The best way to make use of SSC forum/posts is to try and solve the problems presented, even...

Depending on the loads, yes. At a previous employer while working on data warehouse loads we found it worthwhile to drop indexes, load data, recreate indexes. I even...

igngua (3/23/2010)

---

HI!

Im not getting the results i want.

t2 has less data than t1 and i´m getting no...

If the database is using the SIMPLE recovery model, backing up the database periodically isn't going to help. You need to look at the data going in to the...