Your signature (Jassim) points to a site seems to be commercial... It is not really accepted here and can cause you to be banned for spamming...
Please remove it (or restore it to its previous value - your personal site)!
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
The instructor table looks a bit odd to me, having both ID and InstructorID I would assume you meant InstructorID and InstructorName.
And as an addition to what Mycroft said, in a fully normalized database you always use the same name for an entity throughout the database. It's not just a good idea, it's a standard[^].
And just like Mycroft said, for a surrogate key, using <tablename> + "ID" is a good idea
if OP put it in the Lounge they'd get flamed by many.
I don't see why, as it is not a programming question, more a general request for opinions and experiences. Plenty of similar discussions appear in the Lounge. I know these forums are titled "Discussions", but in reality they are for asking Technical Questions.
Ignore Richard and the bastard, this is an appropriate question in the correct forum.
Unfortunately your question is a little too broad to elicit a reasonable response. SSIS is such a wide subject.
I do know that we moved from ETL to ELT where the transforms are done via stored procedure. It is faster and I find it easier to debug and test. So SSIS just moves the data from the source into staging tables and launches the transform stored proc.
Never underestimate the power of human stupidity
Hello there. First let me give the 3 tables' definitions then I ask question.
In 3rd table, you can see that I am using boolean column which tells whether this Order belongs to guest user or member user. I want to select corresponding data using ONE QUERY. Here is what I have tried so far but it is far from working
SELECT O.*, CASE WHEN O.IsUserMember = 1 THEN U.UserName ELSE M.MemberName END <br />
FROM Orders O, CASE WHEN O.IsUserMember = 1 THEN Users U ELSE Members M END <br />
WHERE CASE WHEN O.IsUserMember = 1 THEN O.UserId = U.UserId ELSE B.UserId = M.MemberId END;<br />
It is giving me this following error: Syntax error near 'CASE WHEN B.IsThisUserMember = 1 THEN Users U ELSE Members M END WHERE CASE WHEN' at line 1
NOTE: If I remove first CASE condition, then I get empty set. Thanks for whatever you share.
Last Visit: 31-Dec-99 19:00 Last Update: 2-Mar-21 13:23