Seems a little backwards to me that you have the IDs already existing in a table and then they're assigned to a User on login. I would think you'd want...

Maybe something like this will help. It will populate that temp table with the directory depth of the file/folder and a flag to indicate if the record is a...

You said you're getting a PK violation so maybe you're trying to insert some combination of:
outorder, status, outorder_source
...that already exists in the table? So you may not have...

I think you can do something like what I have below. I just mocked up some simple test data with a simple aggregate on the QTY column but I think...

"however when i load the csv file into the DB I cannot store as varbinary, so stored as nvarchar. 
when i attempt the join:"

Why can't you store...

I think I see what you're trying to do but difficult to be sure without any sample data or anything to go off of. But I think you have...

Perhaps something like:

Declare @sql as varchar(max)
Set        @SQL = 'Select
            ''hello world''
            as Message
            '

--pseudo code for checking if site 1...

As others on here have mentioned...your data is is being collected by the application in a logging format so your first step is to determine the duration for each...

Give this a shot...I think it satisfies all requirements. Let me know if it produces the desired results...it's hard to be certain with the limited test data. If it...

The problem is most likely that you're trying to run this script in DBs that don't have those tables. Again...like I said, this script is dynamic so it runs in...

Again...you need to adjust to code for YOUR database.

The code below in the dynamic SQL portion needs to be altered to match YOUR schema. Transactional replication is primary key based...

This is the code you're using:

/****** Object: StoredProcedure [dbo].[uspReplicationSyncMonitor] Script Date: 06/04/2015 11:37:40 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF OBJECT_ID('uspReplicationSyncMonitor') IS NOT NULL DROP PROCEDURE uspReplicationSyncMonitor;

go

CREATE PROCEDURE [dbo].[uspReplicationSyncMonitor]

AS

/* This proc will...

What was the result when you ran the code?

A couple things to consider...

Did you change the name of the linked server mentioned in the code to the linked server you...

Perhaps something like this would be useful for you. Seems like it's doing nearly exactly what you want.

/****** Object: StoredProcedure [dbo].[uspReplicationSyncMonitor] Script Date: 06/04/2015 11:37:40 ******/

SET ANSI_NULLS...