Skip to content
CalMHSA Learn (LMS System)
Help Desk Ticket (Admin)
Customer Ticket Portal
EHR Bulletin
MENU
Home
Accessing Data in SmartCare
Billing Documentation
CalMHSA Connex
CalMHSA Rx
Clinical Documentation
Contract Provider Data Entry Only
CSU Documentation
EHR LMS PowerBi Dashboard
Events
Frequently Asked Questions
Front Desk Documentation
Inpatient Documentation
Nursing Documentation
Patient Portal
Prescriber Documentation
Policy Playbooks
Protocols
QA/QI and State Reporting
RCM Counties
Reporting System Administration
Residential Documentation
SmartCare Downtime Forms
SmartCare EHR Go Live Migration
SmartCare Known Issues
Substance Use Documentation
Supervisor Workflows
System Administration Documentation
Home
Accessing Data in SmartCare
Billing Documentation
CalMHSA Connex
CalMHSA Rx
Clinical Documentation
Contract Provider Data Entry Only
CSU Documentation
EHR LMS PowerBi Dashboard
Events
Frequently Asked Questions
Front Desk Documentation
Inpatient Documentation
Nursing Documentation
Patient Portal
Prescriber Documentation
Policy Playbooks
Protocols
QA/QI and State Reporting
RCM Counties
Reporting System Administration
Residential Documentation
SmartCare Downtime Forms
SmartCare EHR Go Live Migration
SmartCare Known Issues
Substance Use Documentation
Supervisor Workflows
System Administration Documentation
Home
Accessing Data in SmartCare
Billing Documentation
CalMHSA Connex
CalMHSA Rx
Clinical Documentation
Contract Provider Data Entry Only
CSU Documentation
EHR LMS PowerBi Dashboard
Events
Frequently Asked Questions
Front Desk Documentation
Inpatient Documentation
Nursing Documentation
Patient Portal
Prescriber Documentation
Policy Playbooks
Protocols
QA/QI and State Reporting
RCM Counties
Reporting System Administration
Residential Documentation
SmartCare Downtime Forms
SmartCare EHR Go Live Migration
SmartCare Known Issues
Substance Use Documentation
Supervisor Workflows
System Administration Documentation
Manage Account
Manage Account
Search
Last updated: December 29, 2023
5. How to Add a Data Set from SSMS
Next add Dataset which is equivalent to a query, this is where you need to create a query from
MS SQL Mgmt Studio
Create data set in MS SQL Server Mgmt Studio
Last updated: December 29, 2023