GilaMonster,

Thank you for your reply. There is a surprise at the end of my reply so please bear with me.

I tried several queries. I stated with Select * from Salestax...

I believe I have found the answer. When creating a script from within SSMS, the script does not contain the code to start the Snapshot agent. Once I added that...

Graeme100,

Yes, I am starting from scratch. I have been doing this publication and subscription from scratch for half a year. Now I want to incorporate it into a script.

This...

Celko,

Thank you for your comments. I was unfamiliar with ISO-11179 and 8601. I am sure this may seem odd but the table names do follow a standardized naming convention. It...

Paul,

Did I do something wrong? If so it was not intentional. I did a Search and found your two articles. I then emailed that link to two of my frineds....

That worked perfectly. "Cross Apply", I had never encountered this before. I will go and read up on it.

Thank you so much,

pat

Thanks for the advice. I was just looking to see how long the query would take. I didn't really stop to think about the consequences of using a client display...

First, thank you for following me over here. I do appreciate the replies.

Good to hear that it is a .Net error. I thought it might have something to do with...

I thought I tried right clicking and it did not work. But after your post I tried again and it works fine.

I did create a NonClustered index. Now the...

I did as you suggested.

The results appeared on the Execution plan tab. But they exented beyond the visible window and there were not any scroll bars. Nor could I...

Got it. I replaced the IDNo in the sortkey with ChildCategory and Category. If they were not encased in IsNull then the sort key would return NULL.

With CatList (Child, Parent,IDNo,...

The topic that just won't die.

The latest request is to have the nodes of the various tress in alphabetical order.

So I think I have to modify the SoryKey to include...

Ibe be .....d. It works. I am going to spend time tonight trying to understand the changes. I have no idea what Stuff does. But that is where I am...

Jason,

No thank you. Indentation is not necessary.

I copied your query just now into SSMS. The results are shown in the jpg. Do you get something different?

Wow. that was quick.

The order was in my original post.

Here it is. For some reason the indents are not show. I do not need it returned with indents. But it...