Very nice Orlando. This latest script also handles the many-to-many relationship better. I.e. when I ran your previous script against an extended #Ord table, the output had a duplicate OrdID....

Interesting, sorry I don't have the answer.

more...

SELECT 1 + - 2

SELECT 1 + - + 2

Hi Orlando, that's exactly the bit which led me to retract my suggestion. 🙂

Retracted my code suggestion, sorry, misread the requirement.

Jeff's mention was interesting as I, in similar fashion, switched all intranet data integration and processing to TSQL when DTS (SSIS predecessor) became too cumbersome for me to manage the...

Following Ben's suggestion, if hidden control chars not a problem in output, set according to your environ for nulls first or last...

select '"BEN_CLAIM" "3P_RENT"' ,'','','','','',NULL as MySortCol

UNION

SELECT *,'' as...

Hi TSQL Tryer,

Not sure if this abbreviated test example helps? Unfortunately not recommended (these days) for security reasons i.e. xp_cmdShell must be enabled while SQLServerAgent will need access to the...

Hi mkeast,

According to BOL SQL Server 2000 does not accept  variables in OPENQUERY.

Your suggested statement produced the following error:

Server: Msg 170, Level 15, State 1, Line 13

Line 13: Incorrect syntax near

Sorry my first reply got hung up on formatting errors.

I think Pedro is right, I was (later) working on the same thing.

With this method, dynamic OPENQUERY(with your variable identifier) worked great using one of...

Hi Nathan,

Aside from the more experienced responses above, your published statement string produces formatting errors.

Each time you pass a variable into another variable for execution you create another level of...

Hi Allen,

From limited experience, this error can be caused by a number of things.

You have no doubt looked at http://support.microsoft.com/kb/209805

All I can suggest is that you map out the architecture together with the flow...

The answer was here all the time, double hops not permitted.

http://www.sqlservercentral.com/columnists/bkelley/qa2k_1.asp

PS:

Worked out the update syntax...

update OPENQUERY(LINKSRV,'select statement') set myfield = 'xyz'

Works great until domain access to remote servers becomes an issue, then I get errors like "msg 7357 - since...

Thanks Kathi,

Good thinking, client has already front-ended with un-secured dbs so security not an issue.

Battling with updates though. Perhaps I should be using a cursor?

WORKING OK WITH LINKED ACCESS DB:

EXEC sp_addlinkedserver...

Hi all,

FIXED:

Hadn't realised the differences between CDONTS and CDOSYS.

CDOSYS doesn't use IIS or Virtual SMTP server.

I have modified my "send SMTP email" stored procedure to configure CDO object with...