In the Wizard, when you are specifying the mapping between tables from the Source to the Destination, click on Edit and check the check-box that says "Enable Identity Insert".

In the beginning of your procedure code that this report is using, check for the existence of the temporary table that your procedure creates...if it exists, drop it.

You can also...

You can use

sp_helpindex

In addition, search this site and you can find a couple of very useful scripts that give out a lot more information on all the indexes in...

This is the best article on this topic (from a SQL Server MVP):

http://www.sommarskog.se/arrays-in-sql.html

You can do a GROUP BY on TOPIC_ID and TOPIC_TITLE and select the MAX(POST_TIME) to get a single record per TOPIC_ID and TOPIC_TITLE and then chose the TOP 5 out...

You can do:

use pubs

go

declare @t varchar(8)

set @t='authors'

exec ('select * from '+@t+'')

or

use pubs

go

declare @t varchar(8), @cmd nvarchar(100)

set @t='authors'

set @cmd = N'select * from '+@t+''

exec sp_executesql @cmd

Doing the way that...

There are couple of ways of doing it...one is:

declare @table table (col1 varchar(1000))

insert into @table values ('1234,45456,8888')

insert into @table values ('1234, ,8888')

insert into @table values ('1234,45456,')

select 

substring(col1, 1, charindex(',',...

The error message is pretty explicit.  You cannot do that.

If you want to make call to another stored procedure, change your function to be a stored procedure and then you...

You can script the structure out - In Enterprise Manager, right click the database, All Tasks and Generate SQL script...then chose whatever options you need and that will generate the...

Assuming that you want to preserve the first entry when duplicates are encountered, you can do something like this:

set nocount on

go

declare @table table (rowid int identity(1,1), DESC_COL varchar(20))

insert into @table...

Yes, it does.  It's called indexed views in SQL Server.  MVs are Oracle lingo.

From BOL:

Indexed views can be created in any edition of SQL Server 2000. In SQL Server 2000...

set nocount on

go

declare @table table (EmpID INT, DEPTID INT)

insert into @table values (1, 1)

insert into @table values (1, 2)

insert into @table values (1, 3)

insert into @table values (1, 4)

insert into...

Search this site for SQLXML and OPENXML and you will get your answer...there are a couple of good articles on this topic.

Look at the white-papers from Quest:

http://www.quest.com/documents/list.aspx?ContentTypeId=1

These will get you started and will give you a very good understanding of what you need to do.

Cross database foreign keys are not supported in SQL Server.  For query purposes, however, you can create linked servers (same as db links in Oracle) and then query across the...