Hey Grant,

I think you are adding two more steps

than Andras Method.

Actually I followed the same way what you specify here in my

last project but Now I think Andras method...

Sure, Grant.:)

Cheers!

Sandy.

I think Decimal(x, y) would be a better option.

Cheers!

Sandy.

Hey Andras,

Cool Script, Let me check this.

with few more R&D today.

Cheers! 🙂

Sandy.

Thanks Andras, I did not know about the XML PATH way. It seems to be working a lot better.

I tested it on a small set of data to compare the...

GilaMonster (10/29/2007)

--------------------------------------------------------------------------------

As for CTEs and index/table scans. As I said, CTEs aren't tables. They're temporary views. As such, they them selves cannot be the subject of index or table scans....

Hey Kevin,

Can you please tell me what you exactly trying to achieve?

I mean to say can you brief this topic more,

its seems the topic is not clear to me.

Cheers!

Sandy.

Hey Gail,:)

Nice ...he he he 😉

Good day guys....tc

tomoro see you.....

Cheers!:P

Sandy

Hey Grant,:)

I didn't mean that....seriously...:)

4 tat I already told to Gail,

I wants every body's opinion on my topic,,

I would like to see view by John and Steve too....

Cheers!

Sandy.

Hey Gail,:hehe:

I apology for that...:D

I didn't mean that.(he he he..lolz)

Actually Grant is one of my Fav member in this site.

I can say this you are awesome, when you are replying...

Hey Grant,

Can you have a look on to my last post..

I will be happy if you and jeff will have a

sharp eye on my post.

Thanks a lot for your...

Hey Jeff & Gail,

Gail As per you

:

These tables behave very much like other variables in their scoping rules. They are created when they are declared and are dropped...

Hey Gail Shaw,

Thanks a lot,

Can you please give more Idea about CTE,

and also its uses in SQL Server 2005.

Because its a HOT Topic (CTE) in SQL Server 2005.

VAIYDEYANATHAN.V.S,

Thanks for...

Hey Jeff :),

You deserve the compliment for this type of approach to SQL Script.

its really good way what i feel.

Cheers!

Sandy.

Ye Loner, (he he he.....:D)

You are not dump;)

I can say this much.....;)

Cheers!

Sandy. (Keep Smiling...!!!)