better u build the querry in ur application and run/ execute from there

you can try using begin and end tran for inserting and getting the identity

using replicate function and u can solve it

please check the schema and put the details in your reply

you can try with following querry

select ServerName, max(DateFrom), max(DateTo)

from dbo.Server

group by ServerName

you check whether there are two tables with same name and with different users.

iam sure that might be the reason for your querry.

If you want to copy table including data you can try the below querry

select * into otherdbname..tblname from currentdbname..tblname

otherwise if you want to copy ony the table structure try below...

If you want to copy table including data you can try the below querry

select * into

otherwise if you want to copy ony the table structure try below querry

select...

please try with below querry

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

create function [dbo].[udf_PAT_changes_value] (

@id smallint,@datee varchar(50),@colName varchar(100),@tableName varchar(50)

) Returns varchar(MAX)

AS BEGIN

DECLARE @@theValue varchar(MAX)

exec('SELECT TOP 1

@@theValue = '+@colName+' FROM' + @tableName + '...

just put the actual querry to have better idea...........

Hi,

try below querry, it should work

Select a.* from T1 a

left join T@ b on a.PartNumber = b.PartNumber

...

You may try bold or font weight

hi,

have you shared ur printer, so that the other server can access the printer server printer,

just check and let me know.