Search results for query: *

I have a need to write some common queries that will work across multiple databases (all on the same server). The databases all have the same schema but are 3rd party so I am not allowed to create Stored Procedures or User functions in these databases. For this reason I have a separate database...

I have two tables: ITEM ItemID INT (PK) AccountID INT . . ITEMDESCRIPTION ItemID INT ) (PK) Sequence INT ) ItemDesc NVARCHAR(255) Thus there may be multiple rows in ITEMDESCRIPTION for each ITEM record. I need to find all items for a specific account that have two...

I have a situation where I need to find a valid price for an object. I have three tables: Price with columns PriceID int ObjectID int AccountID int PriceDetail with columns PriceDetailID int PriceID int ChargeRate float Object with...

I have two databases with identical schemas. Each is used by the same application to run a document archiving system for two different companies. Both companies have been acquired by a third company that wishes to merge the databases into a single database and operate as a single company. In...

I recently came across a problem when uploading files from an INPUT tag type=file. When I tried to process the uploaded file either using the SaveAs method or by accessing the stream I got an error "Cannot access a closed file" at random. It would always occur for some files but the same file...

I have a web project that I started to develop in VWD 2005. I now have a copy of VS.NET 2005 Professional and I want to add my solution to source control. The web project is on my own development PC using the local IIS. When I try to do this VS tells me In VS.NET 2003 there was no such...

I am developing a web application that allows remote users to store binary files on a remote server over the general internet. I have looked at a number of Upload controls but they all suffer from one problem. The original file's Creation and Last Modified timestamps are not preserved or passed...