Query Help (1 Viewer)

[dzirkelb]

I have the following query which basically is an instert into a table with a select statemet insde if...here it is:

INSERT INTO [QUOTES DETAIL] ( SEQ, [QUOTE #], QTY, [CUST ITEM #], MFG, [PART #], PRICE, UM, [DEE COST], DELIVERY, NOTES, SOURCE, INTNOTE, TAG, MARK_UP, MinQty, StdPkgQty, [NC/NR], PriceBreakInfo, QteLineID, PartID, InvCode, VenMarginRating, CustMinQty, CustMultQty, VendorID, MfgOrderFrequencyInfo, [Frt%], Turns, TotQty, TranactionType, CurrentBiz, NCPipelineQty, NCWindowDays, WgtFctr, PrintCustMinMult, FacMin, Schd )
SELECT [QUOTES DETAIL].SEQ, @NewQuoteNum, [QUOTES DETAIL].QTY, [QUOTES DETAIL].[CUST ITEM #], [QUOTES DETAIL].MFG, [QUOTES DETAIL].[PART #], [QUOTES DETAIL].PRICE, [QUOTES DETAIL].UM, [QUOTES DETAIL].[DEE COST], [QUOTES DETAIL].DELIVERY, [QUOTES DETAIL].NOTES, [QUOTES DETAIL].SOURCE, [QUOTES DETAIL].INTNOTE, [QUOTES DETAIL].TAG, [QUOTES DETAIL].MARK_UP, [QUOTES DETAIL].MinQty, [QUOTES DETAIL].StdPkgQty, [QUOTES DETAIL].[NC/NR], [QUOTES DETAIL].PriceBreakInfo, [QUOTES DETAIL].QteLineID, [QUOTES DETAIL].PartID, [QUOTES DETAIL].InvCode, [QUOTES DETAIL].VenMarginRating, [QUOTES DETAIL].CustMinQty, [QUOTES DETAIL].CustMultQty, [QUOTES DETAIL].VendorID, [QUOTES DETAIL].MfgOrderFrequencyInfo, [QUOTES DETAIL].[Frt%], [QUOTES DETAIL].Turns, [QUOTES DETAIL].TotQty, [QUOTES DETAIL].TranactionType, [QUOTES DETAIL].CurrentBiz, [QUOTES DETAIL].NCPipelineQty, [QUOTES DETAIL].NCWindowDays, [QUOTES DETAIL].WgtFctr, [QUOTES DETAIL].PrintCustMinMult, [QUOTES DETAIL].FacMin, [QUOTES DETAIL].Schd
FROM [QUOTES DETAIL]
WHERE ((([QUOTES DETAIL].[QUOTE #])=@OldQuoteNum))

I wish to add to the field INTNOTE some static information. I wish it to start with "Duplicate quote from @OldQuoteNum" and then pull the information from the select statement and add it after. Is this possible or should I just do it in .asp code? This is a stored procedure btw.

 

[pbaldy]

This type of thing should work:

SELECT Field1, Field2, "Your text here " & Field3, Field4...

 

[dzirkelb]

'Duplicate quote from ' & QUOTES.[INTERNAL NOTES],

That give me the error:

Invalid operator for data type. Operator equals boolean AND, type equals varchar.

 

[pbaldy]

I'm sorry, SQL Server would want + instead of &.

 

[dzirkelb]

Here is what it looks like now
'Duplicate quote from '+@QuoteNumNotes +' '+ QUOTES.[INTERNAL NOTES]

Here is what my test looked like:

Duplicate quote from 2 test from dave

The 2 needs to be 278124...it only took the first character...any ideas?

 

[dzirkelb]

nm, i had my varchar declard as no size, fixed it...thanks!