Hardest proc? Its the report proc where 10 different managers want their department's performance statistics to outperform all other departments. And the final version needs approved by all...

-- this better not be a school homework problem

UPDATE b

SET begin_date = a.setup_date

from tableA a

JOIN tableB b ON a.cust_code = b.cust_code AND a.proj_code = b.proj_code

WHERE b.begin_date IS NULL

;

As a development DBA who designs for projects exclusively using one philosophy or the other, I can say that GUID PKs are vastly superior to the non-ANSI Identity PKs in...

Interesting! I think I'd prefer a conversion table with lots of columns such as conversion type (area, mass, etc), long names, abbreviations, descriptions, SI standard names, accepted approximate conversion...

My frustration with SQLComplete is due to being unheard month after month. I submitted these as bugs and enhancements many times. Their consistent canned response is to upgrade...

For those considering buying SQL Complete from dbforge DevArt, I'd just like to say that I've been having serious issues with it for the past year and they do not...

CELKO (12/4/2014)

---

The correct terms are "referenced" and "referencing" tables in RDBMS; "parent" and "child" are from network databases. They have meaning when following pointer chains. The use of bit...

I did some Azure stuff a couple years ago so forgive me if I've forgotten something important. Last year I switched a whole database from int to guid primary...

Maybe some programmers will appreciate my attempt at a simpler version.

DECLARE @i int, @c varchar(10);

SET @i = 133;

SET @c = RIGHT('0000000000'+CAST(@i AS varchar(10)),10);

SELECT @c,

REPLICATE('M',CAST(LEFT(@c,7) AS int))

+CASE substring(@c,8,1) WHEN '1' THEN...

I'd love to see INSERT/EXECUTE have the ability to designate which resultset to insert.

How interesting! Knowing the last datetime SELECTed is irrelevant to me but I think I might be able to use the last_user_update column as a way to know when...

Does anyone have an answer for this? I strictly control all ANSI settings so that is not the issue for me. I have a similar problem with deleting...

I can't really see what you're trying to do. Maybe try this:

SELECT

wo.id as 'WORKSORDER',

wo.partid as 'PART',

ro.machine as 'PROCESS',

bom.bomqty as 'RATIO',

wo.actualstartdate as 'STARTDATE',

wo.actualfinishdate as 'ENDDATE',

DATEDIFF(MINUTE,actualstartdate,actualfinishdate) / 60.0 as 'TOTAL RUNTIME',

wo.actualbookedtime...

I just learned the hard way how to "move" rows from one table to another 3x faster. I'm migrating rows from a heap table with a nonclustered PK on...

If it is an OLTP database, I suggest you updated the current status in a transaction table and have its trigger write history rows to a statuses table. That...