i have fixed it thanks

i did small mistake

select yearmonth,

CASE

WHEN (substring ( [YearMonth] ,5,5)='1' ) THEN (substring ( [YearMonth] ,1,4) +'January')

WHEN (substring ( ...

Hi,

It is from SQL. created a view from 3 tables.

Your sql gives an error. It didnot understand the coulmn name

It produces error .

DECLARE @EndDate DATETIME, @StartDate DATETIME

SELECT...

Hi,

Thank you very much . You did what i want. It works fine. I will email you if i have an issue again

Thanks

Ram

Hi,

I have an issue, i just want to find school days between S and E for the students. I added school days column but it didnot work. in my...

It works fine but it provides 288 days between 2 days. I am trying to calculate just student working dates between S and E . It is actually 178 days.

I...

have student attendance data. I want to calculate total number of school days between startdate and End date .I could write sql for startdate and End Date but eventhough i...

I think my questions didnot add all the stuff. I dont know why it loaded half only.

if Attendance column stores value 'S' then it is start date for that student and attendance stores value as 'E' then it is end date for the student of the...

You are right. it is simple statement

I think i want to explain little bit more

Student biginging date is 'S'

Student Ending date is 'E'

In the between student may have present(P), A(...

Perfect. I think the reason is we already set dateadd for datetime1.

Thanks for your quick response.

Thanks.

Ram

Hi,

Still close. But it populates now until 2008-06-29 00:00:00.000 Not until 30th of june.

Time and seconds makes any difference?

Thanks

Ram

Hi All,

This is what i want . Great. I just test with CUBE,ROLLEUP operator. Thanks for everyone.

Thanks.

Ram

Hi All

This is great article and discussed with my manager and they want to have what you suggested. Then i created excel sheet for how we want to have the...

Hi All,

It works weel but I have 13 years of data. Current year data is only at one table and all remaining past years is historical table and also i...

Hi All,

I have another issue in this query. We dont want to show up weekends . So we want to eliminate saturday and sunday as a row in the table....