Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
set @strSQL = 'SELECT NULL, ' + CAST(@contractID as varchar(20)) + ', PATIENT_TP, CASE WHEN MAX(REIMB_TP) = ''FIXED'' THEN 4 WHEN MAX(REIMB_TP) = ''VARIABLE'' THEN 5 END, SUM(CHARGES), MAX(BD_CONTRACT), 0, (100-MAX(BD_CONTRACT)), MAX(REIMB_TP) FROM data8.' + @strDB + '.dbo.tblREIMBURSEMENT WHERE insurance = ' + @ID + ' GROUP BY PATIENT_TP'
|Where did he set up the database connection in the Mirth engine?||3||23|
|Setting a NULL value to an empty string in SQL||32||29|
|SQL Server Running Balance||14||32|
|Access - Unable to link to sql table with too many indexes||4||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!