Viewing 15 posts - 1 through 15 (of 36 total)
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...
May 6, 2011 at 11:28 am
Any good sites with overviews of Performancepoint with screenshots or demos? I'm looking for the gee whiz stuff not the textual details.
December 3, 2010 at 3:18 pm
Ok, I figured out how to do this...next question
October 5, 2010 at 3:54 pm
Sorry, title should read census tracts.
I need the actual maps, not the data in the maps, the metadata describing the maps.
October 5, 2010 at 2:10 pm
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...
July 9, 2010 at 7:27 am
Yeah thanks, I had just found it.
GRANT VIEW ANY DEFINITION TO USERNAME
November 16, 2009 at 2:55 pm
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...
November 5, 2009 at 8:16 am
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...
August 6, 2009 at 8:15 am
March 12, 2009 at 8:44 am
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...
March 11, 2009 at 9:23 pm
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...
March 11, 2009 at 2:27 pm
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...
December 17, 2008 at 1:52 pm
Jeff Moden (12/3/2008)
December 17, 2008 at 11:38 am
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...
December 3, 2008 at 10:49 am
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.
May 5, 2008 at 12:21 pm