Viewing 13 posts - 1 through 13 (of 13 total)
What I am struggling with the most is whether to add a "Calendar" table, what to populate with and how to maintain it. I think I need one because I...
May 21, 2024 at 4:32 pm
I forgot to include the logical design ! I added it, but is using surrogate keys really that bad? I do have a few alternate keys defined.
To show the access...
May 21, 2024 at 4:46 am
Jeff,
It has not been finalized. The design so far is tool agnostic. I've pushed for SQL Server, but because of costs, it looks like it might be mySQL. We are...
September 14, 2022 at 12:54 am
No, not me. I am an old school developer, working mostly with Oracle in the 90's until 2007 and then retired. And recently decided to switch back to IT after...
September 13, 2022 at 5:37 pm
Jeff,
oh sorry I mistakenly took that link out when I edited it for the error message. Which makes this thread no longer makes sense. And I should have created a...
September 13, 2022 at 3:45 pm
You will need to provide more info in order to get help with this. Include DDL that includes all tables, constraints, in indexes, etc. and it’s not clear whatyour expected output...
September 7, 2022 at 1:29 pm
I figured it out. Instead of creating a parent row group from the detail group, I have to add a group expression to the detail group itself!
SSRS takes some getting...
August 12, 2022 at 11:29 pm
You would Add groupings. Can you provide a schema of the database?
February 10, 2022 at 3:04 pm
Good points about the auditing and class diagrams thanks. Unfortunately some of the leaders are saying the dev and design groups are too busy to work much on providing documentation...
February 10, 2022 at 2:33 pm
Thank you Jeff and Grant for your input!
Yes my conceptual model doc will layout keys, uniqueness, relationships, and attribute rules and constraints. Eventually.
I think one question I had is.... Is...
February 9, 2022 at 2:06 pm
No the database does not exist. I have a conceptual design doc where i have defined several entities based on the UI designs i have seen. I will be elaborating...
February 9, 2022 at 1:44 am
Actually I saw there is another error before this (but I didn't see it because it was listed near the bottom of the log).
Error: The SSIS Runtime has failed to...
October 3, 2020 at 1:06 pm
DB,
your procedure fails because it is expecting a table variable. You need to implement dynamic sql to pass table names.
create or alter procedure test_output @tbl_name varchar(50), @num_rows int = 0...
August 31, 2020 at 5:27 pm
Viewing 13 posts - 1 through 13 (of 13 total)