This raises more questions.

Your example has 2 breeds. What happens when there are more?

How do you relate Pitbulls to Boxers? Or any...

For example, 'pitbull' is in the table 6 times and 'boxer' is in the table 4 times. They both need to be listed in the database 5 times each based...

I am posting this as A solution, not as THE solution. I am hoping to learn from a critique of the answer as much as you are!

Deleting is easy. The...

archyya (2/1/2016)

---

CREATE TABLE [dbo].[teamLogs]

etc . . .

WinsLast5games would be an aliased field that would be in this lineup:

team W L Ov Un WinsLast5games

STL 11 5 6...

This is untested air code. But, it should be close enough to get you pointed in a direction that should work.

;with cte as

(

Select team, ats, atsloss, O,...

Quite frankly, your boss does not know what he/she is talking about. Reuse of ID's like...

imba (1/14/2016)

---

I have a data output that looks like this:

SELECT A+|+B+|+C

Output is A|B|C similar to a text file.

Is there anyway that I can insert A, B, C into a table...

imba (1/14/2016)

---

I have a data output that looks like this:

SELECT A+|+B+|+C

Output is A|B|C similar to a text file.

Is there anyway that I can insert A, B, C into a table...

Setting aside the fact that you don't need an Identity...

I don't know. The specs keep changing.

What the heck. Here are two solutions! The first is a 2012 or better, the other for 2008. Of course, using lead provides much better performance in this case....

I'm pretty sure I have a solution. You need to provide a little more information. I need to know which start_date and which end_date you are using in the datediff...

karine.gambarjan (1/8/2016)

---

This returns DATEDIFF from the startdate and end_date of the same row where End_date is not null, while I need to calculate a DATEDIFF between 2011-02-01 (end_date row 2)...

This is a naive way of doing it, but it works.

declare @iDate int = 01092015

select cast(substring(cast(@iDate+100000000 as char(11)), 6, 4) + substring(cast(@iDate+100000000 as char(11)), 2, 4) as date)

Here is a slightly less complicated version that gives you the difference in days: (Note the setup of table and data!)

declare @t table

(

id int,

product...