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 TouchToneTommy 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 captainpicart
-
Add semicolon every 7th place
Awesome. Perfect! Thanks gmmastros!- captainpicart
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Add semicolon every 7th place
Hi experts, How to write a stored procedure which will get rid of all semicolons at the beginning and at the end, BUT will separate each number with a semi colon? Input:--- 018752;018752;019912;002541;017181;;;; ;018752;018752;018752;019536;020921;007378;013099...- captainpicart
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Comparing Data between two identical tables
This is Great! Thanks Markros! Can you recommend really good books which teach solid T-SQL programming? Thanks.- captainpicart
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Comparing Data between two identical tables
Hi Techies, I have two identical tables (1) Employee (2) PreviousEmployee. Now, I need to create only one query/storedProcedure which has to do the following: 1. Get only records which exist only in Employee table but they do not exist in PreviousEmployee table. These records should contain a...- captainpicart
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
