yes

Temporary data has only two columns -

ID - int.

CODE - varchar(40).

CODE is used in join condition.

Yes it was in the View.

Thank You all for your opinion and insight. It turned out that there was a function call in where clause which was slowing down the query. I removed the function...

The view has many columns which are not used in the query. I tried creating index on the view but received a message saying:

Cannot create index because it uses a...

Did you backup and restore using T-SQL or SSMS Wizard? If using the wizard, then during restore ensure on 'Options' tab, in 'Restore As' grid, the name of the .mdf...

The query shows two rows for each cInstID because the data has two classTypeId in classType table. It seems like there is nothing wrong with the query; if the query...

In SQL Server 2008 management studio, DDL & DML can be scripted using the wizard like this:

http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx

This is the fastest way to script DDL and data.

Thank You.

Hi,

Can you try to run the query for one c.[cInstID] by adding a where clause; and check the number of rows returned by commenting and uncommenting the mentioned columns.

Also,...

I need to alter definition of two columns in a table and its being done like this :

ALTER TABLE dbo.JURISDICTION_FIELD

ALTER COLUMN FIELD_CODE NVARCHAR(60) NOT NULL;

ALTER TABLE dbo.JURISDICTION_FIELD

ALTER COLUMN [DESCRIPTION]...

Thanks for you reply. Yes, the script was being run on the server, which does not leave room for network connectivity issues.