For what it's worth - as of 2008 it's 1024 of non-sparse columns. With sparse columns your column limit per...

There are a lot of requirements to meet to be completely up to speed on SQL Server licensing. You really want to start with this guide:

http://download.microsoft.com/download/7/3/C/73CAD4E0-D0B5-4BE5-AB49-D5B886A5AE00/SQL_Server_2012_Licensing_Reference_Guide.pdf

there are some useful...

Miles Neale (9/17/2012)

---

Some wonder why I install SQL Server on my local box and develop against that version first. It is obvious, never develop the initial product in a...

lonhanner (9/16/2012)

---

Jeff The size now is 35MB this is over 10 years of data. I do not know for sure. I just took this job because I don.t have work....

Just a shot in the dark, but - how many have a NULL billingType?

The fact that DefCon...

SQLRNNR (9/6/2012)

---

I think it is great to bring this to the attention of the community. This behavior cannot be tolerated.

Better than talking about it, I would love to see...

Lynn Pettis (9/6/2012)

---

John Hanrahan (9/6/2012)

---

I laugh and laugh. Agile often means (to the managers in charge) get it done and skip whatever you think you can. That may...

you're very likely having an issue because your XML structure isn't valid. For one thing you're closing tags that have already been closed (which SQLXML will complain about).

That said...

Jeff Moden (8/30/2012)

---

Brandie Tarvin (8/29/2012)

---

dwain.c (8/29/2012)

---

Jo Pattyn (8/29/2012)

---

How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without a...

Nadrek (8/29/2012)

---

Evil Kraig F (8/28/2012)

---

In the end, any argument I hear for 'centralize everything' sounds to me like 'I don't trust anyone else to do their job well enough'. ...

A few words of caution: you should REALLY avoid using reserved words as column names. 3 out of 4 of your columns are reserved, which tends to really confuse...

Sean Lange (8/27/2012)

---

Luis Cazares (8/27/2012)

---

I guess it was wrong for me to read the 2012 version as it is less explicit.

But I still believe the OP won't have an option...

Here's a static version of your "report" (this would be the data behind the report actually)

select conid,location,[cert1date],[cert2date],[cert3date],[cert4date]

from

(select #table1.conid, location, certdesc+'date' certname,certdate

from #table1

cross join #table3

left outer join #table2 on #table1.conid=#table2.conid...

djackson 22568 (8/27/2012)

---

Hmm, you do seem optimistic, and I applaud that attitude.

I have to disagree with outsourcing leading to a net increase in jobs. Caterpillar and other manufacturers shed...