It's partially my fault for not being more specific so I must share in the responsibility of the tables. I work remotely so I can't tell what's going on...

I don't know quite what the cross-out stuff was about but it did give me an idea as to what happened. Next time I will be more specific when...

here's a sample - I changed the table name to protect the innocent. This code worked fine - fields are there and scripting the table by right/clicking and selecting...

When I do a script table and choose Create. My test db comes out fine, the production has the alters in it. I'm only asking because I need...

chandan_jha18 (7/29/2011)

---

You need to ask your DBA to provide you SQLagent user and SQLAgentReader role in MSDB database. then you will be able to see the agent in the management...

Steve,

For the (a.EntityID > EntityID) OR (a.EntityID = EntityID) ) AND (a.EntityID >= EntityID) part, this is what I did.

When I took everything from OR on out, I got...

Today I tried a few more things. I took the update query and turned it into a stored procedure which, I figured would run on the server, not within...

As far as I can determine, everything is int, int, int. However, I've narrowed it down to the query I set up to update the entitynum. It is...

I knew if I had an extra pair of eyes looking at this besides my cat, who doesn't care, it would make more sense to me. I'll look at...

Thanks! I went Doh! and hit my forehead when I saw your answer. Works great!:w00t:

Just one more thing - I was trying to get the select statement to turn into an insert statement and by adding "Distinct" (and the bug mysteriously disappearing from the...

Thanks! It sort of worked except for the fact that the real web address for the .xsd is down with the flu bug. Or something like that. Gives...

Gee, it would be nice if we could do this at my job, but I fear upper management would come down on us for using up precious bandwidth. Too...

When I get a chance to go on vacation and it doesn't involve entertaining the kid, fixing stuff around the house and/or (urgh!) getting a new pet, we head out...

Although we have lots of vacation time, we're only allowed to take it in 1 week increments and then only one person can take off at a time. When...