put a unique constraint on the column and just do a try catch around your insert if you are doing them one at a time.

Otherwise, perhaps insert them all to...

Any good sites with overviews of Performancepoint with screenshots or demos? I'm looking for the gee whiz stuff not the textual details.

Ok, I figured out how to do this...next question

Sorry, title should read census tracts.

I need the actual maps, not the data in the maps, the metadata describing the maps.

Very ingenious, but honestly, the proliferation of procs isn't a good thing.

This is better handled as others have said in client code where one class can dynamically generate...

Yeah thanks, I had just found it.

GRANT VIEW ANY DEFINITION TO USERNAME

To paraphrase Lawrence from Office Space, "I believe you'd get your axx kicked for doin' something like that, man"

Select * is very useful when you need to do quick...

This is so frustrating.

DTS was FINE. Why did they have to mess this up?

We are not running Windows firewall, SSIS is installed on the Server. We cannot connect...

jackie.williams (3/11/2009)

---

jcraddock (3/11/2009)

---

Um, how are you going to declare the variables and such inside one statement from an ASP.Net page/class/etc? This looks like you have to use a proc,...

Um, how are you going to declare the variables and such inside one statement from an ASP.Net page/class/etc? This looks like you have to use a proc, and procs...

These are all well and good, but I rarely need such results in a T-SQL window. Where I need them is in an application where I want to paginate...

dphillips (12/17/2008)

---

I learned the hard way too. After losing many a potential post to timeout, and getting burned and not re-doing all the post, I started doing a quick...

jcrawf02 (12/11/2008)

---

Jeff Moden (12/3/2008)

---

jcraddock (12/3/2008)

---

I've had better luck writing code that writes my SQL. I wrote a set of code that you point at any table, it accepts any...

I've had better luck writing code that writes my SQL. I wrote a set of code that you point at any table, it accepts any column within the table...

I have the same problem that has just cropped up on a table.

My column is simply taking Lastname + ', ' + firstname. No idea what to do.

FWIW..I did...