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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Writing Counter Record in Temp Table
Hi I have temp table as follows:- record_id name 1 A1 2 A2 3 A3 4 A4 How do I insert record in record_id column. record_id is a part of unique key but not a identity field. Please help- srsr
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
date manipulation question
hi aigles i am not sure what you mean by the above example? if i have worked out that teh month is 02 and i want to add 1 to it, this cahnges the month to 3 without the leading zero. i want to keep the leading zeros? i can do this using printf?? thanks srsr- srsr
- Post #3
- Forum: UNIX Scripting
-
date manipulation question
i am manipulating the date in a unix script as follows: if [ $Day != 1 ] then Month=$(($Month + 1)) && Day=1 if [ $Month = 12 ] then Month=1 && Year=$(($Year + 1)) fi fi however i want to prefix the result to a filename, however it does not include zeros eg 20020301 (1st march 2002) would...- srsr
- Thread
- Replies: 3
- Forum: UNIX Scripting
