GilaMonster

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

A while loop is not going to be massivly more efficient. It's still row-by-row processing of a large number of rows.

Johann, can you give us sample input and output...

Sure,

Check this:

Declare @Temp Table

(

RowId Int identity(1,1),

)

Declare @Count Int, @Start Int

Select @Count = Count(*) from Table1

Set @Start = 1

While @Start <= @Count

BEGIN

...........

...........

Where RowID = @Start

Set...

Hi Johann,

Use While Loop instead of Cursor.

Cheers!

Sandy.

Piotr,

I mean to say, I got quick another Solution for this,

But your query is working fine, No issue on that but it may raise a performance issue if the table...

hey Piotr,

I got a new solution and also interesting, I am not sure It is correct or Not but Still its working fine for me...

Only one condition works fine for...

Hi Anoop,

I will prefer to use Custom Error Checking rather than Try-Catch method.

Can you just tell me why you wants to apply the Transaction on a DDL Command also.

Cheers!

Sandy.

hey peso,

Can you give me some Idea how it works and what is the new concepts are added to this CROSS...

Peso,

Is it in SQL Server 2005 or Sql Server 2008?

Cheers!

Sandy.

Hi Peso, 🙂

Really nice to here from you this concepts.

Now I am more clear on my topic,

Thanks for the same again,

Cheers!

Sandy.

hey peso,

I've a little confusion regards the seconds you have...

Thanks Peso,:)

But we can achieve this by running sp_updatestats on the Database.

here I wants to know, Is there any...

hey Piotr,

I resolved the issue by using dynamic crosstab query concept.

by checking each userid with respect to groupid.

Anyways thanks a lot.

Cheers!

Sandy.

hey Hasan,

Cool Man, I was roaming for this....

Thanks a lot, But I have a little confusion on this link topic, the index seek is taking 88% cost, where as the...

Hey peso,

As this is a OLAP database,

I just drop the Index and recreated

very Imp:

Execute sp_updatestats.

now its going for a Index Seek.

Cheers!:P

Sandy.

Hey Peso,

I got the solution. Its working fine now and its going for a Index Seek.

Cheers!

Sandy.