Viewing 15 posts - 31 through 45 (of 105 total)
this is not working
i am getting date liek this
2010-10-31 00:00:00.000
2010-11-30 00:00:00.000
2010-12-30 00:00:00.000
2011-01-30 00:00:00.000
2011-02-28 00:00:00.000
2011-03-28 00:00:00.000
its just adding month, not the exact day ,i tried your code,still not getting
April 15, 2012 at 12:42 pm
i know basic,
i am just trying to get idea.
the prob is
set @row1 = DATEADD(MONTH , 1...
April 15, 2012 at 12:15 pm
ok the condition is working,
but i have problem with if(stat)
whats wrong in that
April 15, 2012 at 8:32 am
i am passing todate like this @ToDate = '12/31/2011',
and fromdate is getting liek this 2010-12-31 00:00:00.000
is this a problem?
April 14, 2012 at 9:50 pm
they both are datetime.
how to compare two dates with <=
April 14, 2012 at 9:47 pm
ok. i hav tried this code
declare @row1 datetime
set @row1 = @fromYTD
...
April 14, 2012 at 9:38 pm
ok.thanks a lot,i will get back,once i am done with all this code.
thank u guys for your support
April 14, 2012 at 8:16 am
ok. i have second function wih external name.
now what i have to do
April 14, 2012 at 7:59 am
my function doesnt have base table
it simplylike this
create function name(@Reportdate1)
return table
(
column1 datatypr,
column2 datatype)
April 14, 2012 at 7:42 am
what DDL u talkign abotu i didnt get it.
i need to insert this I1 values into udf,as i cannot ,i need to create temp table with all the the fields...
April 14, 2012 at 7:20 am
thanks,but i need to check till @row1 = todate,can i use <=.
and for this thing
IF (<whatever the date to be checked is> NOT IN (SELECT <date column> FROM <some other...
April 14, 2012 at 6:55 am
i am doing my best now.
CREATE procedure Dashboard
------Required parameter----------------
@FromDate datetime,
@ToDate datetime,
@Date datetime,
as
begin
declare @ReportData varbinary(max)
exec item
---------required parameter------------------
...
April 13, 2012 at 9:56 pm
i m fresher in sql,then how to do this ,if nto with while
give me example
April 13, 2012 at 8:10 pm
its not working as ,its not going thru loop.
and doesn not get anything from select statement, i need to increament date by 1 month.
it does not match the condition as...
April 13, 2012 at 6:12 pm
at least help me with my code
how to check while loop and increment date by 1 month in while loop
April 13, 2012 at 4:08 pm
Viewing 15 posts - 31 through 45 (of 105 total)