Have you checked the SQL and Windows error logs?

Nice to get easy ones.

One last thing, don't order by position (ORDER BY 1), order by named column (ORDER BY ico.providerspecialty).

christine 23290 (9/9/2015)

---

I am executing the following query

select distinct specialty

FROM [dbo].[Import_ClaimData]

where specialty like '%_%'

order by 1 desc

Can someone please tell me why I am getting results to do not...

sharonsql2013 (9/9/2015)

---

I am trying to get the 3 rows in the below in one line. with all 3 names separated by ","

create table #Product

(

Application Varchar(50),

...

ScottPletcher (9/9/2015)

---

Why do you refuse to create a clustered index??

Since you have Enterprise Edition, you can create the index online so it will barely, if at all, affect other users.

Drop...

SQLAddict01 (9/8/2015)

---

I have so many NOT IN conditions like ::

Select * from backups

where

databasename not in (select databasename from backups where servername...

roryp 96873 (9/8/2015)

---

Lynn Pettis (9/8/2015)

---

roryp 96873 (9/8/2015)

---

Lynn Pettis (9/8/2015)

---

Knew I wouldn't be there, I was driving from Prescott, AZ to Colorado Spring, CO. Lovely 11+ hour drive. Topped...

If you are using the Enterprise Edition of SQL Server, and are maintaining a 3 year history of data, 1 month rolls in and one month rolls out; then partitioning...

roryp 96873 (9/8/2015)

---

Lynn Pettis (9/8/2015)

---

Knew I wouldn't be there, I was driving from Prescott, AZ to Colorado Spring, CO. Lovely 11+ hour drive. Topped of the tank before...

Jeff Moden (9/8/2015)

---

jhbelalc (9/8/2015)

---

the boundaries are 'properly filled' only if the client say so.

The person in charge of deliver the software to the client can say it's finished but finally...

Knew I wouldn't be there, I was driving from Prescott, AZ to Colorado Spring, CO. Lovely 11+ hour drive. Topped of the tank before leaving Prescott, filled up...

ScottPletcher (9/3/2015)

---

Lynn Pettis (9/3/2015)

---

ScottPletcher (9/3/2015)

---

Very busy at work, just now was able to complete the code. I'll go ahead and post it as an alternative. I prefer a...

ScottPletcher (9/3/2015)

---

Very busy at work, just now was able to complete the code. I'll go ahead and post it as an alternative. I prefer a "template" approach, so...

So am I. I will be driving down...