USe pivot table approach

USE DOMAIN_DBA

GO

DECLARE @t TABLE (EMP_ID int , Contact_type nvarchar(50), Contact_Number nvarchar(300))

INSERT INTO @t

SELECT 1 ,'Home' ,'92 - 51 - 225478'

UNION SELECT 1, 'Cell', '92 -...

Use PIVOT TABLE approach

USE DOMAIN_DBA

GO

DECLARE @t TABLE (EMP_ID int , Contact_type nvarchar(50), Contact_Number nvarchar(300))

INSERT INTO @t

SELECT 1 ,'Home' ,'92 - 51 - 225478'

UNION SELECT 1, 'Cell', '92 - 131...

post your query

duplicate post http://www.sqlservercentral.com/Forums/Topic952011-338-1.aspx

refer this link http://technet.microsoft.com/en-us/library/cc966392.aspx

Dont cross post , its simply wastage of time

reply on this http://www.sqlservercentral.com/Forums/Topic950491-145-1.aspx

i think there is some access restriction, copy that backup file to the local drive of server (where your want to restore it) then do the restoration.

Replace your DTEXEC.exe 64 bit with the DTEXEC.exe(32bit). but i am not sure about the impact it will cause.

Jason Shadonix (7/9/2010)

Whats the benefit you got with it...

Check the page count , if it is near about 1000 as gail suggest, there would be no impact of defragmentation.

select object_name(object_id),page_count,* from sys.dm_db_index_physical_stats (22,null,null,null,null)

The reason to stop mirroring is : if i rebuild the indexs of larger tables, log will grow tramendously.and same size (log) will be replicated to report node also. so...

My take would be like this :

1. disable the mirroring ,

2. do the index rebuild/reorgnize

3. restore latest backup and log backup on OLAP node

4. shrinking...

Depends

Temp tables

Behave just like normal tables, but are created in the TempDB database. They persist until dropped,...

I still stuck with his problem , please help me

If updation has happened, following query should give same output for both selected columns

SELECT P.Specialty , T.Specialty

FROM SomeTable P

LEFT JOIN temp T

ON P.id = T.id

WHERE P.Specialty...