May 5, 2012 at 2:31 am
The View that you created doesn't show any data....you need post the sample data in the tables which would show in the View. Since you want to pivot the View...without any data in the View....we don't have much to work with.
I have MSOffice 2000 on my system so I can't open your attachment. So, you can either post it here or someone who can view your result might help you.
I won't be of much help without some data in the View or without being able to view your result.
May 6, 2012 at 11:00 pm
hello.
I put script for insert in to tables that used in view.please first create tables and insert into its and then run view.please give me script of pivot for my procedure.thanks
May 7, 2012 at 3:49 am
elham_azizi_62 (5/6/2012)
hello.I put script for insert in to tables that used in view.please first create tables and insert into its and then run view.please give me script of pivot for my procedure.thanks
Yes, you did provide the DDL of tables and the Sample Data for the Tables in the correct format.
But, the View that you are creating does not contain any data. You asked me to create tables first, then Insert Data into them and then create View.
This is equivalent to Deleting the View and recreating it.....right??
So, I deleted it and recreated the View and there is still no data in the view.
You need to provide such sample data in the tables that will show in the view.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply