Hey Thanks yaar !!! it...

Hi Scott ! Yes its working !! Thanks !!

But could you say me is there a way where the user can see all fields together and when needed they can...

Hi Can...

Thanks for your replies guys !!

hi Thks for your reply.

I tried accessing as you said from my hope PC, but it said, "Network Access Mesasge: Page cannot be displayed"

my link is http://192.168.42.176/Reports_SQL2008

any...

hi ! any guess how to achieve designing the layout??

rvasanth (8/9/2010)

---

Create Procedure Testing

(

@Col int

)

AS

DECLARE @sql VARCHAR(MAX)

DECLARE @grp1 VARCHAR(1000)

DECLARE @grp2 VARCHAR(1000)

//DECLARE @Col VARCHAR(10)

DECLARE @SELECTLIST VARCHAR(MAX)

//SET @Col= 2

SET @grp1= '[Tab1SalesHeader].No, [Tab1SalesLine].Description, [Tab1SalesLine].[Variant Code]'

SET @grp2= '[Tab1SalesHeader].No, [Tab1Sales...

Of Course i have Too !!

Thanks Mr. Vasanth !! :O)

Wow !! Really very Happy !! Thanks a Lot ColdCoffee !! U Rocking txtPost_CommentEmoticon(':-)');

It works .. hooooo...

Wondering tht the task become possible from impossible (As i started this thread so).....

Dear ColdCoffee, Thanks for your guidance. I wish to say all, tht i am not a proffesional procedure creator. this is my first task given. ll learn soon all things...

Sorry for the previous message..

Now when executing its throwing,

Exec Testing '20100101', 1

Msg 102, Level 15, State 1, Line 6

Incorrect syntax near '1'.

Please any one reply !!!

Hi ! Thanks for your help !!

Again now i need to pass a date parameter too, so i did modified the procedure still as below,

Create Procedure Testing

(

@Date Datetime

@Col int

)

AS

DECLARE...

Vasanth !! Extraordinary !!! It worked !!

When i executed no error was thrown and the procedure was created.

Actually i wish to pass the Col value as parameter that the user...

Oh sure Thanks,

The error is as below

Msg 102, Level 15, State 1, Procedure Testing, Line 4

Incorrect syntax near '('.

Msg 137, Level 15, State 2, Procedure Testing, Line 9

Must declare the...