Another reason not to use EM unless absolutely necessary.

CREATE VIEW dbo.VIEW2

AS

SELECT     CAST(OrderzettelID AS decimal(8, 2)) AS a

FROM     ...

Don't know if this applies for magazines, but for books I buy in the US I have to pay custom. IIRC, some 5 percent.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Can you post what you have done?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

something like this

declare  @test int

set  @test=1



select cast(@test as decimal(8,2))

           

---------- 

1.00



(1 row(s) affected)

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I'm inclined to argue that they don't want to know their own poor programming

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Hey Jeremy, you beat me by almost 2 minutes

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Try using sp_executeSQL. See BOL for further details

..and as always http://www.algonet.se/~sommar/dynamic_sql.html suggested for further reading

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

We need a commonmans section in our community ,

---

what about the 'Anything that....' forum or...

quote:

---

Giving the trend towards electronic publications these days, was there any thought to publish SQLserver Standard electronically? Would allow you to distribute...

I think you can use EXEC and sp_executeSQL in a stored procedure.

However, the advantage of sp_executeSQL is that this one is more likely to reuse execution plans.

As for my standard...

quote:

---

Leave it alone. You can also take some of that excess memory out of this server and insert it into another...

Don't know if I really understand, but I would change theä underlying table structure, if possible and use separate columns for inches and feet. This way you don't run into...

The query optimizer makes its decision based on probability. And can therefore sometime make wrong decisions.

To see if and how the hint can improve performance run your queries with...

WMP War & Mobilization Plan ????

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Welcome onboard!

Feel free to ask questions

Frank

http://www.insidesql.de

http://www.familienzirkus.de