Whatever connector your website is using to connect to the database is setting some defaults that are causing your temp table columns to default to NOT NULL.

You can reproduce...

The row_number() method is by far the quickest and cleanest method. If you've never used row_number() before, do yourself a favor and learn it.

one modification to JP's code.. "......

This may not be exactly what you're looking for, but you could create a wrapper stored procedure that the job calls. this sproc would do whatever calculation or querying necessary...

mpalecek (3/27/2009)

---

The thing that I think is terrible is the coffee pot. We used to have someone in the office who would take the last full cup of coffee and...

There was a guy that sat in the cube next to me. Nice guy, but everytime he would talk on the phone, and only while he was talking, he would...

There are 2 ways you can do this.

If you want all the constraints in place in the new location before the data is imported, I would suggest defining the...

I agree with Jeff.

There doesn't appear to be a relation between memberEventID and BillingId. If you want to display the results (memberId, billingID, memberEventID), and return only 6 rows,...

Hi, your question is not entirely clear. Are you simply trying to update a table? Are you trying to change the primary key of the table?

Please elaborate.

They way I do it is that I have all my sprocs scripted out. At the bottom of the script, after a GO statement, i have the permissions that are...

Please post the textual version of the execution plan.

before you run your query, run this.

set statistics profile on

GO

you should see a textual plan at the bottom of...

We have an in house data utility that allows us to script out every object in our database. We go all the way down to the smallest detail; storing indexes,...

I agree with Roy. This sounds like a classic example of a scenario that would require merge replication.

As long as your requirement is that updates need to take place...

The only time you may run into problems...

A number of tables that have computed columns return the message "Metadata stored on disk for computed column 'xxx' in table 'dbo.zzz' did not match the column definition. In order...

Roy, i wouldn't say your idea is outrageous. There is always a place for custom solutions. However, I still feel that even with the connection issues that Aldo's client is...