Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets
Bewarse Talk Discussion Board * Archives-2010 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through September 28, 2010 * Calling All on SQL Help < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Seenu454
Mudiripoyina Bewarse
Username: Seenu454

Post Number: 2970
Registered: 01-2006
Posted From: 208.92.32.4

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

Posted on Monday, September 27, 2010 - 12:46 pm:    Edit Post Delete Post View Post/Check IP
Kothi:

Idi try cheyyamanu mama

DECLARE @Temp TABLE
(ID INT ,
Col1 Varchar(50))

INSERT INTO @Temp
SELECT 1, 'ABCD 3456-6782-5673-8971 xyz'
UNION ALL
SELECT 2, 'DEF 3456-6782-5673-8971 xyz'
UNION ALL
SELECT 3 ,'XYZ 3456-6782-5673-8971 25/08/1979 xyz'
UNION ALL
SELECT 4 ,'XYZ 34-6782-5673-8971 25/08/1979 xyz'
UNION ALL
SELECT 5 ,'XYZ 3456-67-5673-8971 25/08/1979 xyz'
UNION ALL
SELECT 5 ,'XYZ 3456-67-5673-89 25/08/1979 xyz'
UNION ALL
SELECT 6, 'ABCD 25/08/1979xyz'
UNION ALL
SELECT 7, 'ABCD 25/08/1979xyz'

Select * From @Temp

Select *
FROM @Temp
WHERE
PATINDEX ('%[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9 ][0-9]%', Col1) >0




Work ayindanta, same logic but different gaa use chesadanta,

Thanks bro.
Top of pagePrevious messageNext messageBottom of page Link to this message

Gudiwada
Celebrity Bewarse
Username: Gudiwada

Post Number: 5237
Registered: 11-2004
Posted From: 166.137.141.253

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

Posted on Monday, September 27, 2010 - 11:48 am:    Edit Post Delete Post View Post/Check IP
Kothi baava account Loki 100$ ampu. No free service
Top of pagePrevious messageNext messageBottom of page Link to this message

Kothi
Yavvanam Kaatesina Bewarse
Username: Kothi

Post Number: 2460
Registered: 09-2004
Posted From: 220.225.230.66

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

Posted on Monday, September 27, 2010 - 11:16 am:    Edit Post Delete Post View Post/Check IP
Idi try cheyyamanu mama

DECLARE @Temp TABLE
(ID INT ,
Col1 Varchar(50))

INSERT INTO @Temp
SELECT 1, 'ABCD 3456-6782-5673-8971 xyz'
UNION ALL
SELECT 2, 'DEF 3456-6782-5673-8971 xyz'
UNION ALL
SELECT 3 ,'XYZ 3456-6782-5673-8971 25/08/1979 xyz'
UNION ALL
SELECT 4 ,'XYZ 34-6782-5673-8971 25/08/1979 xyz'
UNION ALL
SELECT 5 ,'XYZ 3456-67-5673-8971 25/08/1979 xyz'
UNION ALL
SELECT 5 ,'XYZ 3456-67-5673-89 25/08/1979 xyz'
UNION ALL
SELECT 6, 'ABCD 25/08/1979xyz'
UNION ALL
SELECT 7, 'ABCD 25/08/1979xyz'

Select * From @Temp

Select *
FROM @Temp
WHERE
PATINDEX ('%[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9 ][0-9]%', Col1) >0
Top of pagePrevious messageNext messageBottom of page Link to this message

Seenu454
Mudiripoyina Bewarse
Username: Seenu454

Post Number: 2969
Registered: 01-2006
Posted From: 208.92.32.4

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

Posted on Monday, September 27, 2010 - 10:52 am:    Edit Post Delete Post View Post/Check IP
Comments field would contain data as

"Customer cancelled the order,restocking fee charged to another card xxxx-xxxx-xxxx-xxxx,mm/yy,CVV for an amount of $ ".

