It sounds like you might be able to get away with just looking at the Year as an integer using:

CAST([Year] AS int)

You probably want this one though:

CAST([Year] AS datetime)

Example:

If a...

I'm pretty sure you can't get that for the column level. The best you can do is at the table level. Pretty much everything you need (and by...

What exactly are you trying to accomplish? Just running an update on the xml column or creating a trigger so the xml column is updated everytime the age changes?...

Try using the sys.sysobjects table. The object_id will be referenced in the systable and syscolumn if you need to look up other information. I believe the crdate is...

Good point Jeff. I almost put the word "Scope" in there for the dropping of temp tables, but I was afraid I would overcomplicate the explaination. Good catch!

Cheers,

Brian

See if this makes a difference. There are actually permissions inside of Access. In Access, go under Tools->Security->User and Group Permissions... see if modifying the "Read Data", Update...

All good questions! I'm going to assume you're using SQL Server 2005 or 2008.

1) tempdb..sysobjects Normally you will see this written as tempdb.sys.sysobjects. This syntax is using...

If you're using Windows Authentication then the ODBC driver should be ok. I would check out the article on permissions, but it sounds like you may have this setup...

Very true. To see what rows are updated you refer to the DELETED table for the old values and INSERTED for the new values.

Cheers,

Brian

What kind of permission issues/errors are you getting? All the ODBC driver is doing is authenticating as the user setup in the connection string and SQL Server authenticates against...

Hmmm... there are very few scenarios where I've seen cursors faster than CTE or non-RBAR (row by agonizing row) methods. Just curious how many rows you're running through?

Cheers,

Brian

This is correct. You CANNOT create an alias in one column and use it in the next. Limey has the right idea. you will need to replace...

It sounds like the other application has a lookup that looks at the "Desktop__bSoftware" value and grabs a user friendly version. If you run the query that your report...

I'm not sure this will grab everything, but give it a try. It basically looks for views that have an operation (*,/,-,+,%) followed by a FROM somewhere after it...

I setup a test scenario similiar to what you had created. I first tried finding any objects intellisense picked up that might help (through 2008) with no luck. ...