hi,
I trying to join weekly & daily tables by using end_dte,Rpt_dte respectively.My week is saturday to friday.first table only having week end' dates but the 2 daily table having daily dates .when I trying to join 2 tables using the following condition
weekly.end_dte= Next_day(daily. rpt_dte,'FRI')
only for this friday's date it displays next friday's date.
for ex: 7th is friday when I give...
ambelkar
Last Activity: May 19 '07, 05:27 AM
Joined: Apr 4 '07
Location:
-
query to match weekly and daily records
-
Need Some SqlServer Help
hi,
I have written the following code to get MonthEndDate,Ru nDate,MonthStar tDate.
It is giving year in MonthStartDate 2005, upto sep07 it is ok.When it come to OCT 07 it has to display monstartdate year as 2006.How can I do this.Please help me
SELECT REPLACE(upper(S UBSTRING(CONVER T(varchar, GETDATE() - DAY(GETDATE()), 113), 1, 11)), ' ', '-')
as MonthEndDate,
'01' + '-' + UPPER(substring (datename(m,get date()),1,3))... -
Need help in printing the Crystal report in PDF format
hi ,
Can anybody help me in printing the Crystal report in PDF format.i.e not exporting it to PDF format.When Click preview it should be displayed in PDF
format. -
thanku for ur code but it doesn't dispaly in my desired order i.e
Oct06
NOV06
Dec06
Jan07
.
.
.
sep07
and also datename is not supported in crystal report formula column.only DATEPART is accepted.If u have other solution for this please send this... -
Sql Server query
hi,
I want to display the data which is in table from oct06-sep07
in the order
oct06
nov06
. .
.
.
.
sep07.
The data in this format yyyy-mm-dd format.I have written the following query inorder to dispaly as above in the formula column of Crystal Reports,but i is not displaying.Can anybody help me
if Mid(totext({sp_ wr0438_m1_repor t;1.END_DTE}),1 ,3)='oct'...
No activity results to display
Leave a comment: