Here is my Query Of SQL server 2008 and i am not getting my desire result... kindly any one help me to solve this problem

Question

0.00/5 (No votes)

See more:

SQL

select patientid as Patient,cast (addon as Date) as Date from PatientMaster
  group  by patientid, CAST(addon as date) having CompanyID = 150

Posted 5-Apr-13 0:29am

Naseer A Khan

Add a Solution

Comments

Aarti Meswania 5-Apr-13 6:32am

please provide details... some records of i/p & desire o/p

Naseer A Khan 5-Apr-13 6:42am

actually i am generating MSchart report due to this i am getting data table from my Data base
and i am using Command type "Query" so for this purpose i am using this Query..
i am selecting all patients by date those all patients belong this company which ID is 150.

[no name] 5-Apr-13 6:34am

"CAST(addon as date)", you are not storing datetime values as something other than datetime are you?

Naseer A Khan 5-Apr-13 6:43am

sorry sir i am not getting what u are trying to ask me...?

[no name] 5-Apr-13 7:11am

What is there to "get". Why are you CAST(addon as date)?

[no name] 5-Apr-13 7:13am

That and why are you not supplying the input and your expected output? We cannot possibly know what your problem is when you do not tell us.

[no name] 5-Apr-13 7:18am

try
select patientid as Patient,cast (addon as Date) as Date from PatientMaster
WHERE CompanyID = 150
group by patientid, CAST(addon as date)

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jayname · Answer 1 · 2013-04-05T00:43:00

Solution 1

select patientid as Patient,cast (addon as Date) as Date from PatientMaster
having CompanyID = 150 group by patientid, CAST(addon as date)

Posted 5-Apr-13 0:43am

Jayname

Comments

Naseer A Khan 5-Apr-13 6:46am

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'group'.

i tried this query but its prompt me this error

Jayname 5-Apr-13 6:50am

now try

select patientid as Patient,cast (addon as Date) as Date from PatientMaster
having CompanyID = 150 group by patientid, Date

Naseer A Khan 5-Apr-13 6:55am

sir still having same error

Jayname 5-Apr-13 7:30am

select patientid as Patient,cast (addon as Date) as Date from PatientMaster
where CompanyID = 150 order by Patient, Date

Jayname · Answer 2 · 2013-04-05T00:56:00

Solution 2

now try

select patientid as Patient,cast (addon as Date) as Date from PatientMaster having CompanyID = 150 group by Patient, Date

Posted 5-Apr-13 0:56am

Jayname

Comments

Naseer A Khan 5-Apr-13 6:59am

sorry sir still having same issue

Jayname · Answer 3 · 2013-04-05T01:15:00

Solution 3

SQL

select patientid as Patient,cast (addon as Date) as Date from PatientMaster
  order by patientid, CAST(addon as date) having CompanyID = 150

Posted 5-Apr-13 1:15am

Jayname

Jayname · Answer 4 · 2013-04-05T01:18:00

Solution 4

SQL

select patientid as Patient,cast (addon as Date) as Date from PatientMaster
where CompanyID = 150  order by Patient, Date

Posted 5-Apr-13 1:18am

Jayname