Its pretty hard to understand why your SAS and SPSS users would want to wait for SQL Server to export to Execl, then import from Excel when they could just...

Greg Edwards (12/11/2008)

---

Grant Fritchey (12/11/2008)

---

If it makes you feel better I've been hit, while stopped, not stopping, I've been sitting still, waiting, four times over the last 10 years. ...

Right. Never mind... :blush:

Heh. Oops.

With cteNav as (

Select NavigationID, NavigationText, NavigationID as Root

From Navigation

Where ParentNavigationID IS NULL

UNION

Select NavigationID, NavigationText, P.Root as Root

From Navigation...

I think that this will do it.

Actually, Steve asked...

Also, it would be helpful if you could supply the Table DDLs (just script them out, if necessary) and some sample data.

In SQL Server, the best way to optimize loops is to replace them with Set/Table operations.

Agreed. What I posted is not anything like a complete solution. However, if you just want a quick way to check for column changes, this is a free...

Well, the scripts are not objects and the only thing that can turn them into objects is to execute them in SQL Server. This of course turns them into...

Well if you've already got a UTF-16 TO UTF-8 conversion routine in .Net, you could just make a SQLCLR assembly from that.

Thinking about it, there are ways to do it...

Try this: http://www.amazon.com/Data-Warehouse-Toolkit-Complete-Dimensional/dp/0471200247/ref=sr_1_1?ie=UTF8&s=books&qid=1228880296&sr=1-1

Here's a start:

Print 'changed in New:'

Select * from MyTests.INFORMATION_SCHEMA.COLUMNS

EXCEPT

Select * from Util.INFORMATION_SCHEMA.COLUMNS

Print 'changed from Old :'

Select * from Util.INFORMATION_SCHEMA.COLUMNS

EXCEPT

Select * from MyTests.INFORMATION_SCHEMA.COLUMNS

Here is the equivalent of your function in T-SQL:

create Function SMA_EOD(@Commodity as Varchar(25), @TrdDay as DateTime, @period As Integer)

Returns Integer AS

Begin

Return (SELECT TOP (@Period)

Case When Count(*) <...

Are you overwriting just user databases, or the whole SQL server Instance?