The cast is only allowing numbers less than 10000, so increase the cast to 9,4 or 10,4, etc..

autoexcrement (2/7/2011)

---

Craig, do you think this set of SSMS tools would be appropriate? It claims to be able to autogenerate the CRUD wrappers you suggested. Seems like it will be...

you can't change it to an identity column as is. you can rename the table, create a new one with the identity column and then insert the old records...

What are you trying to do and why is this a poll? If you specify why, we can try to help. Foreign keys are in place to insure...

what is the table definition? instead of running the update statement, select (100percentrecon/sumofvissits) *100 from the table to see what you get. If the 2 fields are integers,...

dave,

I think your solution will skew the results since a memberid of A, B, and C will be split out into 3 rows even though the OP has substituted...

Is the file actually present on the E drive. Sometimes I get this when a SAN volume goes offline.

there are a couple of things wrong with your code. The first is when you are checking for the memberid in A,B,C you have an extra comma after C. ...

When you inserted 2000 rows with SSMS, did you use the proc? What is the application doing? Is it opening and closing a transaction each time or are...

the where clause is looking for a column within the table specified in the from clause. I think you're trying to use the files from the master database to...

can you provide a little more information than that? How about table layouts, how much data are you inserting, indexes on tables, how is data being inserted (Bulk Insert,...

Rich,

the problem is with the where clause. You have where name = 'master like ... This won't work as you found out. Try this:

USE [master]

GO

--Drop the Database...

Can you paste the syntax you're using?

Rich, one more thing. I wouldn't make the column not null since any applications writing to it probably don't know of it's existence, so won't insert any data to...

Rich,

can you run the select within the exists statement? I had to add master.. in front of sysaltfiles