Your first query is different from your second one. I used the first one.

On an insert, I don't believe you can access the table you are selecting from, but...

This works

DECLARE @temp TABLE(

id INT,

Name VARCHAR(50)

)

INSERT INTO @temp

SELECT 1, 'Nizam' UNION ALL

SELECT 2, 'Sandeep' UNION ALL

SELECT 3, 'Ravi' UNION ALL

SELECT...

the value with the plus sign is actually a numeric value. It's the same as -6, but we usually don't put the + in front of positive numbers. ...

here's a link to how to create this. when you're done, you can just run Select dbo.CreateRandomString(5) to get the value

http://blog.webmart.de/2007/10/22/sql-server-2005-function-to-create-a-random-string/

There's a couple of problems with your query. First you're not inserting anything into the ScheduleID field so it will always be null. You are inserting the scheduleID...

here's a link to some things you can try

http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/

you need to put the Use statement in the Exec call.

SELECT * FROM OPENQUERY( [linked server],'SET FMTONLY OFF; EXEC (''USE DATABASE; DBCC showfilestats WITH NO_INFOMSGS '')')

I explained it wrong. I am deleting from the parent table and expecting a cascade delete on the child table. But this was a PICNIC (problem in chair...

I'm not sure what you're talking about. Do you have an example? Based on the data you provided, it updated all duplicate records. The only records not...

You can changes Lowell's code to order by quantity as well

--create a temp table with a bunch o union all statements

SELECT 'A' AS PART,'XYZ' AS TYPE,16 AS QTY INTO...

does the proc you're calling have a commit in it? Can you post some code so we can see?

I was able to get the results I think you were looking for. It had to do with the order in which the variables were set. Try this....

I ran your code and it's not working the way you think it is. When I ran it without modifications, it just added the NAV to the return. ...

I use a free package from ssms tools pack it plugs into SSMS. I can create/modify templates before creating the CRUD procs, so they can be properly documented. ...

to make sure only one row comes back per set