Viewing 15 posts - 1 through 15 (of 20 total)
Here are the DDL for the tables
====Patients====
[PatientID] [varchar](20) NOT NULL, --Primary Key
[LastName] [nvarchar](25) NULL,
[FirstName] [nvarchar](25) NULL,
[AKA] [varchar](50) NULL,
[ClinicianId] [int] NULL,
[MEDICAID_ID] [nvarchar](8) NULL,
[PendingMedicaid] [tinyint] NULL,
[PrivatePatient] [tinyint] NULL,
[MedicaidEffectiveDate] [datetime] NULL,
[MedicaidTermDate] [datetime]...
January 15, 2013 at 5:02 pm
Hi Again,
I'm experimenting some using the find dupe queries, but have run into a result I don't want. Here is the query:
SELECT APGAttendance.[PatientID], APGAttendance.[AttendDate], APGAttendance.[CTPCodes]
FROM APGAttendance
WHERE (((CTPCodes = 'G0396' or...
September 13, 2012 at 7:11 pm
Hi Paul,
I thought it also may help a little bit to give a little more detail as to how we are setup now:
Note, database structure is the same for all...
July 26, 2012 at 11:48 am
Hi Paul,
Thanks for the reply.
1. I was thinking that since the portal was read only, and intake would need the ability to add/update data, that a separate db's might...
July 26, 2012 at 11:26 am
Hi GSquared. thanks for the reply. It did help. I thought about doing something similar, but wanted to see if there was an easier way (not to say that this...
June 19, 2012 at 1:55 pm
In reference to question 2. Could Ownership Chaining help in allowing me not to have to create a user on all the SQL servers?
Thanks
January 4, 2011 at 11:32 am
Hi Carl,
Thanks for the reply. Now I have an issue with the SQL Server Agent not running. I have assigned the new user id to the SQL Agent Job (by...
December 24, 2010 at 11:39 am
BTW, I added this account to work with SQL Server Agent between some Linked servers I have.
December 24, 2010 at 8:37 am
Could Replication help me out here?
I've never had to use replication at this point, so please bare with me. I'm starting to read up on the topic. It looks as...
December 17, 2010 at 11:52 am
One last thing. The reason I wanted to create a index or Primary key on the original view was because I have 4 divisions in our company that I query...
December 17, 2010 at 11:30 am
Is there a way to create a local table/View of the database tables in the other databases and have the local table updated when there are Insert/updates to the other...
December 17, 2010 at 11:23 am
Thanks for the reply, I entered the query you suggested and the srvnetname, datasource and srvname are the same. IF this helps. I didn't see any error messages in the...
November 23, 2010 at 10:07 am
I'm a little perplexed right now. I still have a problem with connecting with the original program, but I installed another one of my programs (VB.NET) on the Terminal server...
November 16, 2010 at 12:12 pm
Hi,
I'm not using a userId and password. We use Windows auth to allow access to the DB. My app also uses it own security. I have turned on TCP/IP in...
November 10, 2010 at 6:01 am
Thanks for the reply. I just pinged the DB from the Terminal server and appears to be working. It said it sent 4 packets and received 4 back with none...
November 9, 2010 at 1:19 pm
Viewing 15 posts - 1 through 15 (of 20 total)