I used to do something like this :

SELECT dbo.fnGetCustResidId(), CustomerId

from inserted i

...

I made a udf that returned the type (ID) of something.

That way I could always call the UDF in...

Have you tried putting everything in dynamic sql and run it like that??

I think it's like the problem with : "use @MyDbname" >> can't work without dynamic sql.

Thanx. 

Let's just call that plan B for now .

Can you connect to the db and do something like Select * from dbo.SysObjects?

ND I'm not telling you are a liar.

SHOW US how the heck you do that!

How does that insert in 2 tables at once?

And how does it work when you insert more than one row at the time?

There's already a thread started on this subject and you are not the only one complaining. The bottom line is that sqlservercentral has signed a contract to test this...

Or if it's an table valued or inline function :

Select Cols_List from dbo.FunctionName (@Par1, @Par2) where ...

Sorry but there's no way to code an insert in 2 tables at once.

You have to do something like this :

Insert into dbo.Customers

--fetch the new ID

SET @MyNewID = SCOPE_IDENTITY()

Insert...

I think you may have a look at replication (maybe bi-directionnal). It's surely gonna come up later with admin DBAs (I'm not one of them).

Check it out in books...

I can forward you all the beer I won't drink.  But you have to pay the shipping charges .

1. Checked

2. CHECKED!!!!!!!!!

3. Check.

4. Sorry don't like beer

5. On my very best day I can beat the world champion. On my normal day I can beat 99.9% of the players...

Are you guys hiring junior DBAs? I'd love ot come in and start a career (not that I don't like programming but sql server is just more of a...

Ya made the mistake of the (implicit) cross join once... not gonna do it again .

As I said EXCLUDING CLR you can't call a proc in a function.