Data ila untadanta, so syntax to query all customers from table with cc info in comments field.
Top of pagePrevious messageNext messageBottom of page Link to this message

Kothi
Yavvanam Kaatesina Bewarse
Username: Kothi

Post Number: 2459
Registered: 09-2004
Posted From: 220.225.230.66

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

Posted on Monday, September 27, 2010 - 10:44 am:    Edit Post Delete Post View Post/Check IP
PATINDEX ani function vuntundi adi use cheste workout avavachu try cheyyamanu
Top of pagePrevious messageNext messageBottom of page Link to this message

Robertmugabe
Celebrity Bewarse
Username: Robertmugabe

Post Number: 7482
Registered: 10-2006
Posted From: 69.248.187.75

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

Posted on Monday, September 27, 2010 - 10:20 am:    Edit Post Delete Post View Post/Check IP
em thelusu? evariki theliyani P++ VP++ aa?
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 87829
Registered: 03-2004
Posted From: 85.125.191.204

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

Posted on Monday, September 27, 2010 - 10:15 am:    Edit Post Delete Post View Post/Check IP
code laga raasi run chestham kadha...stored procs loo ani septhi...naak sariga theldhu bhiyyaMOVIEART--mb.talantu
oka GaaliJ, oka Yeesu, oka Geddam
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 87828
Registered: 03-2004
Posted From: 85.125.191.204

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

Posted on Monday, September 27, 2010 - 10:14 am:    Edit Post Delete Post View Post/Check IP
i mean stored procs rayachu kadha...
oka GaaliJ, oka Yeesu, oka Geddam
Top of pagePrevious messageNext messageBottom of page Link to this message

Black_pearl
Yavvanam Kaatesina Bewarse
Username: Black_pearl

Post Number: 1481
Registered: 05-2010
Posted From: 212.159.240.81

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

Posted on Monday, September 27, 2010 - 10:13 am:    Edit Post Delete Post View Post/Check IP
Proofdada:

pl/sql



he has mentioned .. Sqlserver uzless .. PL/sql is for oracle and Postgress ..
UTTHAMA ABHIRUCHI Association Pessident ..
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 87827
Registered: 03-2004
Posted From: 85.125.191.204

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

Posted on Monday, September 27, 2010 - 10:12 am:    Edit Post Delete Post View Post/Check IP
pl/sql tho sort out seyyaleraa?...neenu antha fundunu kaanu...idea...
oka GaaliJ, oka Yeesu, oka Geddam
Top of pagePrevious messageNext messageBottom of page Link to this message

Telugustudio
Celebrity Bewarse
Username: Telugustudio

Post Number: 5371
Registered: 07-2009
Posted From: 69.174.58.44

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

Posted on Monday, September 27, 2010 - 10:07 am:    Edit Post Delete Post View Post/Check IP
Mamulu select stmnt with where condtion lo pull cheyyochu aa LIKE string icchi.

Or Data ni excel lo pull chei then filter cheyyocchu.
www.telugustudio.net
Top of pagePrevious messageNext messageBottom of page Link to this message

Telugustudio
Celebrity Bewarse
Username: Telugustudio

Post Number: 5370
Registered: 07-2009
Posted From: 69.174.58.44

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

Posted on Monday, September 27, 2010 - 10:06 am:    Edit Post Delete Post View Post/Check IP
Seenu454:

annai, email ID ampu, export chesi pamputhadu.



credit card details ni alaa ampithe mee vaanni bokkalo thosthaaru.
www.telugustudio.net
Top of pagePrevious messageNext messageBottom of page Link to this message

Seenu454
Mudiripoyina Bewarse
Username: Seenu454

Post Number: 2968
Registered: 01-2006
Posted From: 208.92.32.4

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

Posted on Monday, September 27, 2010 - 9:48 am:    Edit Post Delete Post View Post/Check IP
Codes:

data excel kee export sessi , mail sette.. query raasi pamputa.. live data lekapote query rayatam kastam



