Jeff Moden (7/12/2016)

---

Brandie Tarvin (7/12/2016)

---

GAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHHHHHH!

Last week before upgrade and the stupid IP addresses for my AGs and one of my sql instances aren't responding to pings.

Who has the porkchop launcher?...

Binoogle...

mcfarlandparkway (7/11/2016)

---

I have a report (.rdl file) - and a table called person and this table is using only in one stored procedure and that procedure is using in rdl...

Sangeeth878787 (7/7/2016)

---

Hi,

I am trying to create view dynamically using sys.tables and sys.columns with filtering required tables.

For that I am using multiple variables.

Eg

Declare @varaiable nvarchar(max)

Declare @varaiable2 nvarchar(max)

Declare @varaiable2 nvarchar(max)

Declare @varaiable3...

Stephanie J Brown (7/7/2016)

---

Can I call "poorly worded question"?

A truly strong password would need all four.

Microsoft's Password Policy says you need three of four.

The question asked what...

bcrockett (7/7/2016)

---

Sean Lange (7/7/2016)

---

bcrockett (7/7/2016)

---

I have to pull data, from a phone system, but I have to pull the data on a specific group of phone extensions -

Where do you...

Sangeeth878787 (7/7/2016)

---

HI,

The following code I need assign the list of columns into new variable, but I am struggling to populate the result into variable, could any give their valuable...

bcrockett (7/7/2016)

---

I have to pull data, from a phone system, but I have to pull the data on a specific group of phone extensions -

SELECT

...

Maybe instead of building up a big string of values maybe a table valued parameter would work? There is not a lot of detail in your question so it is...

webrunner (7/7/2016)

---

Like many others who have posted comments, I also first thought all 4 would be required for a strong SQL password. And it does stand to reason that empirically...

rjjh78 (7/7/2016)

---

Yes, I do understand what is happening, I was not aware you could do this. I know there is also, with CTE. What is the "with" function...

I would have assumed all 4 but as with most QOTD there must be something to warrant asking the question in the first place. It seems that once again MS...

I am glad it worked for you but more important...do you understand it?

wdmm (7/6/2016)

---

i need to create tables from a query result based on the returned query value; i tried the code below

declare @tableName varchar(1000)

declare @rowCount int = 0

set @rowCount = (select...

rjjh78 (7/6/2016)

---

Hello,

Is it possible to use a cursor to INSERT multiple columns and rows using GROUP BY?

I am trying to create a temp table that will calculate data from another...