OK, fair enough.

First, the ORDER BY is giving an error because you cannot put it there. In fact, it cannot be applied (directly) to the output of a script...

Well this is easy enough to fix, but it sure does sound like homework. Could you please tell us what the business purpose of this query is? I...

shnex (1/30/2009)

---

but they handle?

SQLDMO works with SQL Server 2005? that's the question:)

I understand from what you say that sqldmo works with named instances in 2000. Maybe it works with 2005...

You probably have both 2000 and 2005 on your local system. Named instances were new with SQL Server 2000 & DMO and they do not handle named instances as...

Glad I could help.

This should do the same thing and probably will perform better:

SELECT PART.ID AS PART_ID, UDFCURRENT.STRING_VAL AS [Description]

FROM PART

LEFT OUTER JOIN USER_DEF_FIELDS UDF ON PART.ID...

Well first of all, when you OUTER JOIN tables, you should not put conditions for the Nullable table into the WHERE clause (unless that include a test for NULL), because...

shnex (1/30/2009)

---

and..another question about SQLDMO...

I see everywhere that is for SQL Server 2000, but I'm using it for 2005.

It can see may server and my SQL Server 2000 databases.

Is there...

Please post the code that you are using.

Suresh B. (1/29/2009)

---

The original code that I posted is just a simplied sample.

The actual code could be some thing like this:

declare @query nvarchar(4000)

select @query = 'SELECT ColumnName FROM tbl_TableName WHERE...

SMO is documented in BOL.

If you want a code example of how to do this with SMO, see here: http://www.sqlservercentral.com/Forums/Topic494616-386-1.aspx#bm494720

Lynn Pettis (1/30/2009)

---

RBarryYoung (1/30/2009)

---

OMG, you poor SOB! :crazy: I am sure that I...

Tropic Thunder. Plenty of explosions...

OMG, you poor SOB! :crazy: I am sure that I would have chewed...

OK, if vwMatch_Base really is a table, then you might try applying a Clustered Index with the following columns:

Surname, PostCode, Firstname, YearMonth, YearDay