------=_NextPart_0001_03960B88
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
You will need to post this in the SQL Server user groups.
One thing you could try though is the SQL Utility built in that will
translate most of PL-SQL to T-SQL.
-James
This posting is provided "AS IS" with no warranties, and confers no
rights.
EBusiness Server Team
From: =?Utf-8?B?S3VzaGFs?= <Kushal@[EMAIL PROTECTED]
>
Subject: Oracle to Sql Server Migration
Date: Fri, 10 Jun 2005 05:16:02 -0700
Newsgroups: microsoft.public.commerceserver.solutionsites
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
------=_NextPart_0001_03960B88
Content-Type: text/x-rtf
Content-Transfer-Encoding: 7bit
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0
MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 You will need to post this in the SQL Server
user groups.
\par
\par One thing you could try though is the SQL Utility built in that will
translate most of PL-SQL to T-SQL.
\par
\par -James
\par
\par This posting is provided "AS IS" with no warranties, and confers no
rights.
\par
\par EBusiness Server Team
\par
\par From: =?Utf-8?B?S3VzaGFs?= <Kushal@[EMAIL PROTECTED]
>
\par Subject: Oracle to Sql Server Migration
\par Date: Fri, 10 Jun 2005 05:16:02 -0700
\par Newsgroups: microsoft.public.commerceserver.solutionsites
\par
\par DATAITEMS
\par DATAITEMID\tab APICODE\tab WEBDESC\tab DATATYPE
\par 1\tab GlobalRegionId\tab Region\tab PickList
\par 2\tab CountryId\tab Country\tab PickList
\par 3\tab StateID\tab State\tab PickList
\par 4\tab ExchangeId\tab Exchange\tab compoundpicklist
\par
\par PICKLIST_ITEMS
\par
\par PICKLISTITEMID\tab WEBDESC\tab VALUE\tab PARENTPICKLISTITEMID
\par 1\tab Asia\tab 10001\tab Null
\par 2\tab Europe\tab 10002\tab Null
\par 3\tab India\tab 134\tab 1
\par 4\tab Pakistan\tab 135\tab 1
\par 5\tab England\tab 101\tab 2
\par 6\tab France\tab 100\tab 2
\par 7\tab AP\tab 500\tab 3
\par 8\tab UP\tab 501\tab 3
\par 9\tab State1\tab 400\tab 5
\par 10\tab State2\tab 300\tab 6
\par
\par If I choose region as the data item It should return all the region ,
its
\par countries and its states in rows.
\par
\par How to implement this in SQL server..
\par
\par Please advise.
\par
\par Thanks,
\par Kushal
\par
\par
\par
\par }
------=_NextPart_0001_03960B88--
|
