Although I know the value this article can represent you can actually be far more generic than you suggest.

You can write an SP that given the Source Table or View,...

Hi.

Firstly I am not trying to dispute the actual solution you are providing. In fact, I came across the phenomenon several years ago (by accident) but never found a...

I think You are looking for something like:

select

Object_Name( Object_Id)

, *

from sys.indexes

Maybe I should say it this way.

Good practice is to always check for nulls

so

If ( @a <> @b-2 ) Print 'Not Equal'

Else If (@A =@B )...

@a is not equal to the number in

What you want is

where fCompany = ?

Then you would do the parameter mapping linking the "?" to a DTS Variable

Matching Column Name A in Table 1 to Column B in Table 2 is not really that difficult BUT

as the previous poster mentioned that gives no indication as to whether...

Float and real data types are noted as approximate values. use decimal or numeric with fixed lengths of decimal places for accurate numbers

I use a variation on that syntax but found that the performance issue depends a lot on the table sizes that the parameters are used against, i.e

If param...

A bit more work but nothing major

select * From master.sys.All_objects where type = 'p' etc

Nice....That is an interesting way to get a random number i.e. newID combined with checksum()....

I like it

HI.

I too, would Love to know why you would do this, but I had more fun writing the solution that performs reasonably well on a million rows. Maybe it...

HI.

I too, would Love to know why you would do this, but I had more fun writing the solution that performs reasonably well on a million rows. Maybe it...

Just to Play devils advocate...

At the lowest level even "set based" queries are handled at a row by row level:D

Think about updating running totals with the

var=col=var +cnt

syntax

(goes and...