Thanks koen,

But here I am using Excel 2007 my export working fine for Excel 97-2003 but as this has boundation of limited rows i can not use it. i tried...

Hey thanks HowardW.

I got the details and now I have updated myself 😛

Regards,

AJ

And thanks to all for your valuable inputs and time 🙂

Really I learned so much new today.

Regards,

AJ

Thanks Gianluca Sartori,

Its really a very good article, now I have most of the information about Table variable...

Hey thanks guys for you valuable inputs. I did the same what Craig & Lutz suggested and now I am getting the Index seek instead of scan. My query performance...

Hey Thanks Creig,

So such a query can not be improved, there will always be an index scan.

So i think i got my answer:crying:

Thanks

I have created only one clustered index and that is on FirstName column, and no other index has been created not even any non clustered index.

So is there any...

Hi kramaswamy,

I have worked in some performance tuning tasks and we always prefer to use

EXISTS(select 1 from table Where.............)

Also one more point if you are fetching data from multiple...

!

Dave,

I am already using CTE to generate the RowID as per the Order by column passesd. For which I am using the Dynamic Order By.

As per my requirement I have...

I think the topic is diverted 🙂

To avoid the casting we can use multiple case in order by which i do

case

when @sortorder...

Hi GilaMonster,

I tried it after removing the single quotes but now I am getting error

"Invalid column Name UserName".

🙁

Yes Bob,

I have Order By clause in my query.

Actually I am trying to implement the custom paging in my application and for that I have to fetch the count as...

Thanks Dave,

This is what I am doing right now but I just want to ignore the full table scan, so if after filtering it gives me count = 200...

Hi Peso,

i tried your code but it did not work.

Are you sure it works?

Thanks