A simple JOIN (as you would with two tables from the same database) adding the database and owner to the qualifier.

The qualifier should look like this database.owner.table

I think that you're looking for:

INSERT INTO tblMatchNSI(serv_lev,ctry_code,expamt,impamt,LCamt,usdamt,wkending,trans_code,ship_id)

SELECT    ExpHybrid.serv_lev, tblTempNSI.*

FROM    dbo.ExpHybrid ExpHybrid

RIGHT OUTER JOIN dbo.tblTempNSI tblTempNSI 

     ON ExpHybrid.ship_id = tblTempNSI.Ship_id

WHERE...

In my last job PSKill gave me a lot of amusement. There were numerous calls to the helpdesk that Outlook or other application had just closed itself down.

Creative use of...

If they do, you could use your trigger to fire a stored procedure on the linked server; passing the row's Unique ID (say @rowID for ease) as a parameter to...

Okay Paul,

Do your rows have Unique IDs in your original table (the one with the trigger on)?

Ade

I don't think that this is possible:

Check out this link

http://msdn2.microsoft.com/en-us/library/ms175129.aspx

there is a line in there:

READTEXT, WRITETEXT, and UPDATETEXT statements are not supported against remote tables.

What are you trying to...

I've only ever worked in small companies in the UK , could someone give me an example of why you'd need more than 1024...

When using the /A switch I always surround the definition in quotes:

/A "gvFileName=c:\text"

I use a lot of DTS packages in scheduled jobs and use the xp_cmdshell to execute them.

The configuration function @@SPID (SELECT @@SPID) is probably the easiest and least time consuming to implement.

It could also be done using xp_cmdshell and the TYPE command, thus:

EXEC master.dbo.xp_cmdShell 'TYPE C:\TextFile.txt >> C:\TextFile2.txt'

This would append the contents of Textfile.txt to TextFile2.txt on the SQL...

Hey Frank,

Good description of your problem - so good that I even managed to recreate the problem!! A little experimentation got me to this conclusion:

Open your Middle of String transformation...

Easy money... Couldn't agree more!!

And this easy money is funding my part-time Degree studies in to Psychology. I spent 3 years in HM Forces figuring out how radios, jammers, and...

Matthew -

If you could post some background of what you're trying to achieve and the relevant code, rather than a small snippet, we might be able to help you toward...

I worked for a company that ran one of those customer loyalty-type programs (points per £/$ spent and the like). They used a third-party software as the 'loyalty-engine' which processed...

Bill, I think you're wrong. The terms and conditions of sale are totally different to your idea of "agreement". The T's and C's on a sale carry through to completion,...