Viewing 15 posts - 301 through 315 (of 1,838 total)
There is another common pattern to solving this question, to use a CROSS APPLY, e.g.
...
FROM Items i
CROSS APPLY (SELECT TOP 1 statuscode FROM ItemStatus s...
July 11, 2019 at 6:04 pm
I'd have to agree with Jeff's comments about the "non-developer staff" doing ETL. While there are typically a small handful of true power users who understand what they need to...
July 11, 2019 at 5:50 pm
After all of these questions on Python and R... I'm glad I don't have to use Python or R! 🙂
July 10, 2019 at 3:27 pm
I think where I'm at we tend to "loose" the comments in our VCS because the developers feature branch everything, so unless you know what branch the change was actually...
July 8, 2019 at 4:08 pm
Not related to the error the original poster is receiving, but of note, the intended formula is probably:
price * amount
not
price + amount
I'd say the error though is because of the...
July 1, 2019 at 8:04 pm
...Can you elaborate on what you mean by roles/groups? We utilize database roles which specify what objects to give permissions to. However, a new user might not need access...
June 27, 2019 at 5:56 pm
The SSIS engine is a part of the SQL Server Developer Edition bundle, so it would fall under the same licensing terms. Use that instead of your Enterprise key. Developer...
June 27, 2019 at 5:41 pm
Do you guys run EVERYTHING that goes into production through QA/UAT, or do you trust some users if they have a proven track record of high scores, and only...
June 26, 2019 at 9:22 pm
...So if I use synonyms instead of views (and the reporting tools use those instead of the views behind-the-scenes), what would the synonyms themselves point to so that I...
June 21, 2019 at 4:36 pm
...I'm currently restoring a backup of one of our production databases on another server daily...it serves as the source database for this ETL process I'm writing.
...My latest thought is...
June 21, 2019 at 4:34 pm
If SQL Server had a BULK EXPORT command like they have a BULK IMPORT command I'd agree it was overkill, but the only way to export results to a delimited...
June 21, 2019 at 3:49 pm
have you looked at the OLEDB provider for Visual Foxpro?
https://www.microsoft.com/en-us/download/details.aspx?id=14839
I have used that before to read Visual Foxpro files, and even files from the old FoxPro 2.6 for DOS
June 14, 2019 at 6:59 pm
I ran into the same problem this past winter trying to upgrade an aging tower machine that was perfectly good. Drivers weren't available for some of the hardware, so...
June 14, 2019 at 5:00 pm
June 14, 2019 at 1:58 pm
I suppose my Windows experience was a little different than Steve's, I actually liked Windows 98 second edition better than Windows 95 as long as I turned off all the...
June 13, 2019 at 8:32 pm
Viewing 15 posts - 301 through 315 (of 1,838 total)