wouldn't creating a proc for this script and calling it in one Execute SQL task would do ?

(by the way I did not go through the query..at this time of...

Can you please post the DDLs and expected o/p ? That way it'll be easy to help you...

In lookup to get the maximum performance benefit we use Full cache or partial cache depending on the the table size... if table size is huge then partial cache would...

:-D:-):Wow:

Additionally, would try to eliminate the unnecessary columns ... then would try if we can somehow convert Merge Join into the SQL joins ... I'm hopping here that @...

I would have started with an effort to eliminate sort transforms here.. there are too many of them

ahhh :crazy:... Indeed... Silly me ... Please try doing the way Grant has proposed...

What all steps have you tried till now ? Where are you facing problem grouping it @ report level or @ Script level ?

Did you go through following link?

https://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-datetime-workbench/

I tried it by writting below code

CREATE TABLE #TEMP

(

SCRIPT VARCHAR(4000)

)

INSERT INTO #TEMP

EXEC XP_CMDSHELL 'type filefath\filename.txt'

DECLARE @SQL VARCHAR(8000)

SELECT @SQL= STUFF((

SELECT CONVERT(VARCHAR(1000),' '+ SCRIPT) FROM #TEMP

FOR XML PATH('')),1,1,'')

EXEC (@SQL)

DROP TABLE #temp

You want to bypass the foreign key constraint ... so question arises why do you have them in first place ?

Probably disabling it temporarily should solve you problem .. you...

Though following code would work but I feel there must be a easy way around.. SSC experts might help us here

;with cte as

(

SELECT DISTINCT T1.NAME,T1.DOB,

CASE

WHEN T1.SEX IS...

Do you have start item set on your project as a Old report ? That could be the reason...

create a maintenance plan to automate the process. Please refer following links

http://weblogs.asp.net/sreejukg/archive/2010/01/20/scheduling-automated-backup-using-sql-server-2008.aspx

https://community.rackspace.com/products/f/25/t/210

Please read about backups on MSDN to get the gist of the subject.

Have you tried taking backup, did it fail ? Did you try taking backup at shared path on the remote server ?