you insert the null value in datetime data field , it insert the 1900-01-01 00:00:000 value it not insert the null in this field.

Try the below code ur missed the bracket for when u using OR:

IF ((@acno IS NOT NULL OR @acno <>'') AND (@actype IS NOT NULL OR @actype <>''))

BEGIN

PRINT 'hi'

PRINT...

abc@abc.abc

kansal@a.com

xyz@xyz.com

First Query

Step 1

FETCH ABSOLUTE @ABVAL FROM CURR    INTO @EmailId

After this the Cursor Position in abc@abc.abc

Inserted this mail id in temp table

Step 2

Check the...

u create it user defined function for this req.In my knowledge no other function like ur req.

In enterprise manager select the database in that press right click properties check the path.

Hi,

select the most recent payment that time thorugh date u can select this

select * from payment where date between '2004-08-27' to '2004-08-20'

In Procedure u Hotcoded the employee code 29 .but in ur query employee code 28.this will give the wrong result set.Please check the employee code.U not used the @usr in...

In this job msdb.targetserverrole  u not mentioned the next run date that is a reson display date and time not available.Check that job next run date.

u will try

exec server1.pubs.dbo.spname

Dont use the Between for datatime datatype .Instead of between use the datediff

u try this qry

select @qty=isnull(sum(line.totalQty),0)                      

                     from tbldeliverychallaninfoDetails as line 

Pls try this query

(Select Year(ActionDate) Year, Month(ActionDate) Month, Case When PFTypeID = 151.0011 Then 'P' When PFTypeID = 150.0011 Then 'F' END Physical, Count(s.ScheduleID) Schedules

From Schedule s

Join Schedule_Audit...