Peruttu

very simple MS SQL query

Hello

I need a very simple job

I have a table with a field called users, the field contains text and I need to extract a substring

example: content of the field users

"blah blah Account Locked Out: Target Account Name: [url removed, login to view] Target Account ID: [url removed, login to view]\[url removed, login to view] Caller Machine blah blah"

Using SQL for MS SQL server I need to extract the substring [url removed, login to view]

Please note that the [url removed, login to view] has not a fixed length and it could be just in format xxxxx (no dot)

Basically I need to extract what is between "Target Account Name:" and "Target Account ID:"

If you know SQL it is going to be a 10 minutes work

I'll pay no more than 10US$

Thanks and best regards

Taidot: SQL

Näytä lisää: sql server 2005, what is substring, what is job id, substring in c, substring c, c substring, simple mssql query, sql query xml, what is ms sql, sql server job, very, very simple, sql, SQL Query, sql c, simple query, simple account, query table, MS SQL, dom, sql query format, table extract, text sql, format simple, server sql

Tietoa työnantajasta:
( 15 arvostelua ) Syndey, Australia

Projektin tunnus: #456100

18 freelanceria on tarjonnut keskimäärin 31 $ tähän työhön

harissheikh

I have extensive SQL Server knowledge. I can do this for you.

30 $ USD 1 päivässä
(2 arvostelua)
5.4
flashraj

Ok, Agree ...

30 $ USD 1 päivässä
(4 arvostelua)
4.2
netcoder

Hi, I think I can do it:-)! Best regards, netcoder:-)

30 $ USD 1 päivässä
(8 arvostelua)
3.8
ashwin86

check pmb for further details

30 $ USD 0 päivässä
(5 arvostelua)
3.4
kingyond

$10 [url removed, login to view] PMB.

30 $ USD 0 päivässä
(1 arvostelu)
3.0
GhostBear

Please check PMB

30 $ USD 0 päivässä
(1 arvostelu)
1.6
Devlper

I have resolved the given query. made query in SQL server 2005 which can satisfy the given requirement. please accept to see the solution

30 $ USD 1 päivässä
(0 arvostelua)
0.0
methasantosa17

Hi...i can do this for you. Thank you.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
mentallysafe

I just need a rating, read PM please ;) Cheers, MentallySafe

30 $ USD 0 päivässä
(0 arvostelua)
0.0
pahuja12

I can do it for you in 10 $

30 $ USD 1 päivässä
(0 arvostelua)
0.0
nordiym

hi, i can do it.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
jzb

My duty is to provide you reliable and error free work to make a good professional relation.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
hidinesh29

I can get that done for you.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
30 $ USD 1 päivässä
(0 arvostelua)
0.0
zawmgmgmyo

i will try my [url removed, login to view] i'm beginner of freelance project. this is the first time for me.

50 $ USD 5 päivässä
(0 arvostelua)
0.0
astutecoder

Hi .. Please check PM

30 $ USD 0 päivässä
(0 arvostelua)
0.0
Sarsaj

Hello sir,i can do this job very easily... and according to ur budget and time. Thank You.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
alljava

Please check PMB for details

30 $ USD 0 päivässä
(0 arvostelua)
0.0