Are you calling a stored procedure in your job? if yes, you can setup profiler for SP very easily by applying filter on TextData column.

Why not to try like this;

Declare @vSQL varchar(max)

IF 1 <> 0

BEGIN

Set @vSQL = 'Select * INTO #myTemp1 From dbo.countries'

END

ELSE

BEGIN

Set @vSQL = 'Select * INTO #myTemp1 From dbo.country2'

END

Set @vSQL = @vSQL...

You hacked my PC bro....

Or this might help you... I have used Temporary tables to give the idea....

The logic is same as of Lowell.

Declare @vTableA Table (ID int, [Type] varchar(10), Number int...

I think you should give the From Date and To date parameter in your report.

Nice Article. Very helpful.

Thanks.

I found something here...

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

Best of Luck...

sys.all_sql_modules is the better choice. As in syscomments, the statements are broken into pieces because of the 4000 characters limitation. The have to be checked and ordered against colid in...

Even without selecting Table Designer from Tool bars, right click the workspace of Table design screen and select 'Generate Change Script ...'. 🙂

Very interesting...

Lost...

Selected wrong option.

Select Replicate('0',2-Len(datepart (week, '2005-01-09'))) + Cast(datepart (week, '2005-01-09') as varchar(10)) as DOW

You can use Replication in SQL Server. Also you can use third part tools like SQL Data Compare or SQL Delta.

Do you want to eliminate the IDs in the result set that are in EMPLOYEE_RESIGNATION or EMPLOYEE_TERMINATION? is that what you want?

This code gave out only 253 duplicates on 16 Mln records.

I don't know if this is exactly what you're after, but you could give it a go.

SELECT TOP 1600000 RIGHT(master.dbo.fn_varbintohexstr(hashbytes('MD5',CAST(NEWID()...