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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by zektheiguana
-
Insert or Update SQL Table when Textbox is Empty
I have a web form which has around 30 or so fields, most of which are optional from an SQL standpoint (i.e. table column allows Null). I'm using a dataset and table adapter to generate my Insert and Update. Most of the fields are strings, but there are also Dates and Integers. What I'm...- zektheiguana
- Thread
- Replies: 1
- Forum: Microsoft: ASP.NET
-
SQL Computed Column - Compare Dates and Return String
Yes, you're correct I had my < and > swapped. That worked, I knew it had to be easy but my mind wasn't wrapping around it. Thanks for your help!- zektheiguana
- Post #3
- Forum: Microsoft SQL Server: Programming
-
SQL Computed Column - Compare Dates and Return String
I'm a complete SQL Noob so if this is ridiculously easy, I'll apologize now! I'm trying to set a column "Status" in a record based on column DueDate compared to the current date as well as the contents of another column called DateClosed. So in non-SQL syntax, what I'm looking at is IF...- zektheiguana
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
