Viewing 15 posts - 76 through 90 (of 901 total)
posted too quick see comment below.
March 2, 2015 at 12:56 am
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...
February 26, 2015 at 7:49 am
Sangeeth878787 (2/20/2015)
Hi Jason,Your script nearly satisfies the two cases, but I need it as function or store procedure to satisfy all the 4 cases. I am glad for your script.
Ok...
February 20, 2015 at 6:58 am
Koen Verbeeck (2/20/2015)
rhythmk (2/19/2015)
anshulparmar (2/19/2015)
Try using OLE DB Command instead and update flag while inserting new records.
How will you achieve it ?
Think of the scenario where OP wants to do...
February 20, 2015 at 2:02 am
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...
February 20, 2015 at 12:46 am
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...
February 20, 2015 at 12:27 am
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...
February 20, 2015 at 12:17 am
wrong solution provided by me....... 😛
February 19, 2015 at 10:53 pm
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...
February 18, 2015 at 9:51 am
I've just noticed that you will probably have to include the PartID in Lowells joins and in the ROW_NUMBER() window function.
February 18, 2015 at 9:47 am
matzj (2/18/2015)
February 18, 2015 at 9:17 am
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)
...
February 18, 2015 at 9:11 am
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...
February 18, 2015 at 8:49 am
Mark Cowne (2/18/2015)
I posted a QotD about this a while ago
I actually answered that QotD and got it right. :hehe:
It makes sense for there to be truncation to prevent data...
February 18, 2015 at 8:01 am
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...
February 18, 2015 at 7:45 am
Viewing 15 posts - 76 through 90 (of 901 total)