How can I insert data directly instead variable table ?

Question

Hi,

following is my code

    

 CREATE TABLE #GenericTradeImport
    (
        GenericTradeImportId   INT IDENTITY(1, 1),
        PortfolioId int NULL,
   SecurityId int NULL,
        Hash_Security BINARY(20),
        TradeId INT,
        FinancialInstitutionId int NULL,
        StrategyTypeId int NULL,
        CurrencyId int NULL,
        TradeStatusId int NULL,
        Price decimal(18,4) NULL,
        Quantity decimal(18,4) NULL,
        TradeDate datetime NULL,
        SettleDate datetime NULL,
        Commission decimal(32,4),
        Notes varchar(max) NULL,
        Buy BIT,
        Long BIT,   
        NativePositionId varchar(500) NULL,
        NativeTradeId varchar(500) NULL,
   AccountingSourceId int NULL,
        SecurityType varchar(100) NULL
    )

    INSERT
        #GenericTradeImport
    SELECT
        PortfolioId,
        SecurityId,
        HASHBYTES(
                'SHA1', 
                CAST(@PersistenceSourceId AS VARBINARY) + 
                CAST(CASE SecurityType WHEN 'Bond' THEN @SecurityEntityType_Bond WHEN 'Loan' THEN @SecurityEntityType_Loan WHEN 'Equity Option' THEN @SecurityEntityType_EquityOption ELSE '' END AS VARBINARY) + 
                CAST(CAST(SecurityId AS VARCHAR(500)) AS VARBINARY)),
        NULL,
        FinancialInstitutionId,
        StrategyTypeId,
        CurrencyId,
        TradeStatusId,
        Price,
        Quantity,
        TradeDate,
        SettleDate,
        Commission,
        Notes,
        Buy,
        Long,
        NativePositionId,
        NativeTradeId,
   AccountingSourceId,
        SecurityType
    FROM
    @GenericTradeImport GenericTradeImport

in above i'm inserting data into table    #GenericTradeImport from variable table @GenericTradeImport 

but can i directly insert values instead from @GenericTradeImport ??

what should I changes in FROM section ?

please help me for syntax 

thanks

---

Ashish Fugat (ashuthinksatgmail.com) SE

Answer 1

Or can i do something like

 DECLARE @GenericTradeImport dbo.GenericTradeImport
 
  INSERT INTO
        @GenericTradeImport
        (
            PortfolioId,
            SecurityId,
            FinancialInstitutionId,
            CurrencyId,
            TradeStatusId,
            Price,
            Quantity,
            TradeDate,
            SettleDate,
            Commission,
            Notes,
            Buy,
            Long,
            NativePositionId,
            NativeTradeId,
            SecurityType
        )
        Select
(my own values hardcode) ?

---

Ashish Fugat (ashuthinksatgmail.com) SE

Answer 2

See Value Constructor http://msdn.microsoft.com/en-us/library/dd776382(v=sql.100).aspx . Just for hardcode (constant?) values insertion.

---

Serg