Database

<br />
SELECT O.*, CASE WHEN O.IsUserMember = 1 THEN U.UserName ELSE M.MemberName END <br />
FROM Orders O, CASE WHEN O.IsUserMember = 1 THEN Users U ELSE Members M END <br />
WHERE CASE WHEN O.IsUserMember = 1 THEN O.UserId = U.UserId ELSE B.UserId = M.MemberId END;<br />

CREATE TABLE [dbo].[Table1]
( [ColumnID] [INT] NOT NULL,
 [ColumnName] [NVARCHAR](250) NOT NULL,
 [FileContent] [VARBINARY](MAX) FILESTREAM NOT NULL,
 [ColumnDate] [VARCHAR](50) NOT NULL,
 [UserID] [VARCHAR](50) NOT NULL, 
[DefaultColumn] [BIT] NOT NULL, 
[ID] [UNIQUEIDENTIFIER] ROWGUIDCOL NOT NULL 
CONSTRAINT [DF__TblCheque__ID__398D8EEE] DEFAULT (NEWID()), [ReadOnly] [BIT] NOT NULL,
CONSTRAINT [PK_Table1_1] PRIMARY KEY CLUSTERED ( [ColumnID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, 
ALLOW_ROW_LOCKS = ON, 
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] FILESTREAM_ON [FileStreamG], 
CONSTRAINT [UQ__Table1__3214EC26C89CBB09] UNIQUE NONCLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, 
ALLOW_PAGE_LOCKS = ON, 
FILLFACTOR = 70) ON [PRIMARY] ) ON [PRIMARY] FILESTREAM_ON [FileStreamG]

public void SetRetainSameConnection()
{
    try
    {
        if (_Status == DTSPackageStatus.Loaded)
        {
            Connections connections = _Pkg.Connections;

            if (connections != null)
            {
                for (int Idex = 0; Idex < connections.Count; Idex++)
                {
                    ConnectionManager connection = connections[Idex];

                    if (connection.Properties.Contains("RetainSameConnection"))
                        connection.Properties["RetainSameConnection"].SetValue(connection, true);
                }
            }
        }
    }
    catch (Exception ex)
    {
        _Status = DTSPackageStatus.LoadFailed;
        throw ex;
    }
}
public void SetPakageConnections(System.Collections.Hashtable ConnectionCollection)
{
    try
    {
        if (_Status == DTSPackageStatus.Loaded)
        {
            Connections connections = _Pkg.Connections;

            if ((ConnectionCollection != null) && (connections != null))
            {
                for (int Idex = 0; Idex < connections.Count; Idex++)
                {
                    ConnectionManager connection = connections[Idex];

                    //connection.Properties["RetainSameConnection"].SetValue(connection, true);

                    string ConName = connection.Name;

                    if (ConnectionCollection.Contains(ConName))
                    {
                        connection.ConnectionString =
                            ConnectionCollection[ConName].ToString();
                    }
                }
            }
        }
    }
    catch (Exception ex)
    {
        _Status = DTSPackageStatus.LoadFailed;

        throw ex;
    }
}

public void SetPakageVariables(System.Collections.Hashtable VariableCollection)
{
    try
    {
        if (_Status == DTSPackageStatus.Loaded)
        {
            Variables variables = _Pkg.Variables;
            if ((VariableCollection != null) && (variables != null))
            {
                for (int Idex = 0; Idex < variables.Count; Idex++)
                {
                    Variable variable = variables[Idex];
                    string VarName = variable.Name;

                    if (VariableCollection.Contains(VarName))
                    {
                        bool IsReadOnly = (bool)variable.Properties["ReadOnly"].GetValue(variable);
                        if (!IsReadOnly)
                            variable.Value =
                                VariableCollection[VarName].ToString();
                    }
                }
            }
        }
    }
    catch (Exception ex)
    {
        _Status = DTSPackageStatus.LoadFailed;
        throw ex;
    }
}