Jeff Moden (7/21/2015)

---

sgmunson (7/21/2015)

---

If all you go by is the example that shows a float data type not having a problem where a rather...

EDIT: duplicate post - deleted content

jghali (7/22/2015)

---

Hi all,

I'm testing, with SQL 2014 on the same DB, a procedure that extracts data from a table into a file and Loads data from that file...

gonzalezfa (7/17/2015)

---

Congratulations for the site!

I'm new to developing Windows Phone applications, need to know which is the best alternative to work offline (LocalDb), synchronize and update a database in SQL...

gonzalezfa (7/17/2015)

---

Congratulations for the site!

I'm new to developing Windows Phone applications, need to know which is the best alternative to work offline (LocalDb), synchronize and update a database in SQL...

Here's a FULL OUTER JOIN implementation. Let me know if this works:

DECLARE @Table1 AS TABLE (

GroupID int,

Info1 varchar(10)

);

INSERT INTO @Table1 (GroupID, Info1)

VALUES (1, 'a'),

(2, 'b'),

(4, 'c'),

(5, 'd');

DECLARE @Table2 AS...

drew.allen (7/21/2015)

---

As far as I can tell, this yields exactly the same plan, but I find it simpler to follow.

SELECT CompanyName, Year, Month, Cost

,AVG(Cost) OVER(PARTITION BY CompanyName) AS AverageCost

,SUM(Cost) OVER(PARTITION...

mxy (7/18/2015)

---

thanks for your reply Jeff. Data is correct,

Ex: BOFA has multiple share holders and it can hold shares on its own account.

If BOFA has a child as bank A,B

Bank...

If all you go by is the example that shows a float data type not having a problem where a rather narrowly defined decimal...

santa326 (7/20/2015)

---

Hi,

I donno what I am missing.But this one task is proving to be the most challenging for me.

Sorry for the lack of experiance on CTE.

Can anyone please review the...

s.raddy.89 (7/16/2015)

---

I have a table like this

Name Cost Year Month

shory 34346 ...

Matt Miller (#4) (7/16/2015)

---

sgmunson (7/16/2015)

---

Matt Miller (#4) (7/16/2015)

---

Luis Cazares (7/16/2015)

---

If you can see the leading zeros in the file using notepad or something similar, that might be an excel problem....

You're welcome. Glad I could help.

Bharatvip (7/16/2015)

---

It is on SQL 2012. The inserts do have several large varchar(max) columns being inserted and we wanted to make sure that it will handle 40 to 50,000 transactions...

Matt Miller (#4) (7/16/2015)

---

Luis Cazares (7/16/2015)

---

If you can see the leading zeros in the file using notepad or something similar, that might be an excel problem. Be sure to define...