SQL server 2008 can have up to 999 non clustered indexes, though the pracitcal limit is a lot smaller.

In my experience Temp tables can perform better than CTEs, especially if you are referencing the data more than once.

However i would recommened generating some test data, there...

The best way to find out is to run them both and then check the actual execution plan, make sure you clear the cache prior to testing them.

this code will update the two names where the emp_name = mgr_name

UPDATE YourTable

SET Emp_name = 'predef.ined name', Mgr_Name = 'predef.ined name'

WHERE Emp_name = Mgr_Name

not so you can understand it, but the script should also script out the encoded password

The easiest way is to use these scripts provided by MS.

http://support.microsoft.com/kb/246133

a) yes there is still a performance hit for using cursors over a single select statement to retrieve your 50 rows.

b) a while loop is still processing the data...

Have you checked that the procedure is actualy a replicated article?

as often people will manully move procedures to the replication subscriber rather than add them to replication.

also...

ISDATE should work then, though you should do some reading on the limitations of ISDATE and how sql handles and determines a date and how your system settings...

What are the datatypes of the columns ?

you could probably us ISDATE() and add the each of the columns to each other.

eg

SELECT ISDATE(col1) + ISDATE(col2) + ISDATE(col3)........

you will need to make your source connection SQL string dynamic, this will allow you to put a where clause with a variable that you ust can select...

Are you trying to build a SSRS or a SSAS solution?

What you are seeing, Shared Data Source + Reports is SSRS.

What the instructions are saying Data Sources + Data...

karunakarch (5/19/2010)[hr

We have quite a lot of jobs that are in master database and we would like to restore it to SQL 2005 server. We are able to restore system...

Sorry this is not possible to directly restore any system databases from 2000 to 2005

There is a great example of how to use the for-each loop to loop through files, have a look at this and post back if you have any...