Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranganath
Posting Yak Master
209 Posts |
 Posted - 2008-10-17 : 05:59:51
|
| DECLARE @Table Table( PortId Int, CulturdeCode varchar(100), LocalizationItem varchar(1000), LocalText Varchar(100))Insert into @TableSelect 1, '0x0409','btn_Cart_CancelOrder', 'Cancel Order' union allSelect 1, '0x0c0c','btn_Cart_CancelOrder', 'CO' union allSelect 2, '0x1009','btn_Cart_CancelOrder', 'CA' union allSelect 2, '0x0409','btn_Cart_Checkout', 'CONTINUE' Select * From @TableOUTPUT TABLEPORTALID LOCALIZATIONITEMID VALUE_EN_US VALUE_EN_CA VALUE_FR_CA1 btn_Cart_CancelOrder Cancel Order NULL CO2 btn_Cart_CancelOrder NULL CA NULL1 btn_Cart_Checkout CONTINUE NULL NULL--Note : CulturdeCodes is more |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-17 : 06:06:01
|
| do you mean CulturdeCodes values are dynamic |
 |
|
|
ranganath
Posting Yak Master
209 Posts |
Posted - 2008-10-17 : 06:09:20
|
| yes |
|
|
|
|
|
|
|
|
Need Help