Viewing 15 posts - 646 through 660 (of 1,114 total)
As you said,
My business logic is:
So you have two diffferents sets of business rules here.
1) All three columns must match
2) At least one column must match
May 29, 2008 at 5:35 am
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67997
Visit the above URL.
May 29, 2008 at 4:33 am
1) Does it work? Are you comfortable with the performance? Then YES is the answer.
2) Yes. LEFT JOIN can be used.
3) Yes.
1) Yes.It is working. But the table is having...
May 29, 2008 at 4:16 am
whether it is a standard junk characters in all the rows or not.
if you post some more rows , then it would be helpful.
May 29, 2008 at 3:17 am
CustomerRegionQuarterSales
123ON11000
12322000
12331500
12343000
222BC15000
I got the above output.
Jeff and rbarryyoung , kindly add your comments, if my approach is wrong.
May 28, 2008 at 4:03 am
mmm... I do agree with Jeff and rbarryyoung , we can do it in presentation Layer.
But we can also do it in Data Layer. Here is the code,
----------------------------------------------------------------------
create table #test
(
Customer...
May 28, 2008 at 4:00 am
My problem is ,
I am unable to undertand how he pronounces words and sentences, but not the entire conversation, only some words , if i miss that words i am...
May 28, 2008 at 3:42 am
I am unable to understand his slang ( whether it may be slang or technical jargon ).
What i am saying is, i can't understand his speech.
May 27, 2008 at 9:21 am
Really, i am very much disappointed ,because my manager abused me for this reason.
May 27, 2008 at 7:59 am
Raja,
if you have free time just go through the link which is referred by Ryan, after that you never think RBAR logic (While or Cursor). Really it will change your...
May 23, 2008 at 5:55 am
Jeff,
I have posted the complete query. Please add your suggestion.
May 21, 2008 at 1:12 am
Viewing 15 posts - 646 through 660 (of 1,114 total)