Similar post was just posted with some answers already provided

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=263270&sub=1

Couple of methods come to mind...

1. Use DTS from SQL 2000 if available

2. Use MS Excel to connect to the DB, populate a spreadsheet with the data and save as...

Hi.

I believe there would be an ActiveX control that you could spawn hidden (needn't have a parent window) - The RTF control is standard with Windows.  I have used it...

PS - you should probably open up a new thread if you have a new issue as ppl don't tend to look at the old threads...

Run the surface area configuration tool - turn on the browser service (I think this allows clients to look up the port number for different instances - used to be...

Google's a wonderful tool - I had pondered the same question but hadn't bothered looking for the answer until now...

Anyhow, quick search on

osql errorlevel

gave the page

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp

Read it -...

You could limit the update to those that have ext- as the prefix and use substring to get the rest of the text... This should overcome the John Context-Jones example...

Perhaps the files are corrupted?  Try running DBCC CHECKDB from SQL 7 and let it fix any errors - then try the attachment/upgrade again.

Nice to see a wide variety of articles on the site

Having said that, two comments.

1. The comment earlier about "no default printer" when...

And you'll want to ensure that you have SQL's first day of the week variable appropriately set

Search this site (SQL Server Central) for hierarchies - you will find several detailed articles - also make sure you read the discussion threads with the articles..

Good lucK!

You can get the min & max in the one query without worrying about spooling to a temp table...

select

                A.FacId,

  max(A.PunchDT) as MaxPunchDT

  min(A.PunchDT) as MinPunchDT

 from FacIds A

 group by A.FacId

Why can you not use unions?  If you know how to do it with a union but some GUI tool you are using doesn't like it, then use your union...

I see this as being a LOT more work to implement, test and debug than simply accepting a number of parameters that have default values for them?  The XML allows...

Danm, you beat me by about 10 secs   Shouldn't have tested it before posting!!  oh well