We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
8 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MS-SQL query question
Posted on 2012-12-21
Hi I am doing a query using MSSQL Mgt Studio in design view ( because I no nothing). On MS SQL server 2005
SELECT patient_name.*, patient_address.*, doctor.*
FROM patient_name CROSS JOIN
patient_address CROSS JOIN
doctor
I need to limit the query to the past 12 months (so the server doesn't gag) and produce an output I can eventually import into Excel
SELECT patient_name.*, patient_address.*, doctor.*
FROM patient_name CROSS JOIN
patient_address CROSS JOIN
doctor
I need to limit the query to the past 12 months (so the server doesn't gag) and produce an output I can eventually import into Excel
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
- +1
5 Comments
Active 2 days ago
SELECT patient_name.*, patient_address.*, doctor.*
FROM patient_name CROSS JOIN
patient_address CROSS JOIN
doctor
where <myDatecolumn> > dateadd("m",-12,getdate())
FROM patient_name CROSS JOIN
patient_address CROSS JOIN
doctor
where <myDatecolumn> > dateadd("m",-12,getdate())
I tried to grab billing dates from a billing submission table called reconsideration_table and it bombs
Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '<'.
Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '<'.
Active today
The server will gag from those CROSS JOINs, because they are inappropriate here.
Something like below will be close, although it's probably still not quite right, since there should be a "doctor_patient" table and/or a "patient_visit" table that would be more accurate to use for this.
SELECT patient_name.*, patient_address.*, doctor.*
FROM dbo.patient_name pn
INNER JOIN dbo.patient_address pa ON
pa.patient_id = pn.patient_id
INNER JOIN dbo.doctor d ON
d.doctor_id = pn.doctor_id
Something like below will be close, although it's probably still not quite right, since there should be a "doctor_patient" table and/or a "patient_visit" table that would be more accurate to use for this.
SELECT patient_name.*, patient_address.*, doctor.*
FROM dbo.patient_name pn
INNER JOIN dbo.patient_address pa ON
pa.patient_id = pn.patient_id
INNER JOIN dbo.doctor d ON
d.doctor_id = pn.doctor_id
SELECT patient_name.*, patient_address.*, doctor.*
FROM dbo.patient_name pn
INNER JOIN dbo.patient_address pa ON
pa.patient_id = pn.patient_id
INNER JOIN dbo.doctor d ON
d.doctor_id = pn.doctor_id
Where YourTableDateColumn > dateadd("m",-12,getdate())
--Note: YourTableDateColumn = Column where your date values reside in the table
--Ensure YourTableDateColumn is of Datetime data type..
FROM dbo.patient_name pn
INNER JOIN dbo.patient_address pa ON
pa.patient_id = pn.patient_id
INNER JOIN dbo.doctor d ON
d.doctor_id = pn.doctor_id
Where YourTableDateColumn > dateadd("m",-12,getdate())
--Note: YourTableDateColumn = Column where your date values reside in the table
--Ensure YourTableDateColumn is of Datetime data type..
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability.
Flipping Coins in Excel: Enter =RAND() into cell A2:
Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Suggested Courses
Course of the Month8 days, 3 hours left to enroll
Earn Certification
MCSA Configuring Windows 7 Exam 70-680
$49.00$44.10
729 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.