Are you looking for something like this?

CREATE table #t1(ID int, FName varchar(10), Sname varchar(10))

INSERT INTO #t1 VALUES (2886, 'nom 1' , 'prenom 1')

INSERT INTO #t1 VALUES (2886, 'nom 2'...

Sorry not tested it. 'USE DB' wont help?

I think you need login trigger if you want to avoid any particular type of third party tool. Follow this link. Thanks.

http://www.sqlservercentral.com/Forums/Topic812192-145-1.aspx

Sorry, I could not understand. Can you provide some test data and table script and then the expected result?

When you say...

See if this helps yeah! Its a pretty common question and I just did a search here on SSC and found this topic.

http://www.sqlservercentral.com/Forums/Topic453737-338-1.aspx

rameshduraikannu (11/11/2009)

---

Hai to all,

i had two table range1,range2

first table column value is

height=200

second table column value is

height=206

I want to compare two column value and round the value to nearest...

Solution provided by Adi cohn was very straightforward i thought!

I dont think so! You're LEFT joining the tables and if there are no matches in 2nd,3rd, 4th table then you will have null for the sessionids there. Your where...

Wouldn't it be nice if you can post that solution also please? so that when someone goes through this...

I guess there are other ways to do that as well, but create a temp table and then do this,

INSERT INTO #temptable

EXEC urstoredprocedure

INSERT INTO #temptable

EXEC urstoredprocedure

Select * from #temptable

then that column is not there in either of the table .. identify the columns you want to join the tables on first!

krypto69 (11/6/2009)

---

select

zone,

data_date,

...

this is fun 🙂

pc131 (11/5/2009)

---

Thank you so much. You're right. My left join was not correct, because doing this:

FROM (test1 t1) LEFT JOIN (test3 t3, test2 t2)

ON (t1.id=t2.id AND t1.id=t3.id)

I actually forced SQL...

Error was generous enough to tell you what the problem was 🙂

declare @VAR varchar(10)

execute TESTPROC @VAR output

PRINT @var