|
It's really a Lounge discussion subject, it's not a technical question.
|
|
|
|
|
Richard MacCutchan wrote: Lounge discussion subject, Could be, but I would bet if OP put it in the Lounge they'd get flamed by many.
Richard MacCutchan wrote: it's not a technical question. It's a good topic for discussions, which is what these forums are, discussions. However, I now notice that at the top of the discussions forum it says "how to ask a question."
Personally, I see QA as quick questions with direct answers and these discussion forums for discussions. I found it very appropriate.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
RyanDev wrote: 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.
|
|
|
|
|
RyanDev wrote: Where would you suggest posting a discussion on SSIS? The Lounge.
RyanDev wrote: Is there a forum that you think is more appropriate than this one? Nope. Are you suggesting we need a new forum for SSIS or tools?
Just wondering how this would reflect on the C# forum, and no, I don't have a decent answer.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: need a new forum for Tools? No, we already have Facebook, er, I mean the Lounge.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
"The Lounge" was answered in jest, but it should be allowed there; it's not a programming question.
The C# forum would become a very broad subject if we discussed/accepted each utility available.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Not sure why you were downvoted but I think this is a great discussion topic. I upvoted to help counter it.
I used SSIS very little, thank goodness.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
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
RAH
|
|
|
|
|
1] What should I write in Timeout Attribute to achieve maximum timeout limit ?
2] Is there any change needs to make in IIS6 ?
3] What is the maximum limit ?
<authentication mode="Windows"><forms loginUrl="~/Account/Login.aspx" timeout=""/>
|
|
|
|
|
0 = unlimited timeout
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
|
put Maximum value in timeout value timeout=100000
|
|
|
|
|
Hello there. First let me give the 3 tables' definitions then I ask question.
Users
UserId
UserName
Members
MemberId
MemberName
Orders
OrderId
UserId
IsUserMember
ItemName
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
<br />
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.
|
|
|
|
|
I don't do MySql but it should probably be like this:
WHERE (O.UserId = U.UserId AND O.IsUserMember = 1) OR (B.UserId = M.MemberId AND O.IsUserMember = 0)
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
You're looking for a LEFT JOIN :
SELECT
O.*,
CASE
WHEN O.IsUserMember = 1 THEN U.UserName
ELSE M.MemberName
END As Name
FROM
Orders O
LEFT JOIN Users U
ON U.UserId = O.UserId And O.IsUserMember = 0
LEFT JOIN Members M
ON M.MemberId = O.UserId And O.IsUserMember = 1
;
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
When putting this code section, what language you used in PRE tag? I could not find out how to proper format and paste SQL queries in codeproject. thnx
|
|
|
|
|
<pre lang="SQL">
...
</pre>
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I have got a side-question: shouldn't IsUserMember be a column in the Users table rather than in the Orders one? Is it possible that a specific user is considered as a member for an order, and not a member for another one?
(just curious)
Loneliness and cheeseburgers are a dangerous mix.
|
|
|
|
|
phil.o wrote: Is it possible that a specific user is considered as a member for an order, and not a member for another one?
Users represent guest users. Members represent registered users. There are online businesses out there which allow you to shop either as guest user or first register and then continue as member.
Having said this, I am not a DB guru. I just started working in it with more serious attitude. Any flaw you see in my design, please let me know.
|
|
|
|
|
Django_Untaken wrote: Users represent guest users. Members represent registered users.
But, at the end, they are all users, whether they are registered or not. You do not have any "Members" table.
Is it possible that a specific user (so, only one user id), can order as registered user once, and then as unregistered user later (or the contrary)?
Again, I do not know the details of your requirements; I may be wrong, as I may miss something important.
Kindly
Loneliness and cheeseburgers are a dangerous mix.
|
|
|
|
|
Hi,
I am thinking of building a custom SSIS Flat File Source component which extends the default Flat File Source component which ships with SSIS. Is there anyway so that I can reuse the code of the Flat File Source component which SSIS provides and then override the methods using my custom logic? Or is there no other option but to start from scratch?
Specifically, what I'm looking for is- being able to override the methods of the Flat File Source pipelinecomponent
AND
being able to inherit the UI of the component so that I can extend it.
|
|
|
|
|
Hi CodeProject members,
Greetings!
After being a passive reader of CodeProject articles for so long a time, it feels great to be actively contributing something to this thriving and extremely helpful community.
Recently, I decided to undertake the task of explaining some relatively complex concepts of T-SQL, SQL Server and MSBI, in an effort to give back something to the community I have been learning from for so long.
My goal is to simplify the explanation and elucidation of the concepts as much as possible, at the expense of being annoyingly verbose if need be.
To this effect, I started with explanation of a recursive Common Table Expression in t-SQL. My article can be found at [Recursive CTE]
Now this is my first attempt at explaining something in writing. I need feedback-, how have I fared overall, suggestions for improvement, possible topics for later etc.
Thus, I am sincerely hoping, active community members would help me out in this regard. I have tried explaining the recursive CTE concept to the best of my ability here. But of course, often one's best is still lacking in some respects. Please come forth with your comments and feedback.
Could I have used a better example to explain the concept?
Could I have used better formatting for the code snippets? Or the result-sets?
How could I have ensured that this article is as helpful as possible to a person who is finding it difficult to grasp the recursive CTE concept?
Looking forward to hearing from you.
|
|
|
|
|
It is bad form to try and promote your article in the forums. You will get feedback when people read your article.
|
|
|
|
|
Sigh! I thought I have already been through all this with one person.
Look. I wanted to post my message only once. At one place. But when I get confronted with a message like 'Message Removed', what is a newbie like me supposed to think? That maybe this isn't the right place to post a message like this. This happened to me when I went to post the message elsewhere too. Therefore the repetition.
|
|
|
|
|
You are not a newbie, you have been a member over 7 years. Plenty of time to read the stickies at the top of each forum.
|
|
|
|