Database

;WITH SukTable ([Suk]) AS
(
	SELECT 'abc 111 bbb 1212'
	UNION SELECT 'pqr 222 ccc 2323'
)
SELECT
	SUBSTRING(SUK,1,3) AS Field1,
	SUBSTRING(SUK,5,3) AS Field2,
	SUBSTRING(SUK,9,3) AS Field3,
	SUBSTRING(SUK,12,5) AS Field4
FROM SukTable

;WITH SukTable ([Suk]) AS
(
	SELECT 'abc 111 bbb 1212'
	UNION SELECT 'pqr 222 ccc 2323'
)
SELECT
	LEFT(SUK,CHARINDEX(' ',Suk,0)-1) AS Field1,
	SUBSTRING(SUK,CHARINDEX(' ',Suk,0),CHARINDEX(' ',Suk,CHARINDEX(' ',Suk,0))-CHARINDEX(' ',Suk,0)) AS Field2
FROM SukTable

GO
/****** Object:  UserDefinedFunction [dbo].[SplitGETPosFunc]    Script Date: 10/20/2010 15:22:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[SplitGETPosFunc](@String varchar(8000), 
@Delimiter char(1),
@POSITION INT)
RETURNS varchar(1000)
WITH EXECUTE AS CALLER
AS
begin     
	declare @idx int;     
    DECLARE @CHARIDX INT;
    DECLARE @INPUTSTR VARCHAR(8000);
    declare @OUTPUT varchar(1000);
    SET @INPUTSTR=@String;
    SET @CHARIDX =0;
    SET @idx=0;
    if (substring(@String,1,1)='S')
		begin
			while @idx < @POSITION   
				begin     
				SET @CHARIDX= CHARINDEX(@Delimiter, @INPUTSTR);
				SET @OUTPUT=SUBSTRING(@INPUTSTR, 1, @CHARIDX - 1)
				SET @INPUTSTR = SUBSTRING(@INPUTSTR,@CHARIDX +1,LEN(@INPUTSTR));
				SET @idx=@idx+1;
			end 
		end
	else
	   set @OUTPUT=@String;
return   @OUTPUT;  
end

WITH 
	ParentChildRels
	(ParentID, ChildID, KeyField, [Path], HierarchyLevel, Doc) 
AS 
(
	SELECT     
		ParentID, ChildID, KeyField, CAST('root/' + Folder AS nvarchar(255)) AS Path, 1 AS HierarchyLevel, Doc 
	FROM         
	(
		SELECT     
			dbo.Folder.ParentID, dbo.Folder.ID AS ChildID, dbo.Folder.Folder, dbo.[Document].DocumentID AS KeyField, dbo.[Document].[Document] AS Doc
		FROM          
			dbo.[Document] 
		RIGHT OUTER JOIN
			dbo.Folder 
		ON 
			dbo.[Document].FolderID = dbo.Folder.ID
	) AS x
	WHERE     
		(ParentID = 0)
	
	UNION ALL


	SELECT     
		r.ParentID, r.ChildID, r.KeyField, CAST(RTRIM(pr.Path) + '/' + r.Folder AS nvarchar(255)) AS Path, pr.HierarchyLevel + 1 AS HierarchyLevel, r.Doc
	FROM         
	(
		SELECT     
			Folder_1.ParentID, Folder_1.ID AS ChildID, Folder_1.Folder, Document_1.DocumentID AS KeyField, Document_1.[Document] AS Doc
		FROM          
			dbo.[Document] AS Document_1 
		INNER JOIN
			dbo.[Folder] AS Folder_1 
		ON
			Document_1.FolderID = Folder_1.ID
	) AS r 
	INNER JOIN
		ParentChildRels AS pr 
	ON r.ParentID = pr.ChildID
)
SELECT DISTINCT TOP (100) PERCENT 
	ParentID, ChildID, KeyField, RTRIM(RTRIM([Path]) + '/' + Doc)
FROM         
	ParentChildRels AS ParentChildRels_1
WHERE Keyfield is not null
ORDER BY 
	RTRIM(RTRIM([Path]) + '/' + Doc), ParentID, ChildID, KeyField

SELECT * FROM TABLE1
WHERE MYFLG =0 
AND MYFLG =(SELECT (CASE WHEN COLUMN1 = 1 AND COLUMN2 = 0 THEN 1 ELSE 0 END) AS MYFLG FROM TABLE1)

SELECT * FROM TABLE1 WHERE (MYFLG = 0 OR (COLUMN1 = 1 AND COLUMN2 = 0))

not in  where  COLUMN1 = 1 AND COLUMN2 = 0

Select * from TABLE1 where PK not in ( Select PK From TABLE1 Where COLUMN1 = 1 AND COLUMN2 =0)