The "-c" parameter, as you are probably aware, uses the CHAR format.  What you might not know is that it adds the "newline" character as well.  Hex "0D" is a...

Lookup "hierarchical information" in Books on Line for an example.  Has a bug in it but shouldn't be hard for you to find.

--Jeff Moden

Kind'a what I thought... Thanks for the quick reply, Gary!

It's been my unpleasant experience that the production server will usually be much more active than the development server.  You could be having a problem with wait-locks from other processes...

Apologies for disagreeing with the masters...

Just changing the "if exists" to tempdb (as previously posted) will NOT detect or delete a temp table...

Not real sure but I think if you have "GO" anywhere in your script, you need to set nocount to on after the "GO".  Of course, if you don't have...

Actually... there is a way if you want to generate the scripts for ALL the objects in a database.  Check out the following URL...

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q220/1/63.asp&NoWebContent=1

I'm confused... wouldn't it just be a lot easier to put all of the companies' information in a single table with a CompanyID column?  Isn't that what 3rd normal form...

Using Jonathon's example...

SELECT DISTINCT a.Col + b.Col

FROM Table a JOIN Table b ON a.Col <= b.Col

Before it get's much more complicated, perhaps you should look into OLAP Services which comes free with MS-SQL... OLAP (online analytical processing) is on of the "other" things on your...

Thanks carimines...

blueagle,

 

You posted...

>You can create UDF to get the whole structure based on the specified root ID. That's easy and much more flexible. 

 

Mind telling us how to do that?  

All well and good...

But the "poster" said that he wanted to do this as a VIEW!   I asked the question a while back, "How...

pbaldy,

Would you mind sharing what you did?

>I would like to do this in a view if possible becuase it is going to be used as the data source to a report designer.

How would you pass a...