You can make use of WHILE[/url] loop or Recursive Queries Using Common Table Expressions

CTE[/url] is a good choice.

@Mad-Dog,

I think the second solution I posted (with small script) will do the job.

@Phil:

I added WHERE clause in the script mentioned in the first link of my post. After adding the WHERE clause, it looks like this:

SELECT

t.NAME AS...

OK Guys.

This code returns all tables and total rows in each table. I also used WHERE clause:

CREATE TABLE #temp

(

...

The links below may help. You can add a WHERE clause to meet your requirements for the number of rows.

Query to list number of records in each table in a...

A trigger is similar to stored procedures with a little difference. Trigger is attached to a table and the code gets executed automatically when row is inserted, updated or deleted...

You provided very little information. What exactly you want to do?

Create an AFTER INSERT trigger and add that query into it.

Refer to these article:

Using SQL Server 2005/2008 Pivot on Unknown Number of Columns (Dynamic Pivot)[/url]

SQL Server Pivot: Converting Rows to Columns with Dynamic Query

Retrieving rows as columns using a single...

Refer to this links:

SQL Server: Best way to Update row if exists, Insert if not

@data Analyst:

Provide us more details. If you take time to craft your question well, you have more chances of correct answer.

What is the structure of the two tables...

Ok. That's good.

Each forum has its own plus and minus. Stack Overflow is not dedicated to SQL Server but a common platform to ask any type of questions.

Any forum answer is not...

The person asking the question will come to know whether the answer is correct or not by trying out and seeing the output. This is applicable to forums where the...

Probably something like this:

DECLARE @Query1 Varchar(1000)

DECLARE @Query2 Varchar(1000)

DECLARE @FinalQuery Varchar(max)

SET @Query1 = 'SELECT * FROM Employees A'

SET @Query2 = 'SELECT EmpDept, EmpID FROM EmpDepartments'

SET @FinalQuery = @Query1 + ' LEFT...