SELECT

Segmented.ID,

Segmented.UserID,

Segmented.Location,

Segmented.LocationDate

FROM

(

SELECT

...

I have 2012 running...

You can also skip the rule using setup from the command line, like:

Setup /ACTION=install /SkipRules=VSShellInstalledRule

...but that's not a documented or supported option, so for peace of mind I would try...

tiger6425 (1/14/2012)

---

Ok, I think I figured this out originally looked at the image button next to the page alignment buttons. Now I think I figured this out. The image...

L' Eomot Inversé (1/16/2012)

---

SQL Kiwi (1/16/2012)

---

I installed a 2000 VM recently just to test something specific. I had almost no...

Naturally. An index on (col1, col2) cannot support a seek on...

aitchkcandoo (1/16/2012)

---

SQL Kiwi, I added my create and insert script so that someone else who comes to forum may be able to duplicate solution that I posted, if they were...

If you mean the idea of presenting multiple columns in one row,...

The view designer doesn't get much love from...

SQLRNNR (1/16/2012)

---

I think supporting 6.5 is easier sometimes than 2000. I have to sit and think for a bit to recall how things are done in 2000 - unless...

I installed a 2000 VM recently just to test something specific. I had almost no clue where to start any...

At a guess, I would say you are using the graphical designer to create a view in SQL Server Management Studio. It's a guess, because I've never really used...

SQLRNNR (1/16/2012)

---

At least you have 40% on 2005. I have one that is still on 6.5 and refuses to upgrade. I have others on 2000 that don't want...

dao-434438 (1/15/2012) Via Private Message

---

I need to add 20 additional partitions to an existing table , do I have execute those commands 20 times and then Alter the partitioned table...

dao-434438 (1/15/2012) Via Private Message

---

Thanks for your reply,

I need to add 20 additional partitions to an existing table , do I have execute those commands 20 times

and then Alter...