DECLARE @BDay varchar(15), @Code varchar(10), @CusTomerNo varchar(10) DECLARE @SMS varchar(500) ,@OutBoundSMS varchar(500) ,@WordCount int ,@IsValidSMS bit --SET @SMS = 'FW 01928 12311995' -- valid --SET @SMS = 'FW 101928 12311995' -- valid --SET @SMS = 'QUERY 101928 12311995' -- Invalid --SET @SMS = 'FW 1x1928 12311995' -- Invalid --SET @SMS = 'FW 1x1928 12.31.1995' -- Invalid --SET @SMS = 'FW 1x1928 12.31.1995' -- Invalid SET @SMS = 'FW' -- Invalid --SET @SMS = 'FW 01928' -- Invalid --SET @SMS = 'FW A1928' -- Invalid SET @IsValidSMS = 0 SELECT IDENTITY(int, 1, 1) AS Id, splitdata INTO #temp1 FROM dbo.fnSplitString(@SMS,' ') SELECT @WordCount = COUNT(*) FROM #temp1 IF @WordCount = 3 BEGIN --SELECT 'Valid 3 words format...' SELECT TOP 1 @Code = splitdata FROM #temp1 WHERE Id = 1 SELECT TOP 1 @CusTomerNo = splitdata FROM #temp1 WHERE Id = 2 SELECT TOP 1 @BDay = splitdata FROM #temp1 W...
List of all tools and techniques used on my day to day software development.