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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need to Insert Leading 0 to Current Month
This would also work. Select convert(varchar(2), GetDate(), 101)- jshinall
- Post #3
- Forum: Microsoft SQL Server: Programming
-
parse a CSZ field
I don't know if this helps but here's something I just threw together. There are a few assumptions. Declare @CSZ as varchar(50) Set @CSZ = 'san fransisco, CA 19111' Select replace(substring(@CSZ,1,charindex(',',@CSZ)),',','') Select replace(substring(@CSZ,charindex(',',@CSZ),4),', ','') --...- jshinall
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Easy Question about Stored Proc
You could throw your list into a temp table. CREATE TABLE #tmpTable (CustomerID INT PRIMARY KEY) INSERT INTO #tmpTable VALUES (1) INSERT INTO #tmpTable VALUES (2) INSERT INTO #tmpTable VALUES (3) INSERT INTO #tmpTable VALUES (4) Select * from tblCustomer where CustNumb in (Select CustomerID...- jshinall
- Post #3
- Forum: Microsoft SQL Server: Programming
