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 Chriss Miller 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 lflecher
-
Problem with a local variable
It was what I thought at the beginning but in fact it doesn't come from that, because when I write: ... CASE WHEN @Num % 2 = 0 THEN( -- even number of street @Num )ELSE( ... I get the folowing results (so @Num has been assigned): PostCode Street Number CdeTour...- lflecher
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Problem with a local variable
Hello everybody, Here I have two tables. Let's call them A and B. A contains the folowing data: (address of persons) PostCode Street Number CdeTour -------- ------ ------ ------- 31000 Well. 0025 NULL 31000 Well. 0050 NULL 31000 Wash. 0010 NULL B contains the...- lflecher
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
