Easy.

You need what?

List of customers which have existing orders?

Just ask SQL Server for it!

select * from customer

WHERE EXISTS (select 1 from orders where orders.cust-number = customer.cust-number)

declare @codes varchar(1024)

declare @errcode int

-- select @codes = '' - it's useless

select @errcode = 7

select @codes = ISNULL(@codes + ', ', '') + rtrim(ErrorDesc) -- get rid of...

Such problems usually happen when you mix Unicode data with non-Unicode service characters (tabs, CR/LF, etc.)

Try to inspect your files with binary file viewer.

You missed the point:

Run you full batch with Trace ON and you'll see - no statements are executed.

If total amount of data in your table variable exceeds 1 page (8k) you're in trouble.

FROM item I

WHERE @priceRange IS NULL

OR EXISTS (select 1 from tblPriceRanges R

...

Then everybody else will read it but you...

:hehe:

Carl Federl (6/17/2008)

However, SQL Server has the resulting data type different that specified in BOL as "the result of ROUND to be same type as the numeric expression" but this...

Because travel agencies tell you so...

I'm just not a good typist. 😉

Apart from my laziness...

🙂

When your procedure (or batch ) is being compiled there is no RowID in the table yet.

Quality of some programs makes you wish to be the one.

There are limitations:

- if there are more than 2 OR's/AND's in a query the developer must be warned about inappropriate technics he/she is using;

- if there are more than 10...

If "nickel" means 5c then this would be easier way:

ROUND(Amount/5, 2)*5

For proper precision Amount must be at least MONEY datatype, if not it must be converted to FLOAT first and...

1st rule of programming:

There is no program which cannot be shortened by 1 operator.

🙂