I suppose the variables @sdate and @edate are parameters. I had the same type of problem in my procedures. Make sure the optimiser has correct values for @sdate and @edate the...

You could create a sp_ stored procedure in the master database. sp_ stored procedures in master can be called from any database, and are the only type of...

I found the same type of problem on this site http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=113712 and there is a link to a fix ...

There is no easy way to do this. I would suggest to script the creation of the system function into an other file, and do something like this : (...

If you know the name of the identity column, you can do something like this :

-- drop table tst drop table #tst

go

create table tst

(

    i int identity(1,1),

    j varchar(10),

    k...

The best way to do is to pass your scripts file through a Preprocessor ( like for compiling C programs ). Just define a macro IFF(a,b,c) as case when a...

Could you try this :

SELECT name,

next_run_date,

next_run_time,

DateDiff(Day, CAST (next_run_date AS VARCHAR(8)), getdate()) as Days,

DateDiff(hour,CAST(next_run_date as varchar(8)) +  ' ' + right('00' + CAST((next_run_time/10000)         as varchar(2)),2) + ':' + right('00' + CAST((next_run_time/ ...

You can change the sp_rename stored procedure ( in master ), and comment the line with

raiserror(15477,-1,-1)

I would suggest to create a new (system) stored procedure sp__rename, as a copy...

You could use the datediff function like this :

DELETE FROM TableX x

WHERE DATEDIFF(dd,x.DateFields,getdate()) > 21

I would do it like this, to make sure the inported rows stay in the same order :

if object_id('tempdb..#xpcmd') is not null drop table #xpcmd

go

create table #xpcmd ( id int...

This seems OK to me . You could add begin/commit transaction to make sure you do not insert the same source and IncidentNo twice....

You need this :

Insert into TableX

Select Y.Col1, Y.Col2

From TableY Y

where Not Exists (Select 1 From TableX X  Where X.Col1 = Y.Col1 and X.Col2 = Y.Col2)

It can be done in different ways. I do it by creating the same stored procedure in each database, and have the database I want the data from as a...

I'am having the same problem. Only solution I found is to change to an other view and change again to taskpad

you can find procedures on this site to crypt/decrypt strings. Of course, you still have to pass the key ( password ) to crypt/decrypt this as a parameter to the...