Steve Jones - SSC Editor (7/29/2014)

---

Koen Verbeeck (7/29/2014)

---

The only problem I have with SQLSaturdays is that they are - obviously - on a Saturday 😀

The weekends are off limits as...

jhamilton 47458 (7/29/2014)

---

Our initial thoughts for considering SQL 2014 for the database was to take advantage of updateable columnstore indexes to enhance the performance of our ETL process. Are...

Instead of the console line, try a message box perhaps?

Does everything work if you get rid of the script component?

Is it possible to post the .NET code?

Can you right-click on the arrow before the script component, go to metadata and check the data type of the Data column.

I...

Well, the TRIM function is a string function, so you cannot use it on integer columns.

Your expression can be simplified to this:

ISNULL( [monday_standard_hrs]) ? (DT_I4) 0 : (DT_I4) [monday_standard_mins]

What do you mean with "Real Time project"?

So if it is NULL, you want to convert it to 0?

What problems do you encounter right now?

Interesting question, thanks!

Nice question. I didn't know about the different behaviour between versions.

The only problem I have with SQLSaturdays is that they are - obviously - on a Saturday 😀

The weekends are off limits as I reserve them fully for my family.

Here...

Ah yes, the data type...

INSERT INTO db1.dbo.attendance_details(employee_no,date_of_attendance,present,shift_type,marked_by)

SELECT employee_no,date_of_attendance,present,shift_type,marked_by

FROM db2.dbo.attendance_details

WHERE date_of_attendance IN ('2014-07-01','2014-07-02');

Kimball is great, but Star Schema The Complete Reference is even better.