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!
-
Comparing two fields with different datatypes
Try using something like: where ltrim(rtrim(vnd_nbr)) = replace(ltrim(rtrim( str(srtinvamt,10,2))),'.','')- Allumo
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Store Procedures with output parameters
This could be happening cause @chCustName is getting adicional spaces from the field Name: @chCustName = 'Ruzic~Predrag ' Before setting @intLen, try to remove the spaces from @chCustName using: @chCustName = Trim(@chCustName) Hope this helps.- Allumo
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Generation of auto number
Yes. You can use triggers. But, why don't you wanna use identity?- Allumo
- Post #2
- Forum: Microsoft SQL Server: Programming
-
How to find missing dates in a series
Hi. I've never needed some solution for this situation and I don't know if this is possible with a simgle query. If you don't get it, I suggest two ways: 1. Use a datetime variable within a "while" loop and test each date with a "not exists" row in the table. 2. Create a...- Allumo
- Post #3
- Forum: Microsoft SQL Server: Programming
