Sweetbee870 (1/8/2016)

---

I Need some help! I'm New and learning SQL I have the basics of SQL down but I need some help with Joins more specifically Inner Joins with linking...

Piling on, with this little information there is...

SQLRNNR (1/9/2016)

---

A little salt lick with that.

There are several million wordpress blogs that use mysql in that figure. I wonder how many of...

Those are IP6 addresses, probably better to disable IP6 if it is not being used.

😎

Here is an excellent article on the subject by Pinal Dave.[/url]

😎

srinivas.akyana (1/9/2016)

---

Hello,

We have ASLB installed with 3 servers for load balancing, there are times we observe that one of the servers are causing in slow in performance. It was more...

Jeff Moden (1/9/2016)

---

Eirikur Eiriksson (1/9/2016)

---

If the logic can be encapsulated in the actual date table and it is used more than once then a physical date table is almost always...

Quick suggestion, unpivot the second table and join the results to the first table.

😎

create table #test_table_2

(EmailAddress varchar(100),Email1 varchar(100),Email2 varchar(100))

INSERT INTO #test_table_1

SELECT 'c@b.com' as EmailAddress, 'Jack' as FirstName, 'Quick' as...

IE or Internet Exploiter as it's been known in the security community for years has given so much problems that it in hard start to fathom that problem. The death...

Hugo Kornelis (1/9/2016)

---

Eirikur Eiriksson (1/9/2016)

---

You are very welcome and thanks for the feedback.

😎

As demonstrated here, often in-line date tables are easier solutions than physical date tables, especially if they are...

You are very welcome and thanks for the feedback.

😎

As demonstrated here, often in-line date tables are easier solutions than physical date tables, especially if they are supporting logic rather than...

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @START_DATE DATE = CONVERT(DATE,'20100101',112);

DECLARE @END_DATE DATE = CONVERT(DATE,'20100901',112);

DECLARE @INTERVAL INT = 14;

;WITH T(N) AS (SELECT N FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS...

You are very welcome.

😎

Luis Cazares (1/8/2016)

---

Ed Wagner (1/8/2016)

---

Brandie Tarvin (1/8/2016)

---

rodjkidd (1/8/2016)

---

Brandie Tarvin (1/8/2016)

---

Here's a funny. The notification algorithm sent me an email from askssc.sqlservercentral.com telling me that I'd been mentioned in someone's query....

joe-584802 (1/6/2016)

---

Thanks Eirikur, that's awesome...!

Thank you for taking the trouble to give me such a comprehensive example, you've given me another road to go down which I'll pursue.

You are all...