the brackets INSIDE the quotes means you are looking for the brackets also...that's not what you want.

try this instead:

update address_table

set addr_line_1 = replace(addr_line_1, char(9), ',')

where CHARINDEX(char(9),addr_line_1 ) > 0 --if...

"resetting" their permissions is not a big deal...fairly easyactually, but it's seems iuntimidating if you have not done it before.

say you need a role where they can read/write and also...

Wiki has a good explanation of the format:

http://en.wikipedia.org/wiki/Quicken_Interchange_Format

Well looking at the format of the QIF file, it's not difficult, but it's not easy either.

I've done it the other way...using a utility that converts QIF to comma delimited,and...

you could use the OPENROWSET command to run the proc and insert its resulting data into a table on the fly.

then you can drag the table into a typed dataset...

whodunnit info is contained in the Default Trace, which keeps only a brief history of all DDL changes(CREATE/ALTER/DROP...not SELECT UPDATE DELETE, which is DML statements.

only a limited amount of data...

ugg...i've inherited a couple of situations like this, where a field needs a Decoder Ring to parse out the secret values contained in the field...it's a pain since it doesn't...

what you want to do is create a VIEW that gathers this information on demand, instead of trying to update a static table with the calculations

try this working snippet:

CREATE TABLE...

the key is two parts: including a @query parameter = 1, and making sure the @attach_query_result_as_file = 0;

the only issue is if you wanted it formatted as each value being...

i believe it is because of the correlated subquery, where the inner query getting the TOP 2 is connecting to the outer query:

...

mrpolecat, with windows 2005 and up, you could easily use the row_number() function to get what you are after; you probably knoew that already.

For SQL 2000 it's not so intuitive.

Here's...

well in my case, I might be sending hxkresl@gmail.com,lowell@yahoo.com and jason.stephens @bing.com all the same email....

all those emails are going to be in a table with all my contacts, right?...

it's been a couple of years since this post was active; glad you found it.

since then, i put together a script to check for invalid objects; read this article, grab...

I had wondered why the table had those values...it didn't make any sense to me before, either...loked ugly in the results.

the issue:

the value in the field is a string which...

in my case, each of my profiles mirror the email accout they are going to send from...

without pushing my own sites on you poor saps,

i'd create one named "sqlservercentral"...