Quick thought, you might want to use cross-tab instead of pivot, take a look at this article by Jeff Moden, Cross Tabs and Pivots[/url]

😎

It is SSMS which is playing tricks on you, for an automatic process it should not be in the picture. Create a stored procedure with your select statement and call...

sandie_zarate (8/14/2014)

---

If our processes run every 2 minutes on 3 DBs simultaneously, everything is fine... why are we encountering problems if we run our processes every 2 minutes on more...

It is obviously the keyboard:-P

There are so many possibilities here that it's hard to say where to start. First thing is probably the laptop's power management, make certain it is...

SQLRNNR (8/14/2014)

---

Eirikur Eiriksson (8/14/2014)

---

Luis Cazares (8/14/2014)

---

Grant Fritchey (8/14/2014)

---

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for '77...

Lynn Pettis (8/14/2014)

---

Eirikur Eiriksson (8/14/2014)

---

Luis Cazares (8/14/2014)

---

Grant Fritchey (8/14/2014)

---

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for...

Luis Cazares (8/14/2014)

---

Grant Fritchey (8/14/2014)

---

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for '77 as I have...

Quick thought along with previous suggestion, selecting with a conversion will still return the rows up to the conversion failure, here is an example code

😎

USE tempdb;

GO

CREATE TABLE dbo.TBL_CONVERSION_TEST_SOURCE

(

...

SQLRNNR (8/14/2014)

---

Ed Wagner (8/14/2014)

---

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for '77 as I have a...

tcronin 95651 (8/14/2014)

---

Dealing with 3rd party app that is somehow deleting records. Was going to put a delete trigger on the table so we can at least be notified...

SQLRNNR (8/14/2014)

---

Koen Verbeeck (8/14/2014)

---

I asked Matt...

Quick thought, add an output method element

😎

<xsl:output method="text" indent="no"/>

mqbk (8/13/2014)

---

Recently, I partitioned one of my largest tables into multiple monthly field groups. For the current month, it is attached to my "Active' table. The older records are...

demin99 (8/13/2014)

---

Hi Iam using SQL Server 2012.I have around 120 packages deployed in Integration services catalogs.

I wanted to find the packages that uses a particular tablename. Is there any easy...

N_Muller (8/13/2014)

---

There can be a significant overhead of dropping indexes before the partition is switched out and recreating them after the partition is switched out. Not only the switching...