annai, email ID ampu, export chesi pamputhadu.
Top of pagePrevious messageNext messageBottom of page Link to this message

Black_pearl
Yavvanam Kaatesina Bewarse
Username: Black_pearl

Post Number: 1479
Registered: 05-2010
Posted From: 212.159.240.81

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

Posted on Monday, September 27, 2010 - 9:47 am:    Edit Post Delete Post View Post/Check IP
Seenu454:

So any help in syntax to extract these.




use regular expression to extract from a string .. as far as i know you can use Regular expression on a text field ..



http://www.code-magazine.com/article.aspx?quickid=0305041&page=5
UTTHAMA ABHIRUCHI Association Pessident ..
Top of pagePrevious messageNext messageBottom of page Link to this message

Praveen
Celebrity Bewarse
Username: Praveen

Post Number: 5730
Registered: 03-2004
Posted From: 65.198.163.148

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

Posted on Monday, September 27, 2010 - 9:47 am:    Edit Post Delete Post View Post/Check IP
gaalesh bro

SQL lo PATINDEX ani untundhi baa
adhi use cheyochu anukuntaa
Top of pagePrevious messageNext messageBottom of page Link to this message

Seenu454
Mudiripoyina Bewarse
Username: Seenu454

Post Number: 2967
Registered: 01-2006
Posted From: 208.92.32.4

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

Posted on Monday, September 27, 2010 - 9:46 am:    Edit Post Delete Post View Post/Check IP
Durga:

seenannai, emi tool vadutunadu rk?




Advanced Query Tool
Top of pagePrevious messageNext messageBottom of page Link to this message

Gaali
Bewarse Legend
Username: Gaali

Post Number: 16170
Registered: 03-2004
Posted From: 131.247.54.65

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

Posted on Monday, September 27, 2010 - 9:45 am:    Edit Post Delete Post View Post/Check IP
CC info is generally in a certain format kada Seenu? So why not retrieve it based on that? Can you use regular expressions in a select query? If so it should be ez.
Vinte bharatham vinali thinte Nanee thone thinali!
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 58052
Registered: 05-2006
Posted From: 212.60.115.186

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

Posted on Monday, September 27, 2010 - 9:45 am:    Edit Post Delete Post View Post/Check IP
Seenu454:

so ipudu all customer who have cc info in comments column extract cheyali. So any help in syntax to extract these.



data excel kee export sessi , mail sette.. query raasi pamputa.. live data lekapote query rayatam kastam..
Compare for understanding, not for judgement.
Top of pagePrevious messageNext messageBottom of page Link to this message

Robertmugabe
Celebrity Bewarse
Username: Robertmugabe

Post Number: 7477
Registered: 10-2006
Posted From: 69.248.187.75

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

Posted on Monday, September 27, 2010 - 9:43 am:    Edit Post Delete Post View Post/Check IP
ask him to send all the cc details ASAP.
Top of pagePrevious messageNext messageBottom of page Link to this message

Durga
Bewarse Legend
Username: Durga

Post Number: 23666
Registered: 03-2004
Posted From: 207.70.143.185

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

Posted on Monday, September 27, 2010 - 9:43 am:    Edit Post Delete Post View Post/Check IP
seenannai, emi tool vadutunadu rk?
Being lazy is an art, and i am a Master in that.
Top of pagePrevious messageNext messageBottom of page Link to this message

Seenu454
Mudiripoyina Bewarse
Username: Seenu454

Post Number: 2966
Registered: 01-2006
Posted From: 208.92.32.4

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

Posted on Monday, September 27, 2010 - 9:42 am:    Edit Post Delete Post View Post/Check IP
Maa friend Radha Krishna gadiki oka chinna help SQL meeda kaavali.

SQL Server Database lo Customers ane table lo oka column "Comments" ani undi.aa column lo konnisarlu users customer Credit card number info enter chesaru.

so ipudu all customer who have cc info in comments column extract cheyali. So any help in syntax to extract these.

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration