Ok, then it's due to my english knowledge. I missed the 'in' and understood it as 'for'. 🙂

Please clear it up for me. Why isn't an option to create a procedure. If i'm using that SQL snippet from an application with different parameters, i'd surely create a...

• This reply was modified 5 years, 5 months ago by  palotaiarpad.

Datatype precedence!! :ermm:
Where is my coffee, please! 😀

Actually not only money type can be initialized this way. It works at any type where an implicit conversion from 0.00 is available, as select \; returns...

Would never guess. It seams to be illogical for me. 🙂

Compressed backups have CHECKSUM by default or is the BOL wrong? Or is it too early and i have to wake up first?

I don't think you wanna do what you wrote in the trigger. You should find a unique column or a set of columns in your table to use in the...

But we are restoring on a new instance and not on the same one. Or am i understanding something wrong?

Is it a typo?

The only proper answer would be:
SIGN(n)*FLOOR(ABS(n))

In my opinion there is no right answer to choose.
If we are using CEILING instead of FLOOR we will scrap the result of 'Coffee'. The FLOOR(ABS()) is a much...

In my opinion RTO is playing a role as well, for example in live data collection systems, where downtime is very critical.

select * from
(
SELECT COUNTY.CountyName,ORDERS.UserDate2 AS LastCovered, FSLog.CompletedDate, property.State, ROW_NUMBER() over (partition by COUNTY.CountyName order by ORDERS.UserDate2 desc) as ordering

FROM ORDERS
INNER...