Agreed, but what's much worse is...

Hi,

I have two tables, both the tables have 4 common columns,

First Column: LinkingID

Other four columns(Name,Department,City).

In few instances, we will get LinkingID row values, and few instances we don't have...

The usual way to model this structure is like this:

IF OBJECT_ID('Path','U') IS NOT NULL DROP TABLE Path
IF OBJECT_ID('Node','U') IS NOT NULL DROP TABLE Node
GO
CREATE TABLE Node
(
 ...

Thanks for your response Phil.  This would work, but I was attempting for it to be more dynamic.  Needed to be able to feed a parameter becasue there are...

In the question...

A very good idea from Erland Sommarskog, you might be able to increase the performance even more if the view needs optimising.

The first thing to try is to paste...

I would start by trying to...

Sorry to say this.

Actually I am new to working on SQL and creating SSIS Packages. So, can you please explain that to me in a simplified way.

If the table...

This is the fast way John Mitchell mentioned:

SELECT SUM(P.[rows]) AS [RowCount]
  FROM sys.tables AS T
 INNER JOIN sys.partitions AS P
      ...

You could build the query using dynamic SQL, that way you wouldn't be referring to columns that don't exist in your query.

Also, (this isn't going to fix your problem) instead...

SELECT LEFT(x.Comment,20) + IIF(LEN(x.Comment>20,'...','')
  FROM myTable x

Sorry, I meant to put the 7th character not the 6th:

            
April 15, 2020 at 3:37 pm
            
#3743174

            
            
                                                
        

Could be some string terminating characters in the account number, see if this returns anything from your source table

select ASCII(SUBSTRING(AccountNo,6,1)), AccountNo
from mySourceTable
where ASCII(SUBSTRING(AccountNo,6,1)) is not null

CREATE TABLE #temp(SSN varchar(20),TableName sysname);

INSERT INTO #temp(SSN,TableName)
SELECT @SSN, 'dbo.MyTable1' 
 WHERE EXISTS(SELECT *
 ...

CREATE PROCEDURE FindSSN(@SSN varchar(20)) AS
BEGIN

    CREATE TABLE #temp(TableName sysname);

    INSERT INTO #temp(TableName)
    SELECT 'dbo.MyTable1' 
   ...