Forum Replies Created

Viewing 15 posts - 1 through 15 (of 20 total)

  • RE: Not getting results expected from a Group by query

    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]...

  • RE: Return dupes within a date range

    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...

  • RE: Is Replication correct in this situation ?

    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...

  • RE: Is Replication correct in this situation ?

    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...

  • RE: Finding Duplicated across several servers

    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...

  • RE: "Login Failed for Use" error with Linked Server

    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

  • RE: Problems adding a new Login

    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...

  • RE: Problems adding a new Login

    BTW, I added this account to work with SQL Server Agent between some Linked servers I have.

  • RE: Indexed Views that contains a linked server

    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...

  • RE: Indexed Views that contains a linked server

    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...

  • RE: Indexed Views that contains a linked server

    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...

  • RE: Connection Errors

    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...

  • RE: Connection errors from Terminal Server

    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...

  • RE: Connection errors from Terminal Server

    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...

  • RE: Connection errors from Terminal Server

    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...

Viewing 15 posts - 1 through 15 (of 20 total)