SELECT CAST(CAST(datefield AS DATE) AS DATETIME)

FROM datetable

HI tri_hartanto,

First, It's so fuzzy to understand what you are trying to do.

Please furnish table structure with sample data and with your intended Result Set/Table and describe what you trying...

Try this....

CREATE PROCEDURE [cost].[Ingredient_Cost_Comparison]

(

@CustomerNumber_BillToNVARCHAR(20)

,@CurrentSalesQuoteNumberNVARCHAR(20)

,@PriorSalesQuoteNumberNVARCHAR(20)

,@CurrentItemNumber1NVARCHAR(20)

,@PriorItemNumber1NVARCHAR(20)

,@CurrentItemNumber2NVARCHAR(20)

,@PriorItemNumber2NVARCHAR(20)

,@CurrentItemNumber3NVARCHAR(20)

,@PriorItemNumber3NVARCHAR(20)

--,@CurrentItemNumber4NVARCHAR(20)

--,@PriorItemNumber4NVARCHAR(20)

--,@CurrentItemNumber5NVARCHAR(20)

--,@PriorItemNumber5NVARCHAR(20)

)

AS

BEGIN

SELECT DISTINCT

s.CustomerNumberAS 'CurrentCustomerNumber_BillTo'

,s.SalesQuoteNumberAS 'CurrentSalesQuoteNumber'

,s.SalesQuoteLineNumberAS 'CurrentQuoteLineNumber'

,s.ItemNumberAS 'CurrentItemNumber'

,s.ItemDescriptionAS 'CurrentItemDescription'

,s.ComponentItemNumberAS 'CurrentComponentItemNumber'

,s.ComponentItemDescriptionAS 'CurrentComponentItemDescription'

,s.ComponentItemLevelAS 'CurrentComponentItemLevel'

,s.BOMQuantityAS 'CurrentBOMQuantity'

,s.BOMUnitOfMeasureAS 'CurrentBOMUnitOfMeasure'

,s.CostTypeUsedAS 'CurrentCostTypeUsed'

,s.CostMaterialWorksheetAS 'CurrentCostMaterialWorksheet'

,s.CostMaterialMarketExtendedAS 'CurrentCostMaterialMarketExtended'

,s.RequestedDeliveryDateAS 'CurrentRequestedDeliveryDate'

INTO #Current

FROM dw.cost.vStd_SalesQuoteCostLineBOM s (NOLOCK)

WHERE s.CustomerNumber IN...

Yaahhh huuu... I Got it.. I found where I'm doing mistake. The culprit is local temp table. Yes while we are using BCP command it create a new connection because...

It say's can't find the file

No its not working either with .BAK. I don't think it would be a problem with .bak but some thing I'm doing wrong with temp table. Any how it would...

Most oftenly Nonclustered indexes are created on a columns where those are columns are heavily used in query's to improve the query performance. especially where Clustered index columns are not...

Clear and Nice. Appreciated!!

Got it. Thank you for your response

I'm not clear on your reason. Could you explain little further.Assume that the data inserting in clustered & non clustered index tables are different.

Thanks for all the reply's. I will try to implement.. I will get back if its still a problem... Thank you all