If the files exist on different machines, you might want to consider using a CLR and use impersonation to be able to access the different machines. If you do it...

ttsang (10/1/2009)

---

Hi All,

I have a MySQL 5.0 db server connected via a linked server (using MySQL ODBC DSN) and I can run a MySQL stored procedure and display the results...

You should definately alias your tables better.

you could try something like this:

SELECT * FROM SNP_SectionLearner Learn

INNER JOIN SNP_Sections Sec ON Learn.SectionID = Sec.SectionID

INNER JOIN SNP_Courses Cor ON Sec.CourseID =...

First off, you should change your query to use the new standard for joins, instead of saying SELECT FROM TABLE1, TABLE2, TABLE3, etc..

SELECT MAX(TOCTX_CARDTEXT.EXPN_DTE)

FROM TOCTX_CARDTEXT

JOIN PNCDH_CARDHOLD ON TOCTX_CARDTEXT.UNQ_CRD_NBR =...

Yes, it most certainly does.

You can't have SELECT clauses that aren't in the GROUP BY clause, but you can have GROUP BY clauses that aren't in the SELECT ones.

as an...

just incidentally while we're on this topic, is there any actual difference between the following two statements?

with cte as

(

select * from table1

)

select * from cte

where field1 = value1

and

select * from

(

select...

There's two options for you.

One way is you have a stored procedure that will take the table name, and will have a series of IF-ELSE statements, each of which simply...

Alright - so we just addressed the issue, by restarting SQL Server.

Not exactly the solution that I'd like to rely upon though, especially since this is a production server.

One thing...

I think I might know what you're referring to.

Were you trying to do something like:

CREATE TABLE #Temp

(

Cols

)

INSERT INTO #Temp (Cols)

EXEC RemoteServer.Database.Schema.StoredProcedure

?

If so, you might have been getting an error regarding...

Curious - you mention for "low-volume" queries. What would you define as low-volume, and what solution would you employ for larger volume queries? Some form of partitioning the larger query...

Matt Miller (#4) (9/22/2009)

This is bound to go *boom* if ANYONE is doing inserts on the table while you're running this loop.

What is the inner stored procedure doing? This...

Yeah I do this all the time, like for example:

IF OBJECT_ID('tempdb..#ClicktrackerIDs') IS NOT NULL

DROP TABLE #ClicktrackerIDs

CREATE TABLE #ClicktrackerIDs

(

UserID...

No reason in particular, I mean if you're wondering whether there's been performance problems or something to that extent, then no, there hasn't been. It was more just a random...

ouch. didn't know about the trailing space removal before length calculation. nice question!

Okay, after looking at your code a bit, is this what you're trying to accomplish:

For each record in T1

If a record exists in T2 with the same name, use T2.num

If...