Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Conditionnal UPDATE
Cheers ! Following your advice, I finally got it to work like that, the code having been just a bit modified to fit in this post : if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DATE_CLOTURE_LOTS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table DATE_CLOSE...- LEGEAS
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Conditionnal UPDATE
Hi all ! I'm desperately in need for some help on that one... I have two tables, say A and B. B is linked to A with a foreign key NUM_A. B contains a series of business actions on A, each one having a close date. A contains an open date and a close date. Now comes the interesting bit : I would...- LEGEAS
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
SELECT Size
Hi all ! First post to these forums, makes me emotional... I am correcting some bugs in a Domino 5 application. This application is used only through IE5 web browsers. I'd like to define in a mask a SELECT list (single selection), which would be of size : the number of items in the list, so...
