Yes, it is a cluster index scan of PK_Tab2.

The DDL of the two tables:

CREATE TABLE [Tab1]

(

[ClientContextID] INT IDENTITY (1, 1)NOT NULL,

[ClientID]...

Thanks

Thanks for the solutions.

It is not what I need.

In fact, I only need to script out the users, database roles and the mapping between users and logins.

Thank you,

Very nice solution.

Sorry, for putting wrong sample data. The data should be between 1 and 31 August.

It works.

Thanks

It is a nice solution.

Thank you,

ioani

I have following tables:

CREATE TABLE Item

(

ItemID INT,

Name VARCHAR(60) ,

CategoryID TINYINT,

Subcategory

)

CategoryID from Item is a foreign key to...

The solution I found for the problem:

-- Input data--

IF OBJECT_ID('#Params') IS NOT NULL

DROP TABLE #Params

CREATE TABLE #Params

(

ParameterID NVARCHAR(8) NOT NULL,

ParameterValue SQL_VARIANT NOT...

Thank you,

I managed to solve the problem.

Sorry, I have a little error in may sample data. P5 should have only one '20100803' ParameterTimestamp value. The ParameterID should have distinct ParameterTimestamp (the ParameterID and ParamterTimestamp form the...

Thanks Mike01

You have answered my question.

I have a table that map the tables to be joined to the tables where the result of the join is put in:

----------------------------------------------

TableToJoin TableResult...