Topics | Search Log Out | Register | Edit Profile
Hide Clipart | Banned/Unbanned User Log | Moderator Login History | Thread Delete/Move Log | Last 30 mins | 1 | 2
Calling T-SQL Experts

Chalanachithram.com DB » New TF Industry Related » Archive through September 07, 2015 » Calling T-SQL Experts « Previous Next »
Author Message
 

Sesani
Megastar
Username: Sesani

Post Number: 29131
Registered: 08-2014
Posted From: 69.114.186.198

Rating: N/A
Votes: 0 (Vote!)

Posted on Sunday, September 06, 2015 - 10:53 am:       
Telangana - SQL aa
 

Abhysg
Megastar
Username: Abhysg

Post Number: 25342
Registered: 08-2008
Posted From: 166.216.165.118

Rating: N/A
Votes: 0 (Vote!)

Posted on Sunday, September 06, 2015 - 10:37 am:       
Dolling...emi anukovaddu..

We are kulling...
 

Gandhiguevara
Legend
Username: Gandhiguevara

Post Number: 54997
Registered: 10-2009
Posted From: 68.52.124.39

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, September 05, 2015 - 11:10 pm:       
Abcdefghij:

try rank

 

Abcdefghij
Hero
Username: Abcdefghij

Post Number: 16958
Registered: 02-2007
Posted From: 99.59.193.29

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, September 05, 2015 - 10:39 pm:       
try rank
Post by Knf: bittter annai, welcome RS prakasam varaku madi, Prakasm nunchi UA vaaraku meeedi
http://www.chalanachithram.com/cgi-bin/discus/show.cgi?tpc=115&post=5144373#POST5144373
 

Gandhiguevara
Legend
Username: Gandhiguevara

Post Number: 54995
Registered: 10-2009
Posted From: 68.52.124.39

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, September 05, 2015 - 10:18 pm:       
deduplication effort annatlu
Conditions:
1) only one record per person, if there are 2 rows, the row with 'Event_DT not null' result set lo vundaali
2) Only record vundi Event_DT NULL vunnaa load avvali
 

Gandhiguevara
Legend
Username: Gandhiguevara

Post Number: 54994
Registered: 10-2009
Posted From: 68.52.124.39

Rating: N/A
Votes: 0 (Vote!)

Posted on Saturday, September 05, 2015 - 10:15 pm:       
ID Name START_DT END_DT Event_DT Description COLX COLY COLZ
101 Gannayya April 1st 2015 April 3rd 2015 NULL Nee Bonda BLAH BLAH BLAH
101 Gannayya April 1st 2015 April 3rd 2015 April 2nd 2015 Nee Bonda BLAH BLAH BLAH
102 Punnayya April 8th 2015 April 12th 2015 NULL Nee Bonda raa nee bonda BLAH BLAH BLAH
103 Mannayya Aug 1st 2015 Aug 8th 2015 Aug 4th 2015 Poraa puski BLAH BLAH BLAH
104 Devayya Sept 2nd 2015 Sept 4th 2015 Sep 3rd 2015 kikiki BLAH BLAH BLAH
104 Devayya Sept 2nd 2015 Sept 4th 2015 NULL kikiki BLAH BLAH BLAH


Result Set

101 Gannayya April 1st 2015 April 3rd 2015 April 2nd 2015 Nee Bonda BLAH BLAH BLAH
102 Punnayya April 8th 2015 April 12th 2015 NULL Nee Bonda raa nee bonda BLAH BLAH BLAH
103 Mannayya Aug 1st 2015 Aug 8th 2015 Aug 4th 2015 Poraa puski BLAH BLAH BLAH
104 Devayya Sept 2nd 2015 Sept 4th 2015 Sep 3rd 2015 kikiki BLAH BLAH BLAH

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image HASH(0x8b413a4){Movie Clipart}
Show / hide regular icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Show / Hide Filmy icons selection options

Click on following links to open cliparts by Alphabetical Order

  A   B   C   D   E   F   G   H   I   J   K   L   M  

N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Username: Posting Information:
This is a public posting area. Enter your username and password if you have an account. Otherwise, enter your full name as your username and leave the password blank. Your e-mail address is optional.
Password:
E-mail:
Options: Enable HTML code in message
Automatically activate URLs in message
Action: