don't think you can insert rows into a linked server using openquery statement.

Yes you can

From LnkSrv1

INSERT INTO OPENQUERY(LnkSrv2,'SELECT...

As the error states, SQL can only restore from tape backups made using SQL BACKUP, your backup was done using NTBACKUP and hence the error.

Use NTBACKUP to restore the backup...

Yes, the left join is intentional.

I used to find if there was a corresponding entry for the previous/following day with the oposite values. So for the data you posted each...

This will work on the data given but any other alternative may not

SELECT a.pid,a.dos,a.post,DATEDIFF(day,a.dos,a.post) AS [lag],a.part,SUM(a.volume),SUM(a.charges)

FROM a

LEFT JOIN b

ON b.pid=a.pid

  AND b.dos=a.dos

  AND...

btw I agree with Hugo, none of the answers is correct.

I did not answer when I realised this

Also used by FTS on incremental catalog population.

One way

SELECT c.[id],c.[name],c.[type],v.[value]

FROM (SELECT [id], 'make' AS [name], [make] AS [value] FROM @veh UNION

SELECT [id], 'model', [model] FROM @veh UNION

SELECT [id], 'color', FROM @veh) v

LEFT...

Why are you using functions to do simple calculations? Or is there more complex query that you have not given?

You have a logic error in GetItemSoldCount. Whenever you use AND...

SELECT a.costcodeid,a.costcodedesc,b.combistatus

FROM [coscodetable] a

LEFT JOIN [tallycombi] b

ON b.itemid = a.costcodeid

and b.projectid = '999'

The last line

ON e.EMPID = x.EMPID and AND l.Verify = 'N'

has too many AND's and Verify should be referencing alies e not l, ie

ON e.EMPID = x.EMPID AND

Use a CASE statement

SELECT x.EMPID,COALESCE(a.[NAME],'') AS [NAME],

CASE WHEN l.Verify = 'Y' THEN COALESCE(l.LICENSE,'') ELSE '' END AS [LICENSE],COALESCE(l.EMPLSTS,'') AS [EMPLSTS]

FROM (SELECT @EMPID AS [EMPID]) x

LEFT JOIN @HREMP_adp...

Not sure what your question is but based on your last query

a parameter of '11111' will return

EMPID  NAME  LICENSE  EMPLSTS

11111  ABC   NULL     NULL

a parameter of '11112' will return

EMPID  NAME  LICENSE ...

Replace N'111111' with the parameter, eg @EMPID

Add any further checks to the ON clause of the License JOIN, eg if the test for not expired is EXPIRED = 0

then your...

Sorry forgot to remove @ I used table variables to test query

Should have been

SELECT x.EMPID,COALESCE(a.[NAME],'') AS [NAME],COALESCE(l.LICENSE,'') AS [LICENSE]

FROM (SELECT N'111111' AS [EMPID]) x

LEFT JOIN HREMP_adp a...

Didn't you mean

IF NOT EXISTS(select * from information_schema.columns where tablename='programversion' and columnname=@col )