Comments by sanalpulikkal (Top 2 by date)

sanalpulikkal 13-Oct-11 6:04am View

Deleted

DECLARE @STARTDATE AS DATETIME;
DECLARE @MYTIME AS DATETIME;
DECLARE @SERVERDATE AS DATETIME;
DECLARE @HOURDIFFTIME AS INT;

/* Enter the Current date in server*/
SET @STARTDATE =( SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())))

/* Enter the time you want*/
SET @MYTIME = '06:00:00.000'

/* This is your current serverdate*/
SET @SERVERDATE =(
SELECT
CAST
(
DATEADD(dd, 0, DATEDIFF(dd, 0, @STARTDATE)) + ' ' +
DATEADD(Day, -DATEDIFF(Day, 0, @MYTIME), @MYTIME)
AS DATETIME
)
)

/* Now you retrive the last scrap time*/

/* WRITE YOUR QUERY*/
-- SELECT GETDATE() AS LASTSCRAPTIME

/* Then calculate the difference .*/
SET @HOURDIFFTIME = (SELECT DATEDIFF(HOUR, @SERVERDATE,GETDATE()));

/* Yes Now you get what you want*/
SELECT @HOURDIFFTIME;

sanalpulikkal 30-Jul-10 5:18am View

Hai Arun,
I applied this code but i got some error like this..can u help me plz...
Instance Argument:Canot convert from 'int[]' to 'System.Collctions.Generic.IEnumerable<long>'
public override IEnumerable<fa_acc_head> GetFA_ACC_HEAD_IDS()
{
using (DC_FN_CONTEXTDataContext context = DataContext)
{
int[] serialNos = new int[] { 1, 2 };
var objList = from p in context.FA_ACC_HEADs
where serialNos.Contains(p.NSCHEDULE_SL)
select p;
return objList;
}
}