No need for cursors, or several statements.

WITH CTE AS(

select distinct personid from @t

)

SELECT PersonID,

phone...

What about asking Donald Trump to administer your database? https://twitter.com/trumpdba

If you...

I forgot to include the http in the link address, I've corrected it now.

I had a good experience using AirBnB when I had to look a place before finding an apartment.

My mom rents a bedroom and she recently traveled through Europe using AirBnB.

I...

You could ask directly to Ken Van Hyning, who is the SQL Client Tools Engineering Manager at Microsoft.

P.S. We're everywhere and we see it all. 😀

You have an inconsistent number of parenthesis (difference between opening and closing).

You're using Sales instead of FactSales (or the other...

And what's the problem?

That's what you asked for.

Ray K (5/3/2016)

---

Eirikur Eiriksson (5/3/2016)

---

Alan.B (5/3/2016)

---

Eirikur Eiriksson (5/3/2016)

---

Alan.B (5/3/2016)

---

I think this is a common problem in the data world for sure.

It all comes down to self-awareness and communication. Knowing...

Like this?

SELECT CASE WHEN RIGHT(CONVERT(char(8), GETDATE(), 112), 4) < '0901'

THEN YEAR(GETDATE()) - 1

...

Ray K (5/3/2016)

---

Revenant (5/3/2016)

---

Ed Wagner (5/3/2016)

---

Manic Star (5/3/2016)

---

Ed Wagner (5/3/2016)

---

Eric M Russell (5/3/2016)

---

Ed Wagner (5/3/2016)

---

Thing...

Here are two options, but there are more available.

https://ola.hallengren.com/

http://www.midnightsql.com/minion/minion-reindex/

Lowell beat me to the suggestion.

CREATE PROCEDURE Choose_Weekly_SP

AS

IF( SELECT DATEDIFF(wk, date_created, GETDATE()) % 2

FROM msdb.dbo.sysjobs

WHERE name = 'YourJob'

)...

Is this about the...

But, but...that's my job. :hehe:

Please, read these articles and come back.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

http://www.sqlservercentral.com/articles/Best+Practices/61537/