posted too quick see comment below.

You could do use this command line

<drive>:\setup.exe /ACTION=INSTALL /IAcceptSQLServerLicenseTerms="True" /FEATURES=BC,CONN,ADV_SSMS

This will install the following

BC = Basic Compatibility

CONN = Connectivity components

ADV_SSMS = Full SSMS install

That should be all you...

Ok...

Koen Verbeeck (2/20/2015)

---

rhythmk (2/19/2015)

---

How will you achieve it ?

Think of the scenario where OP wants to do...

Two methods.

Method one, Best way (you need to add data types)

/*

ADD DATA TYPES

*/

CREATE TABLE MyNewTable

(

UniqueId

,Company

,CustId

,CustomerName

,FiscYr

,YTDSales

,YTDRcpt

)

GO

INSERT INTO MyNewTable

(

UniqueId

,Company

,CustId

,CustomerName

,FiscYr

,YTDSales

,YTDRcpt

)

SELECT

UniqueId

,Company

,CustId

,CustomerName

,FiscYr

,YTDSales

,YTDRcpt

FROM

[dbo].[HistInfo]

GO

Method two simpler way is to use this.

SELECT

UniqueId

,Company

,CustId

,CustomerName

,FiscYr

,YTDSales

,YTDRcpt

INTO

MyNewTable

FROM...

Doing double hop currency conversion is always fun, this is an example of how to do it from a system I worked on.

SELECT

FromCCY.CCYAS FromBaseCCY

, ToUSD.CCYAS ToUSDCCY

, FromCCY.CCYRateAS...

I've had my morning coffee and think this might work, but you need a secondary table.

After the conversion task add Mulitcast, On one side send the data into the...

wrong solution provided by me....... 😛

Warm Cache? Basically the pages would already be in memory from the first query so unless you flush the cache or they have expired the engine doesn't need to...

I've just noticed that you will probably have to include the PartID in Lowells joins and in the ROW_NUMBER() window function.

matzj (2/18/2015)

---

Thanks for the reply Jason! Unfortunately I get an error with the LEAD function that it isn't a recognized built-in function name. I had thought about that...

This looks like a Job for the LEAD/LAG functions

something like this

WITH CTE_LEAD

AS

(

SELECT

RowId

,Customer_ID

,PartId

,EffectiveDate

,DISCONTINUE_DATE

,ISNULL

(LEAD(Effective_DATE,1)

OVER (PARTITION BY CustomerId,PartId ORDER BY EffectiveDATE)

...

I understand now its been explained, I'm still mystified why it cant do the calculation then look at the right side then fill the left side with what's left, rather...

I actually answered that QotD and got it right. :hehe:

It makes sense for there to be truncation to prevent data...

Ok so I've spent lunch investigating and it seems that the issue is a little deeper than first thought.

In the example below, using the same values as the opening post...