The DATEFROMPARTS function does not work in the 2008 edition.

As an alternative ...

declare @fromDate date, @toDate date ;

select @fromDate=

dateadd(m,0,cast(Cast(year(getdate())-2 as char(4)) as date))

select @toDate = cast(getdate() as...

mugilanoracle (11/29/2016)

---

hi,

please tell me how to export sql server single table into multiple excel sheets in single Excel file using SSIS package.(ex-have region column in source table and have to...

Ed Wagner (11/30/2016)

---

Yes it does....

To answer your third question that would depend on the isolation level of the transaction. You can override the databases default isolation level with something like

set transaction isolation level read...

. So account name of 'EEERT0450' is unique and will be on source and DW. So when I populate the DW, the process would check if that account already exists...

sipas (11/24/2016)

---

"Number 4 works for this year only."

Actually it doesn't even work for this year.

SELECT DATEPART(DAYOFYEAR, SYSDATETIME()); gives 329

SELECT DATEDIFF( DAY, '20160101', SYSDATETIME()); gives 328

Happy Thanksgiving to all in the...

Jeff Moden (11/22/2016)

---

Phil Parkin (11/21/2016)

---

Jeff Moden (11/21/2016)

---

Phil Parkin (11/21/2016)

---

EXCEPT on a 2-million-row resultset is tidier than a column-by-column comparison, but still not to be...

Here too is a resource that can help you get started with graphical execution plans : https://www.mssqltips.com/sqlservertip/1873/how-to-read-sql-server-graphical-query-execution-plans/

There is a button in your SSMS window that displays "include actual execution plan" when you hover over it. You push this button...

Upon further inspection, do you still need the following in the fact table: CounterpartyAccountKey and GenevaAccountKey? I would think these are being replaced with the sourceKey field.

Yes. That appears like a straight forward star schema. One note though is that I would be consistent with the namings. If a column is named sourceKey in the fact...

Interesting that SMALLINT will implicitly convert to INT , but INT wont implicitly convert to BIGINT. Is this the case also with a .NET language like C#?

From what I understand I dont think...

That's how I went about doing it and then had to take a closer...

kevin.obrien 66193 (11/16/2016)

---

The question to the OP is ... are CounterpartyAccountKey and GenevaAccountKey mutualy exclusive? It appears to me from the reading that they may very well be (normally a...