yes, you could use a loop from one to twenty or something, so it only iterates thru ranges of id's; you were right, the idea is to not let it...

you'd simply change your update statement just a little bit, so it only updates where the destination column is null;

something like this:

SET ROWCOUNT 500000 --only fiddle with half a million...

a default, any default constraint in fact, uses the value ONLY if the column is not referenced in the INSERT statement. the empty string you included gets assumed to be...

Seth you could give LINQPad a try, since it is free;

I like it because i can carry it in a thumb drive; added it to my PortableApps collection;

it's got a...

the default trace is helpful for this exact sort of thing, as it captures all the DDL changes

there's even a built in report for it.

go to Object explorer in SSMS,...

yeah you'd want to add something like WHERE dbo.CHARINDEX2('-', COLUMNNAME, 2) > 0

to your query, so you only select things that match the style of two dashes to chop...

seems like this function would help you here from the scripts contribution section:

http://www.sqlservercentral.com/scripts/30497/

it lets you find the N-th occurrance of the dash for example...

so if you need everything LEFT of...

here's a quickie SQL to find tables with "gaps" in the column_id sequence:

select distinct object_name(object_id) As TableWithGaps

from (

select * ,

...

if you add a drop columns from a table, the column_id is dropped with it; then when you add additional columns, the next column_id is used.

so if you drop column...

here you go:

GeoProject.zip

this was the product of an afternoon of too much time on my hands...i was surfing Wiki looking at planets when they renamed Pluto to a planetoid, and...

i'd say your table's attempts column was not initialized to zero, but instead has nulls:

select @NewAttempts = hua.attempts + 1 from hub_user_auth as hua

where hua.id = @UserID

would probably be better...

ok i found an old project i was screwing around with, let me know if you want it;

it's a suite of tables, all inter related with FK's and all that,...

here's one i use regularly:

ZipCityStateCounty.txt

it's a typical thing you find for free, 42K records more or less, in a TAB delimited format i think.

I can tweak it into comma delimited...

also, here is an example of converting that unusualdate format into a datetime field:

--results:

BeginOfMonth DaMonth ...

can you post some sample data you would be importing as well as the CREATE TABLE of the destination table?

you said the first two values of 10141045 was the day,...