Search results for query: *

I was trying to do something similar, the query I was trying to run being: INSERT INTO xref_Article_Referee ( Article_ID, Referee_ID, [Date due from referee], [Date back from referee], [Date Rev to Referee], [Date Rev from Referee] ) SELECT Manuscripts.Article_ID, Manuscripts.Referee_ID...

Uh, actually wait a minute, I completely misread your question, so ignore my last post. What you need to do is a join on the number field. i.e. if your results are coming from two tables (ResultsA and ResultsB) you would use something along the lines of the following: SELECT A.Number...

ShiggyShag, I'm afraid I'm not going to be a lot of help: all I can offer is that when I was browsing through SQL Server Books Online I came across this functionality. I'm afraid I can't give you anymore than that - I can't remember what my search string was, nor the title of the article. All I...

Thanks guys. The COALESCE funtion worked a treat; I joined up all the tables, and then just use the record that isn't null: SELECT wdg_description, OriginationFactory = COALESCE(new_Factory, old_factory) FROM Widgets LEFT OUTER JOIN oldDB.dbo.WidgetFactories old on wdg_factory_id = old.Fact_id...

My problem is a more advanced use of the CASE function. Basically, depending upon one of the values in my resultset, I want to get a value from one of two different databases. An illustration of the problem would be: Suppose I have the query: SELECT drd_id, drd_description FROM Widgets Now...

Thanks Cassie. However, I don't think this solves my problem. From reading your solution I think this gives a modal form experience for the user in that they can't access any of the other forms until the Unlock method of the forms is called. However, my problem is that if I am in a modal form...

I've got a situation where I want to open the same form both as an MDI child, and from a Modal Form. This is a bit of a problem as a MDI Child Form can't be Modal. The work around I have at the moment is to have two forms, one MDI Child and one not, and have their code in a module. As a solution...