Man, that was a bloody shame.  They actually had some good stuff on there and I can't find hide...

Considering the absolute idiocy that occurred in SQL Server 2012 until the finally fixed {almost} everything they broke in the SPs and CUs prior to SP3 and the SSIS nightmares...

1. Create the procedures that support the reporting with EXECUTE AS OWNER. (This can easily be added existing procs)
2. Create a new role in the reporting database called db_Execute.
3. Grant...

Thanks, Joe.  I appreciate the feedback.  I guess my next question would be rhetorical but I'm thinking it... When was the last time you actually had to port a database?...

I mean I just didn't run just DBCC shrinkfile. This is the complete command I ran for all 8 files but still no luck.

USE [tempdb]
GO
DBCC SHRINKFILE...

Explicitly convert the SKU to something like a VARCHAR(10) using CAST or CONVERT.

Right there with you on the "test the heck out of anything".

To be absolutely honest, I have no idea how you even came across this especially since it's not a...

Heh... or just do it in T-SQL. 😀

BWAAAA-HAAAA-HAAAA!!!!  I'm thinking that this question is the result of someone learning something the hard way! 😀 😀 😀

Great "gotcha" question, Steve!

This is a great introduction to exporting files with PoSh, Steve.  I gave it a 5.  That and the mention of how to do it with DBATools is great.  I...

If you add just one more column to the table, you can avoid the Triangular Joins that are created to calculate things that will not change for a given year. ...

• This reply was modified 6 years, 4 months ago by Jeff Moden. Reason: Double up on the single quotes so that the awful forum software doesn't make it all look like dynamic SQL (and none of it is)

Same back at ya, Lynn.

really annoys me when people don't even bother searching for what they need.

hana studio and Hana client are required - you get those from SAP

first link google returned https://blogs.sap.com/2016/08/05/how-to-connect-microsoft-ssis-with-sap-hana/

yes...

>> Joe, do you convert back to numeric to get your next successive order number and then convert back to character data? With all the back and forth about...

My personal opinion is that people put entirely too much into Calender/DateDim tables.  An example of this is people that store the full name of the days of the week,...