I can, for some unknown reason, only ever remember 2 exact phrases from the books I've read. One is from Erich Fromm:

The quest for certainty blocks the quest for...

And on a related note, I used to work with someone named Vince Caputo. Ever been to Tacoma?

How about:

Select distinct g.loginid, g.fname, g.lname

From gradstudents g

where g.loginid NOT IN (select t.loginid from ta t)

Based on the data you provided, I think you're excluding all the class numbers,...

I'd second Adam's comment. If you have to load all the data to do the compares, you might as well just load the data as you do now.

I once...

Man, I have got to learn to type faster....

Your variable starts as NULL and I think that 'anything' concatenated with NULL yields NULL, so giving the variable an initial value should fix that. I think there's also...

When you restore the master database, you're essentially re-setting the server's brain to the state it was in at the time of the backup. So your server is, of...

It's a simple answer. There are no good programmers, just like there are no good boys who want to date my daughter:w00t: They're all just closet hackers who...

The most common cause for this type of failure is that the SQL Server service account, which runs the xp when it runs from a proc, doesn't have the proper...

If I'm remembering correctly, the tool we use grabs the proc and brings it up into a window in clear text. From there you can save it to another...

There are third party tools you can get that will decrypt stored procs (at least up through SQL Server 2000). If you Google or Yahoo 'decrypt stored procedure' you'll...

I'm not an Access expert, but I concur with the previous poster that all you can do is restore from the last known good backup. It's been my experience...

Let me make sure I understand the problem. You are adding a row with a non-null siteid and you get the 'siteid cannot be NULL' message.

Can you create an...

Could you give me an example of what you're calling a "flat file dbms system"? If something is truely a flat file, you have to read through it sequentially...

You cound try something like:

create table #junk (

float_to_add float NOT NULL)

go

insert #junk(float_to_add) values (1.1104)

insert #junk(float_to_add) values (1.222)

insert #junk(float_to_add) values (1.32)

insert #junk(float_to_add) values (1.41)

insert #junk(float_to_add) values (1.52)

insert #junk(float_to_add) values (1.66)

insert #junk(float_to_add)...