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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date
Pls help me with the syntax to convert to mmyy<br>eg 1299<br>to 12/99<br>thanks<br>- 4040er
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Help!!
using this syntax how can I modify it to also give me middle initials.<br>Elsie H Reed<br><br>select firstname = substring(mycolumn , 1, charindex(' ',yourcolumn) -1 ), <br>lastname = ltrim(substring(mycolumn,charindex(' ',mycolumn) + 1, len(mycolumn)- len(substring(mycolumn, 1, charindex('...- 4040er
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Help!!!!
can someone pls help me with this syntax.<br><br>BEGIN TRANSACTION tran_Individual_DuesCategory<br><br>UPDATE Individual<br> SET Individual.DuesCategoryID= DuesCategory.DuesCategoryID...- 4040er
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Code Help!!!!
Sorry about the long code, it's is given me error in line 245 incorrect syntax near 'null<br><br>it was working until i added this part<br>select @DuesCategoryID=DuesCategoryID from DuesCategory where DuesCategoryName=@catcde<br>WHILE (@@FETCH_STATUS <>-1)<br>BEGIN<br>select...- 4040er
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
-
Help MTS Questions
We are planning a 3-tier application using VB 6.0, and IIS 4.0. and we<br>would like to use MTS, I will like to how MTS works with VB also what are<br>the advantages and disavantages of placing MTS behind or outside the<br>firewall.<br><br>Thanks,<br>Elsie<br>- 4040er
- Thread
- Replies: 2
- Forum: Microsoft: Microsoft Transaction Server (MTS)
