Thanks

I used OUTPUT parameters a lot in Oracle so I think I should be able to get it to work

there's always BOL, too

🙂

My vice is more work-related. I am way too impatient to move on to something new and consequently am really bad at testing.

if you are at a shop with applications written and implemented look at the stored procedures that were written for them

the downside to that is that you may pick up...

Ha! nice to see someone has a sense of humor :hehe:

btw, the lead programmer here is still smarting over your suggestion he should "put his hands on the table...

I would caution about the use of DISTINCT, though

we have an application here which tries to find a DISTINCT key using a multiple table JOIN from one table to put...

how about using a table variable, inserting your data in there, then inserting the sorted table variable into the permanent table?

doesn't SQL Server 2008 have a MERGE capability?

If you really need to, create a table variable then SELECT that INTO #temp

i.e.

DECLARE @Table TABLE

(ID INT,

Field1 VARCHAR(20) etc)

then

INSERT INTO @Table (ID, Field1...

The answer to the question, are triggers useful, is as always it depends. I currently work with an application riddled with triggers (some with RBAR) and in an earlier...

my bad, then

is Wikopedia protected intellectual property?

A lakh (also written lac) is a unit in the Indian numbering system equal to one hundred thousand (100,000; 105). It is widely used both in official and other contexts...

what's a lakhs?

potato pancake?

bodies of water?

is missing and really needs?

thanks to Jeff and Lowell

- I cut and pasted examples to add to my useful scripts

actually, since I have been soooo disciplined - defining StringBuilders and initializing them as EXECUTE sp I can do a global search for EXECUTE

and find the stored procedures that way

any...

if your proc is not too large, isn't it faster to make it

DECLARE @strSQL NVARCHAR(MAX)

SELECT @strSQL = kode FROM table

EXECUTE sp_executesql @strSQL