.

• This reply was modified 6 years, 4 months ago by Jonathan AC Roberts. Reason: deleted

Heh... let the silliness continue.  I just got an email saying...

KILL 99.9% OF BACTERIA & HARMFUL MICROBES

FORMS A PROTECTIVE SHIELD THAT DELAYS GROWTH OF HARMFUL MICROBES ON INTERIOR...

The fastest way for you to do this is in SSMS Object Explorer, select the "Stored Procedures" node, then press F7. In the right-hand pane then select all the stored...

Install this stored procedure

IF Object_Id(N'INFGenerateObjectScript', N'P') IS NULL
BEGIN
    EXEC ('CREATE PROCEDURE [dbo].[INFGenerateObjectScript] AS BEGIN SELECT 1 END')
END
GO 
 
GO 
-- **********************************************************************
-- PROCEDURE INFGenerateObjectScript
-- Description:...

Why don't you have your stored procedure code in a source control system?

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...