Briceston (12/30/2016)

---

Hi all,

I have two tables that I'm trying to reconcile the dollar amounts. However, I'm encountering some issues when the data does not align perfectly based on the fields...

Alan.B (1/2/2017)

---

I have seen the REPLACE performance issue and agree 100%.

Why any splitter? You can just use CHARINDEX/SUBSTRING (note my earlier example) which will beat the pants off any...

farooq.hbs (12/26/2016)

---

Hi,

Need a help on one SSIS package.

Wanted to move master and child two tables data from source to destination by coping the new Identity column value from master...

mightycaptain (1/1/2017)

---

Have a problem that has me stumped. MSSQL 2014. The problem is this. Have a table storing id, date, occurrence(bit field).

id can be repeated. The date for the same...

Robert Frasca (1/2/2017)

---

Just to reiterate. It is not a problem with the connection string. There are absolutely no extra semi-colons and it has been checked 100 times at least. In...

Robert Frasca (12/22/2016)

---

I've got an SSIS project that uses an environment variable for it's connection string.

This is the connection string: Data Source=localhost;Initial Catalog=RESDataMart;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;

It's a perfectly valid connection string...

Jeff Moden (12/28/2016)

---

IIRC, PARSENAME has an element length of NCHAR(128) as a limit on each part it returns and is heavily dependent on the consistent position of items but the...

v.razaghzadeh (12/22/2016)

---

Dear Steve

I have made changed the records and below are sample results from each tables in my script:

Sale_Basket:

Basket_idDay_Uid_TRADESite_Code_PHYSICALCustomerLoyaltyNumberIsTradeIsVoidBasketPriceTOTAL

223066019201610202722123456781062.95

223066020201610202120234567891041.95

22306602420161020D15311223521101000.95

22306602520161020D1521234567810480.95

2230660262016102028125246514710130.95

2230660272016102022271247898710271

2230660352016102028121234567810270.5

22306603720161020D1231451234610152.95

22306603920161020D124164532151087.95

22306604320161020D125138521451080.95

Rewards_SpendActivity:

Basket_idRwdMember_id

2230660246666666

2230660272345678

2230660371111111

1555487988888888

999999996666666

888888881111111

777777779999999

666666663827370

2230660393827370

2230660435555555

map_SiteBusinessManager

Site_CodeAreaName_BM

2120Mens GF

D125Mens LG

D152Womens

D125Womens

D124Sport

D123mens GF

D125mens LG

D126mens LG

2190Sports

2215Menswear GF

Sale_Line

Basket_idLine_idSite_Code_POSTINGArticle_Code_POSTINGDay_Uid_TRADELinePriceIncVATIsVoidIsTrade

223066037186667668D1251232016102012900

155548798191555490D1231452016102010900

9999999919156109822151652016102019.9500

88888888191561099D4471462016102014.9500

777777771915611722190123201610202000

10078922719156117321901452016102054.500

777777771915660572120167201610202.9100

1007911191915660582215168201610203.900

100791119191566059D123196201610201.200

1007911191915660602215196201610202.200

dim_Site

Site_CodeChannel_Code

2212 ...

DK13 (12/22/2016)

---

Thank you everyone! The scope of the responses were a bit above my experience but I managed to use them to get a working solution. And needless to...

pgoldy (12/21/2016)

---

Symptom: We add ~1500 users via the SSRS 2016 report portal to a folder via the security tab. Viewing the security tab at a point in the future and...

Sonny Childs (12/21/2016)

---

This feels a bit dirty, but here's what I came up with:

DECLARE @sql VARCHAR(max)

DECLARE @DateStart DATETIME

DECLARE @DateEnd DATETIME

SELECT @DateStart = MIN(SysStartTime)

,@DateEnd = GETDATE()

FROM SchemaName.TableName

SELECT...

TheSQLGuru (12/21/2016)

---

sgmunson (12/21/2016)

---

whenriksen (12/21/2016)

---

Here you just...

frederico_fonseca (12/20/2016)

---

Thanks Steve. Indeed no pun intended with RTFM.

David, as per the link I added (from the manuals) there are indeed ways to do it - JDBC from what i...

kchaplin (12/21/2016)

---

I have a SQL 2012 R2 standard runtime edition server non VM using Virtual Drives for all dat and log files on a Cybernetics SAN. One of the databases...

v.razaghzadeh (12/20/2016)

---

Dear Steve

thanks for the reply. Can oyu please advise if you would like me to send you a line of result for ech table is this what you...