k.allen.emt (1/25/2015)
Phil,=) sorry, thanks I will give it a shot.
Beyond new here in this, my buddy tossed me his MySQL book "The Language of SQL" and said read.
Thank you again... also I was a bit lost on trying to obtain data for you guys with
SELECT 'SELECT '
+ QUOTENAME(ID,'''')+','
+ QUOTENAME(phone_number,'''')+','
+ QUOTENAME(first_name,'''')+','
+ QUOTENAME(last_name,'''')+','
+ QUOTENAME(address1,'''')+','
+ QUOTENAME(address2,'''')+','
+ QUOTENAME(address3,'''')+','
+ QUOTENAME(city,'''')+','
+ QUOTENAME(state,'''')+','
+ QUOTENAME(postal_code,'''')+','
+ QUOTENAME(HOME_OWNR,'''')+','
+ QUOTENAME(HH_INCOME,'''')+','
+ QUOTENAME(CREDIT_RATING,'''')+','
+ QUOTENAME(AGE,'''')+','
+ QUOTENAME(source_id,'''')+','
+ QUOTENAME(title,'''')+','
+ QUOTENAME(comments,'''')+','
+ QUOTENAME(dnc_flag,'''')+','
+ QUOTENAME(provider,'''')+','
+ QUOTENAME(vehicle,'''')+','
+ QUOTENAME(coverage,'''')+','
+ QUOTENAME(alt_phone,'''')+','
+ QUOTENAME(email,'''')+','
+ QUOTENAME(marital_status,'''')+','
+ QUOTENAME(dob,'''')
+ ' UNION ALL'
FROM leads
Running that reports:
[Err] 1305 - FUNCTION leaddb.QUOTENAME does not exist
If you're working with MySQL, you may fare better posting your problem in a MySQL forum rather than a SQL Server 2014 forum.
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]