if csv file is correct, use bulk insert should be simplest.

One option is using dynamic sql:

If @offer = 'USA'

declare @where varchar(1000)

Begin

   set @where =    'status = ''A'''

Else

   set @where = 'status_country = ''A'''

End

Exec('select top 5 * from...

Try add Test_Read role as member of db_denydatareader role.

Try

SELECT C.ContactID,

 E1.EmailAddress AS 'Primary', E1.EmailID AS 'PrimaryEmailID',

 E2.EmailAddress AS 'Secondary', E2.EmailID AS 'SecondaryEmailID'

FROM Contact C

 LEFT OUTER JOIN (ContactEmail CE1 INNER JOIN Email E1 ON CE1.EmailID = E1.EmailID AND CE1.EmailTypeID = 1)

  ...

Use linked server or openquery.

Check BOL(book on line) for detail syntax and samples.

Use union.

select lastname, firstname from database1..tablename

union all

select lastname, firstname from database2..tablename

what tool to execute the script? Some posts here indicates that.

Assume you have chinese character installed in the machine.

Try to save as the text file to unicode encoding before loading.

try this

declare @tbname varchar(60)

set @tbname = 'tblTEST'+'_'+convert(varchar,getdate(),112)

select @tbname

exec('create table '+@tbname+'(c1 int)')

Add column with null first

Add constraint with nocheck to exists with default value.

Update existing rows with default value using rowcount or what ever.

Backup master first (precaution).

Stop the sql server.

Regedit to modify master db location.

  lOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLSERVER/MSSQLSERVER/PARAMETERS/SQLArg0 ~ SQLArg2

Restart the sql server

One of ways

select [id],

 sum(case when val1 is not null then val1 else null end) val1,

 sum(case when val2 is not null then val2 else null end) val2,

 sum(case when val3 is not...

From MSDN lib.

Although not exactly a disk-storage issue, disk fragmentation slows the transfer rate and seek times of your disk system and you need to monitor for increasing disk fragmentation....

Try

USE master

GO

EXEC sp_addlinkedserver

 @server='anyname',

 @srvproduct='',

 @provider='SQLOLEDB',

 @datasrc='(local)'

GO

EXEC sp_addlinkedsrvlogin 'anyname', 'false', 'sa', 'Admin', NULL

go

select * from anyname.master.dbo.sysobjects