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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: CousinBrucie
- Content: Threads
- Order by date
-
Table Update Based on Comparison Results
Hello, I'm taking in the string comparisons I need, but now need to just update a column in another table based on this result. Here's a snippet of what I'm trying to accomplish with a CASE WHEN THEN END but it isn't working: SELECT * FROM TestSubmission t CASE WHEN t.Region <> @region THEN...- CousinBrucie
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
-
String Comparison Between File Name and Record Detail
Hello, I am writing a stored procedure to compare values within a File Name stored in one table to the stored values in another. Here is an example of the filename: TESTCOMPANY_ABCD_23_NEW_SUBMISSION.txt. The filename along with a timestamp is stored in a table named SubmissionManagement...- CousinBrucie
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
