Hey Chris,

I would suggest to implement the paging concept in Stored Procedure to return 20 rows rather than all the rows.

This Stored Procedure should take one additional parameter like @page,...

Hey Jason Tontz,

In SQL 2005,

you can use this Query.

SQL SCRIPT

=========

SELECT

OrdProductPivot.orderdate,

[1000345] = ISNULL([1000345], 0),

[1000355] = ISNULL([1000355], 0),

...

Hey Jeff :),

Great Standard of Code,

I really feel its the way need to be done.

but i have a small issue here,

when i am trying to copy your code to...

Hey Pheona,

Why are you not using Stored Procedure to produce the result set

for your report.

which is a good way to handle the performance in SQL Server

rather than creating view...

Hi Andras Belokosztolszki,

Thanks for your quick reply,

I got the solution,

Thanks again for the same.

Cheers!

Sandy.

Hey Matjaz Justin,

Great post,

its really helpful in the future,

but don't you think its more Complex way rather than

using simple updates on multiple tables by using transaction,

like this

=======

Begin Tran

Update...

Thanks Andras,

For your quick reply,

Cheers!

Sandy.

Hey Piotr Rodak,

Thanks A Lot.

Cheers!

🙂

Sandy.

Hi All, (John, Matjaz, Grant, Jeff, Ramesh)

I agree with you all,

I was wrong, because I was thinking the

Query below is a Single Query,

UPDATE #Tb1

SET name = 'ccc'

UPDATE...

nope,

I was trying to use the nested Updates statement

in SQL Server.

Cheers!

Sandy.

Hey Grant & Jeff,

I think you both are concentrating multiple table updates

rather than Nested Update Statement,

I clearly mentioned that I have used Nested Update statement

rather than Multiple Table Updates,

And...

Hey Jeff Moden,

I didn’t mean that

I apology if you mind it,

I just specify my favorite members in this forum,

Now I am also adding you as my favorite member,

Now happy.....:P

& wats...

hi,

I need the feedback for the Above Topic

from below SQL Gurus,

1. Steve Jones

2. Grant Fritchey

3. Andras Belokosztolszki

4. John Mitchell

Cheers!

Sandy.

Hey Antony,

I execute your SQL Query,

I found 2nos. Error,

1st Error

======

Table name is not Correct,

you have specified TableA instead of #TableA

2nd Error

======

You have used alise name in Set Statement

which...

Hey John Mitchell,

Thanks for sending me the link,

(Nice link, really helpful)

Cheers!

Sandy.