This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.
Course Of The Month
11 days, 9 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
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
The canonical version of this article is on my web site here:
http://iconoun.com/articles/collisions/
A companion presentation is available here:
http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
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.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the
Monte Carlo …
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month11 days, 9 hours left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$49.00$44.10
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.