Eirikur Eiriksson (5/10/2016)

---

Michael L John (5/10/2016)

---

Lynn Pettis (5/10/2016)

---

Red Letter Day! Silver Spoon posted a helpful response to a question. Of course, it could just be a parrot response....

rk1980factor (5/10/2016)

---

That convert worked, thanks

but i tried to add another case statement:

SELECT [student#]

,[class_position]

,case when [class_position] > 0 then [Assembly_Rank] else [Assembly_Seq] end as [Line_Class]

,case when [class_position] > 0 then CONVERT(VARCHAR(12),...

Michael L John (5/10/2016)

---

Lynn Pettis (5/10/2016)

---

Red Letter Day! Silver Spoon posted a helpful response to a question. Of course, it could just be a parrot response. But...

In general, no. Your tables should have a PK defined. Whether it should be...

Red Letter Day! Silver Spoon posted a helpful response to a question. Of course, it could just be a parrot response. But hey, it still counts!

Snakeyes (5/10/2016)

---

Good Day All

I have recently started tests with SQL 2014 and Security to only allow the TLS1.2 Connections.

As per above link it states that you need to download...

Lowell (5/10/2016)

---

OK so zero seeks on the primary key, and we know it's also the clustered index since it is index_id = 1

so nothing, really ever says WHERE PK =...

Eirikur Eiriksson (5/10/2016)

---

Tac11 (5/10/2016)

---

I have a table with 8 million rows (index size 1.5 GB and Data space 1.3 GB). when I ran index_usage_stats results came with

Index id =...

Eric M Russell (5/10/2016)

---

For this type of row filtering based on TOP(x) ranking, you can use the DENSE_RANK() function like so. You'll need to experiment with the PARTITION BY and...

DPD0011 (5/10/2016)

---

Hello,

The query below is pulling some cases which have multiple benefits during the same month, how would I only pull the cases which the benmon date is the earlier...

What script? Looks to me like you are just trying to increase your post count.

Nassan (5/10/2016)

---

CREATE PROCEDURE spUpdate_PII

@SSN VARCHAR(20) = '999-99-9999',

@DOB Varchar(20) = 'January 1,2016',

@CaseNotePhone VarChar(20) = '111-111-1111',

@BodyReleaseAuthPhone Varchar(20)= '222-222-2222',

@rptByTelNo Varchar(20) = '333-333-3333',

...

Okay, everyone. I leave for Prescott, AZ tomorrow morning between 4:00 and 5:00. My middle daughter graduates on Saturday.

jonathanm 4432 (5/5/2016)

---

Maybe this would be better. Here is the table

select b.cust_code, a.part_no,

COUNT(CASE WHEN b.date_entered >= DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) - 6, 0)

AND b.date_entered...

OP: I'm getting an error.

Me; What is the error?

OP: Not getting an error, the formula is wrong.

Me: But you just said you got an error (included...