select

'Securities' as PositionGroup ,

'' Product,

cob,

InstrumentRef,

Company,

PartyRef,

Position,

PositionDT,

BalanceCD,

ColumnCD,

AccInt,

InstrumentGrp,

CAST( AccountCode1 AS VARCHAR(50)) AS AccountCode1,

DebtAmt1,

CreditAmt1,

CAST( AccountCode2 AS VARCHAR(50)) AS AccountCode2,

DebtAmt2,

CreditAmt2,

Accrual_Lifecycle_Event,

PTD_Accrued_Interest_TB,

MidPrice_Close,

BidPrice,

OfferPrice,

PalpType,

DenomCCY,

Position_Notional,

Position_Cost,

MarketValue,

UnrealPnL,

RealPnL,

Daily_Position_Mvt,

Daily_UnrealPnL,

Daily_PnL,

AveragePrice,

BookDescription,

MarketPrice,

MidFX_Close,

Market_Value_Base,

Daily_PnL_Base,

Daily_MarketPrice_Mvt,

'' as LateTradeInd

from [SSASTabular].[vWStockPosition_Securities]

union all

select 'Derivative- Futures' as PositionGroup,

product,

cob,

InstrumentRef,

Company,

PartyRef,

Position,

PositionDT,

BalanceCD,

ColumnCD,

AccInt,

InstrumentGrp,

CAST(NULL AS VARCHAR(50)) AS AccountCode1,

DebtAmt1,

CreditAmt1,

--NULL AccountCode2,

CAST( AccountCode2 AS...

Check

http://support.microsoft.com/?id=811168

http://support.microsoft.com/?id=254321

Golden rules:

Always have good backups of your system and user databases.

Stop non-sql services before applying the service pack.