My stance is always function over form with code. But sometimes what works best for one thing may require a different approach for another so understanding how things wokr and...

Can you provide an example of input, walk us thru the intended logic and what the output should be like? Will make it easier to understand your overall goal.

Schema in SQL Server is ownership of objects. More than one user can have a table with the same name in their own schema. You might use this for scratch...

See reply in thread http://www.sqlservercentral.com/Forums/Topic415642-146-1.aspx

The only way you should get dupes with mine is you have multiple dates the same per code. If that is the case then how do you propose to resolve...

UPDATE

A

SET

Price =B.Price

FROM

Table_A A

INNER JOIN

Table_B B

INNER JOIN

(SELECT Code, Max(EFF_DATE) Max_Eff_Date FROM Table_B GROUP BY Code) C

ON

B.Code = C.Code AND

B.EFF_DATE = C.Max_Eff_Date

ON

A.Code = B.Code

Sorry, it has both clarity and should have the speed you want.

Actually I might do this personnally

SET @boo = (CASE

WHEN @gross_pay < 35.17 THEN 0

WHEN @gross_pay < 151 THEN 40

WHEN @gross_pay < 201 THEN 50

WHEN @gross_pay < 251 THEN 60

WHEN...

It is really hard to be hard and fast on this as reusability of tasks within a statement may make them a very good choice especially for reusability. I consider...

The information here might help

http://msdn2.microsoft.com/en-us/library/ms143706.aspx

My experience with seeing this in many large companies as well is there issue is portability of the code. Business are always looking to save a buck or someone comes...

What do you mean. IsDate on a value will return 1 is the value (plus formatting) is acceptable as a date and 0 if not. But if you are talking...

Any method of accessing the data has inheirt risks no matter if QA, SSMS, or a custom GUI. It is all about security management and the ability to handle certain...

You state you created a new table and could reproduce the issue. Can you post the tables DDL so we can see what it looks like.

Just a thought here but how does the data insert within the confines of the tables layout. Consider your indexes and your primary key and how the data would go...