DATAITEMS DATAITEMID APICODE WEBDESC DATATYPE 1 GlobalRegionId Region PickList 2 CountryId Country PickList 3 StateID State PickList 4 ExchangeId Exchange compoundpicklist PICKLIST_ITEMS PICKLISTITEMID WEBDESC VALUE PARENTPICKLISTITEMID 1 Asia 10001 Null 2 Europe 10002 Null 3 India 134 1 4 Pakistan 135 1 5 England 101 2 6 France 100 2 7 AP 500 3 8 UP 501 3 9 State1 400 5 10 State2 300 6 If I choose region as the data item It should return all the region , its countries and its states in rows. How to implement this in SQL server.. Please advise. Thanks, Kushal
Sorry, this probably isn't the best forum to ask SQL questions. Better try microsoft.public.sqlserver.server or another newsgroup like that... Thanks, Akshai -- This posting is provided "AS IS" with no warranties, and confers no rights Please do not send email directly to this alias. This alias is for newsgroup purposes only. "Kushal" wrote in message news:08787530-1A1B-497C-BC0C-1168961F2932@microsoft.com... > DATAITEMS > DATAITEMID APICODE WEBDESC DATATYPE > 1 GlobalRegionId Region PickList > 2 CountryId Country PickList > 3 StateID State PickList > 4 ExchangeId Exchange compoundpicklist > > PICKLIST_ITEMS > > PICKLISTITEMID WEBDESC VALUE PARENTPICKLISTITEMID > 1 Asia 10001 Null > 2 Europe 10002 Null > 3 India 134 1 > 4 Pakistan 135 1 > 5 England 101 2 > 6 France 100 2 > 7 AP 500 3 > 8 UP 501 3 > 9 State1 400 5 > 10 State2 300 6 > > If I choose region as the data item It should return all the region , its > countries and its states in rows. > > How to implement this in SQL server.. > > Please advise. > > Thanks, > Kushal > >
