I would  mention two more points when  describing key PostgreSQL / SQL Server trigger differences: PostgreSQL supports Row level triggers and Before triggers.

Most probably
declare @start date = '2016-02-11';
declare @end date = '2016-03-11';

select i.ID, coalesce(sum(datediff(day
            ,case when r.[ReportedDate] < @start then @start else r.[ReportedDate] end...

You may force generation XML elements for NULL values with the XSINIL parameter https://msdn.microsoft.com/en-us/library/ms178079.aspx

WITH XMLNAMESPACES('http://www.w3.org/2001/XMLSchema-instance' as xsi)

SELECT a,z

FROM ( -- sample data

SELECT 1 AS a, NULL AS z

UNION ALL

SELECT...

Headers should be created manually.

WITH t AS ( -- sample data

SELECT 1 AS a

, 2 AS b

, ...

ORACLE still hasn't...

Probably just

DECLARE @test1 TABLE (

MachineID INT

,Timestamp DATE

,Account ...

A possibility exists that ERP's decimal(9) date representation is for example, 20080304? for 03/04/2008. That is 10000*y+1000*m+10*d + ? where ? is day of week or something.

To ensure WHERE predicates...

You may wish to opt for a iTVF or APPLY instead of scalar function for better performance.

No way to avoid explicitly mentioning the parameter name you want to reset in the context of the procedure. So Sp_executesql doesn't help too.

You need explicitly refactor procedures, possibly by...

Can your requirements be stated in terms of entities, their attributes and relationships? It's still quite unclear, to which object admins can add fields and what is the field definition.

sqlnewbie17 (1/14/2016)

---

I need to display in a SQL report the corresponding row/col value in green or red based on the validity of the condition (True/False)

Should I do this logic in...

Sergiy (1/14/2016)

---

Apart from that.

How do you deal with concurrent updates?

If 2 or more users edit the same record in their independent instances of C++ application - which version of the...

Suppose a Weather table has a Temperature column and it's always measured in Fahrenheit. Now someone adds an option to enter Celsius temperature and adds a UnitOfMeasure column ,...

Stijn977 (1/14/2016)

---

All code talking to the DB is C++, most of the data manipulation happens in memory on several application servers, only at set times data gets pushed to the...