another similar source of data is here: nationalfile.zip

http://geonames.usgs.gov/domestic/download_data.htm

1.8 + million records in the text file, it's featurename/city/state/county along with latitude/longitude of different places/features in the US.

because it is a lot bigger file,...

here's one suggestion:

http://geonames.usgs.gov/fips55.html

that has some files that has every geographic place name in the US.(158K rows)

you can also find similar data for free by searching for "zipcode database (that...

the procedure you posted, procedure GE_Claim_Record_Counts, does not do any selects, therefor the data cannot be sorted.

do you mean when you do SELECT * FROM ClaimCounts, with NO ORDER BY...

because you are not really sorting the results, but placing the results in a specific order, you have to do something like this:

SELECT * FROM ClaimCounts

ORDER BY CASE

WHEN...

insert into TableA (Account,OutstandingLedger

select Account,OutstandingLedger=$0.0 from TableB

don't do an assign operation in the select;

simply SELECT Account,0.00 from TableB

you don't fiddle with image/binary fields at the SQL server level usually; you do it an an application level, like with VB, VB.NET, Delphi, whatever.

Here's the code as an example...

AUTH is the command to send a username and password to the mail server in order to use the SMTP service; it's required, because otherwise the server is wide open...

if a backup of a database was created on SERVER A, and Restored on SERVER B, you would find that behavior...all users in the db are "orphaned";

i'd guess that if...

the ports are actually saved in the registry, and not in the database; that's because a service advertises the server instance where the databases reside, so the OS needs the...

since he posted to this forum, I kind of assumed he was talking about SQL 2000; I've got an instance of 2005 as well, but I haven't used it enought...

I'd venture a guess that one of the fields in the insert statement is receiving data that is longer than the field; for example if QuikJournal was defined as 200...

ISQLW accepts command line parameters. start>>Run isqlw /?  will give you the list; then simply create a shortcut like isqlw.exe -s[localhost] -dmaster -Usa -Ppassword

instead of comma delimited, can you use INSERT INTO TABLEXXX instead?

if you can,Narayana Vyas Kondreddi has an excellent procedure to do that that he has shared: http://vyaskn.tripod.com/code.htm#inserts

yes; my original post about sp_MSdependencies is the solution;

create table #Hierarchy (

objectType    int,

objectName    varchar(50),

objectOwner   varchar(50),

CreationOrder int,

IsSchemaBound int)

insert into #Hierarchy (objectType,objectName,objectOwner,CreationOrder)

EXEC sp_msdependencies @intrans = 1

select * from #Hierarchy

update #Hierarchy set...

might be a better way, i did it this way because of the decimal point:

declare  @SomeValue        money

Set @SomeValue=740002.64

select right( '0000000000000' +  CONVERT(varchar,convert(int,(@SomeValue * 100))),13) AS FinalAnswer

select right(REPLICATE('0', 13) +  CONVERT(varchar,convert(int,(@SomeValue...