the COUNT will always exist, but it might be zero. that's not what you want to test. you want to test if any rows exist

instead just change to if exists...

ok, so is this a find and replace in a paragraph, or are...

i got it, it's the leading char:

/*

NormalConvertBigEndianFinalResults

$1 egaP thgilF rof eeF noitcasnarTTransaction Fee for Flight Page 1

*1 egaP thgilF rof eeF...

ok i'm getting close;

if i switch your values to BigEndian instead of Little, i'm getting your string, but backwards; i cannot seem to get it converted back to the last...

there's a few threads on converting the opposite of this request/; numbers to words

the logic is basically the same, a bunch of find and replaces, the links and code samples...

look at the metadata that is returned from eXEC sp_tables_ex MyAlienServer

it should return a list of items, and you could potentially drill down from there.

briancampbellmcad (6/13/2016)

---

I'm not following the placing of the literal amounts into the SQL. Shouldn't I just be using field names/:

SELECT 100.00, 54215 UNION ALL

SELECT 125.00, 53252 UNION ALL

SELECT 110.00, 63225...

because there is a one to many relationship between charges and payments, you cannot join the tables directly, i think you need to join the summerization of those tables instead....

twin.devel nailed it, and...

Sean Lange (6/10/2016)

---

yay! everyone gets a ribbon for interviewing!

post a new thread with details about what you are trying to do;

you'll get the...

Translate.google.com (Swedish detected)

---

About the company

RGP is an international consulting company that offers qualified consulting services in Finance & Accounting, Human Capital, Information Management and Supply

Chain. We help our customers to...

you need to have an explicit ORDER BY in your query. otherwise, it's coincidence or a crapshoot.

SQL server does not have a concept of order in a table.

SQL will...

i would guess your user is a sysadmin, by mistake or due to mutliple roles.

easy to check:

select IS_SRVROLEMEMBER('sysadmin','mydomain\lowell')

GilaMonster (6/8/2016)

---

Don't try to modify a system object (sys.server_triggers), just query the tables directly (and you don't need that conversion function, so omit the lines that use it). sysschobjs is...