Do you care which of the three doesn't match? If not - you could use JUST the "matches" part below

;with JoinMath as (

Select...

Of course - the SQLCMD utility MIGHT do what you want....

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

xp_cmdshell doesn't work for those kinds of things. It's designed to run/process non-interactive commands from the OS. It's not going to spawn windows, open up documents for you...

drop can't take a dynamic parameter.

Use

Exec sp_droplogin @name

or

Exec sp_dropUser @name

Instead

Michael Valentine Jones (2/12/2008)

---

Ordering is only guaranteed within a SELECT with an ORDER BY clause.

Ordering during an INSERT may or may not happen the way you hope in any version...

Rewrite # 2

SELECT DepartmentID, DepartmentName, AgencyName, ShortName, CreatedOn, Status, UpdatedOn, UpdatedBy,

CASE WHEN delOK.delcount > 1 THEN 'N' ELSE 'Y'...

True - but I cust those chances in half with concatenating two of them together. Still not entirely gone I suppose, but probably good enough for government work:)

Of course...

Set up an ODBC connection (system DSN) to the FoxPro files. Once you have it you should be able to use that with the Native client's OLE provider for...

Completely agreed with above. SQLCLR does NOT give you FULL access to the framework. It's a specific subset.

Well - it looks to me that you have 2 correlated sub-queries, and one is substantially more complicated than it needs to be (gut-feeling - not proof).

How about this as...

Hey - it's easy when you sit back and watch the fur fly - sometimes a new answer just pops into your head....

Of course - it's swatting a fly with...

Why not just use the replace function?

update mytable

set streetaddress=replace(streetaddress,'McDonald','MacDonald')

Hey - I WROTE the T-shirt...

Of course - why generate each digit separately, when you get get them all at once?

Should you need a few million (or in my example, 1 million) at a time:

...

...except you don't get the results displayed in the way the OP requested the data....