over here 1* is public holiday
when am creating 31 columns naming 1,2,3,4..31
it wont map the 1* since 1* column name is not same
so how can i do it any ideas because public holiday can fall on any day depending on the selection on the user...
ALSO
now AM creating 35 columns in data table any other method so that i dont have to create 35 columns plzzzzz plzz help ???
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 10 Feb 2012 at 6:43am
since it is a sp, name the columns 1-31 and put a field IsHoliday and set it to true instead of changing the column name.
depending on how you're going to use it, pivot the table to have 31 rows with only a couple of columns and have the report format it (using multi column report)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
