TOP

sql join not right table

Select *
From ORD
Where ORD_ID Not In
(Select ORD_ID From EXPORTED)

http://miniburb.wordpress.com/2007/05/31/sql-outer-join-vs-where-not-in-vs-not-exists/

Read More
TOP

Sql Right Join Example

http://www.roseindia.net/sql/sql-right-join.shtm

SQL RIGHT JOIN Syntax

The SQL RIGHT JOIN Syntax display you all the records from the right table, even there are no matches with the left table. The Syntax used for SQL RIGHT OUTER JOIN is given below:

SELECT column_name(s) FROM table_name1 right JOIN table_name2 ON table_name1.column_name=table_name2.column_name

Use Right JOIN in SQL Query

The Example shows you the RIGHT JOIN in SQL Query. In this  Example, we use RIGHT OUTER JOIN, which displays the records from two tables. The table contain return all record from table1,even there are no matches with the table 2.

select s.stu_id, s.stu_name, s.stu_class, l.lib_no from stu_table as s Right JOIN lib_table as l on l.stu_id = s.stu_id

Result

Stu_Id Stu_Name Stu_Class Lib_No
1 Komal 10 101
2 Ajay 10 102
3 Rakesh 10 103
4 Bhanu 10 104
5 Santosh 10 105
NULL NULL NULL 106
NULL NULL NULL 107
Read More
TOP

SQL where field has a numeric value

SELECT *
FROM [Web_HearstSalesForce].[dbo].[zRAW_Wave2] where ISNUMERIC(F1)=1

Read More
TOP

SQL update join

UPDATE B
SET
B.[LAST_RECRUIT_PRINT_DATE] = A.[LAST_RECRUIT_PRINT_DATE],
B.[LAST_RECRUIT_ONLINE_DATE] = A.[LAST_RECRUIT_ONLINE_DATE]
FROM
[Web_HearstSalesForce].[dbo].[VW_AccountsRecruit_320] A,
[Web_HearstSalesForce].[dbo].[Accounts] B
WHERE A.AccountNumber=B.AccountNumber

Read More
TOP

SQL insert select

/* Add new record — new salerep */

INSERT INTO [salesreps].[dbo].[salesreps]
(sales_no,empno,supervisor,
supervisorext,deptno,bonusteam,
admarcteam,title,LName,FName,
wkphone,hmphone,pager,mobile,
fax,hmaddress,city,state,zip,sls_mgr,
app_mgr,dept_mgr,dept_director,cls_director,
adv_vp,office,uid,comments,submitdate)
SELECT
sales_no,empno,supervisor,
supervisorext,deptno,bonusteam,
admarcteam,title,LName,FName,
wkphone,hmphone,pager,mobile,fax,
hmaddress,city,state,zip,sls_mgr,
app_mgr,dept_mgr,dept_director,
cls_director,adv_vp,office,uid,
comments,submitdate
FROM
[salesreps].[dbo].[salesreps_1]
WHERE sales_no IN
(
SELECT A.sales_no as salesno
FROM [salesreps].[dbo].[salesreps_1] A
left outer join
[salesreps].[dbo].[salesreps] B
on A.sales_no=B.sales_no
where B.sales_no is null
)

Read More
TOP

SQL split fullname

Example: #1

SELECT fullname ,reverse (substring(reverse(fullname),1,charindex(‘ ‘, reverse(fullname)))) as LName, substring(fullname,1,charindex(‘ ‘, fullname)) as FName
FROM [salesreps].[dbo].[salesreps_1]

Example: #2

SELECT fullname ,substring(fullname,charindex(‘ ‘, fullname), LEN(fullname)) as LName,
substring(fullname,1,charindex(‘ ‘, fullname)) as FName
FROM [salesreps].[dbo].[salesreps_1]

Read More
TOP

SQLCMD Examples

SQLCMD – Examples
sqlcmd Switches
-S >> ServerName
-D >> DatabaseName
-U >> UserName
-P >> Password
-Q >> Query
-o >> OuputFile

sqlcmd -SSQL2005_FIRST -Ucalyan -Pcalyan
-dDatabaseName -Q”select * from sampledata”

sqlcmd -SSQL2005_FIRST -Ucalyan -Pcalyan
-dDatabaseName -Q”select * from sampledata” -o”c:\sampledata.txt”

sqlcmd -SSQL2005_FIRST -Ucalyan -Pcalyan
-dDatabaseName -Q”EXEC MYPROC1″

sqlcmd -SHOME-CB\SQL2005_FIRST -Ucalyan -Pcalyan
-dDatabaseName -Q”exec msdb.dbo.sp_start_job @job_name = ‘TestJob’”

Read More
TOP

SQL OPENQUERY INSERT

insert into openquery(UW_2011,’SELECT txtEmpID,txtLastName,txtFirstName,txtMI,txtCompany,txtDepartment,
numContribution2011,numContribution2012,txtPaymentMethod,txtAddress1,txtAddress2,txtCity,txtState,txtZip,
txtEMail,txtWritAck,txtLeadership,txtAgencyDesig,txtDesigAck,txtResponding,FollowUpEmail,
ContributionDate,IPAddress,Minutes,txtYoungLeader,txtWomens,txtExactName,txtPhone,DD FROM tblEmpInfo’)

insert into openquery(
UW_2011,’SELECT Departments FROM tblDepartments’)
VALUES (’8608 PROFESSIONAL DEVELOPMENT’);

insert into openquery(
UW_2011,’SELECT Departments FROM tblDepartments’)
VALUES (’7006 PRINTING PROJECTS’);

insert into openquery(
UW_2011,’SELECT Departments FROM tblDepartments’)
VALUES (’6204 SINGLE COPY SALES NORTH 5946′);

insert into openquery(
UW_2011,’SELECT Departments FROM tblDepartments’)
VALUES (’4605 PRESSROOM’);

********************

insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79514′,’MEGAN’,'J’,'HEBERT’,’8007 PRODUCTIVITY/PROCESS IMPROVE.’,’1829 BERING DRIVE #1′,’HOUSTON’,'TX’,’77057′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79331′,’PATRICIA’,'K’,'HART’,’3000 EDITORIAL ADMINISTRATION’,’1504 HARDOUIN AVE’,'AUSTIN’,'TX’,’78703′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’62729′,’ANITA’,'X’,'HASSAN’,’3400 CITY DESK’,’3807 FALL BRANCH DRIVE’,'KATY’,'TX’,’77450′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78511′,’MICHAEL’,'S’,'MORRIS’,’3400 CITY DESK’,’1434 CHAMBOARD LANE’,'HOUSTON’,'TX’,’77018′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78444′,’MICHAEL’,'R’,'PAULSEN’,’3801 PHOTOGRAPHERS’,’1807 1/2 MORSE STREET’,'HOUSTON’,'TX’,’77019′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78834′,’DIDIER’,'S’,'MORAIS’,’3424 SPORTS SECTION’,’5401 CHIMNEY ROCK ROAD #1000′,’HOUSTON’,'TX’,’77081′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79109′,’NICHOLAS’,'E’,'MATHEWS’,’3424 SPORTS SECTION’,’1218 POWDER HOUSE DR.’,'NEWPORT NEWS’,'VA’,’23608′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’53731′,’SIMONE’,'M’,'SEBASTIAN’,’3425 BUSINESS SECTION’,’201 S. HEIGHTS BLVD.’,'HOUSTON’,'TX’,’77007′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’74986′,’PETER’,'J’,'HOLLEY’,’3600 FEATURES’,’2315 SUNSET BLVD.’,'HOUSTON’,'TX’,’77005′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80083′,’MELANIE’,'L’,'SPENCER’,’3600 FEATURES’,’305 HADLEY ST. #4334′,’HOUSTON’,'TX’,’77002′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80109′,’LINDSEY’,'J’,'LOVE’,’3600 FEATURES’,’516 SOUTH POST OAK LANE’,'HOUSTON’,'TX’,’77056′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80925′,’ROBERT’,'J’,'VAN EPP’,’8200 FINANCIAL ACCOUNTING’,’66 N. BUCK RIDGE’,'THE WOODLANDS’,'TX’,’77381′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79715′,’RICKY’,'L’,'BRYANT JR’,’8635 INFORMATION TECHNOLOGY’,’13710 WAVERLY CREST CT’,'CYPRESS’,'TX’,’77429′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81162′,’ANCLEAH’,'L’,'FULLER’,’8635 INFORMATION TECHNOLOGY’,’2602 SHADY SPRINGS COURT’,'PEARLAND’,'TX’,’77584′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81014′,’ELIZABETH’,'A’,'GONZALES’,’8639 REVENUE ACCOUNTING’,’8801 GLENCREST #6181′,’HOUSTON’,'TX’,’77061′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78424′,’JEFF’,'X’,'CASTRO’,’8647 HEARST WEB DEVELOPMENT’,’7707 SILENT STAR COURT’,'HOUSTON’,'TX’,’77095′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78454′,’AJAY’,'M’,'GAUTAM’,’8647 HEARST WEB DEVELOPMENT’,’1818 AUGUSTA DR #4′,’HOUSTON’,'TX’,’77057′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79306′,’CHRISTOPHER’,'H’,'BOYD’,’8647 HEARST WEB DEVELOPMENT’,’1024 E 16TH ST’,'HOUSTON’,'TX’,’77009′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80650′,’JONATHAN’,'B’,'OLSON’,’8647 HEARST WEB DEVELOPMENT’,’1614 HILLENDAHL BLVD’,'HOUSTON’,'TX’,’77055′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79100′,’JAMES’,'C’,'PEACOCK IV’,’8151 SYSTEMS OPERATIONS & SUPPORT’,’218 SPRINGS EDGE DRIVE’,'MONTGOMERY’,'TX’,’77356′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80419′,’ALEXANDER’,'O’,'NWORJI’,’8151 SYSTEMS OPERATIONS & SUPPORT’,’11206 ASHFORD HILLS DR’,'SUGARLAND’,'TX’,’77478′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79420′,’MARTIN’,'R’,'CALDERA’,’8153 COMMUNICATIONS & NETWORKING’,’8942 HERON NEST DRIVE’,'HOUSTON’,'TX’,’77064′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79584′,’MICHAEL’,'H’,'SIGMAN’,’4713 TRANSPORTATION SERVICES’,’6707 LYNNGATE DR’,'SPRING’,'TX’,’77373′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79589′,’TRACY’,'L’,'KARNS’,’4713 TRANSPORTATION SERVICES’,'P.O. BOX 1245′,’SOUTH HOUSTON’,'TX’,’77587′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79614′,’WARREN’,'A’,'WHITE’,’4713 TRANSPORTATION SERVICES’,’8502 NORTHTON ST’,'HOUSTON’,'TX’,’77029′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80225′,’GLENN’,'X’,'SANCO’,’4713 TRANSPORTATION SERVICES’,’3923 KANSAS’,'FRESNO’,'TX’,’77545′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78380′,’KATE’,'T’,'MEADE’,’4006 PPC PRINTING’,’21337 THURSTON CROSSING DRIVE’,'PORTER’,'TX’,’77365′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78546′,’AMY’,'L’,'LAFARGUE’,’4006 PPC PRINTING’,’3807 HOUSTON LAKE DRIVE’,'PEARLAND’,'TX’,’77581′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78956′,’ALEXANDER’,'W’,'CURTIS’,’4201 AD PRODUCTION’,’7503 APACHE PLUME DRIVE’,'HOUSTON’,'TX’,’77071′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78962′,’GEORGINA’,'X’,'MONDSHINE’,’4201 AD PRODUCTION’,’1710 WEST T.C. JESTER’,'HOUSTON’,'TX’,’77008′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78388′,’AMY’,'E’,'BARRON’,’4400 SWP PRESSROOM’,’415 W. POLK ST.’,'HOUSTON’,'TX’,’77019′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78390′,’KAREN’,'M’,'POSADAS RAMIREZ’,’4400 SWP PRESSROOM’,’6837 ARBOR HOLLOW LN.’,'DICKINSON’,'TX’,’77539′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’40952′,’BLAKE’,'G’,'MENDENHALL’,’7003 ONLINE ADMINISTRATION’,’2414 COUNTY ROAD 90′,’PEARLAND’,'TX’,’77584′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78552′,’VICTOR’,'R’,'COLLINS’,’7003 ONLINE ADMINISTRATION’,’17530 TALL MAPLE COURT’,'HOUSTON’,'TX’,’77095′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79107′,’MEGAN’,'V’,'HUNTOON’,’7003 ONLINE ADMINISTRATION’,’28022 EMERALD OAKS DR’,'MAGNOLIA’,'TX’,’77355′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81226′,’KELLY’,'N’,'WILKERSON’,’7003 ONLINE ADMINISTRATION’,'P.O. BOX 670332′,’HOUSTON’,'TX’,’77267′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81227′,’KEMLA’,'K’,'MELANCON’,’7003 ONLINE ADMINISTRATION’,’2254 GEMINI’,'HOUSTON’,'TX’,’77058′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81304′,’MICHAEL’,'W’,'CHUMCHAL’,’7003 ONLINE ADMINISTRATION’,’21331 HAWKLEG’,'RICHMOND’,'TX’,’77406′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78425′,’ALYSSA’,'M’,'JAISLE’,’7005 NICHE PRODUCTS’,’2350 BAGBY ST. APT 11203′,’HOUSTON’,'TX’,’77002′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78553′,’NATHAN’,'X’,'FAVAROTH’,’7005 NICHE PRODUCTS’,’19002 OWEN OAK DRIVE’,'HUMBLE’,'TX’,’77346′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79218′,’LAURIE’,'M’,'TRUESDALE’,’7005 NICHE PRODUCTS’,’8223 MAGNOLIA GLEN DR’,'HUMBLE’,'TX’,’77346′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80092′,’SUZANNE’,'M’,'SENEGAL’,’7005 NICHE PRODUCTS’,’1330 OLD SPANISH TRAIL 2109′,’HOUSTON’,'TX’,’77054′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80295′,’JOHNNIE’,'D’,'DILLARD’,’7005 NICHE PRODUCTS’,’28511 EAST BENDERS LANDING’,'SPRING’,'TX’,’77386′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80806′,’JWANA’,'S’,'CARSON’,’7005 NICHE PRODUCTS’,’1303 GREENS PKWY #810′,’HOUSTON’,'TX’,’77067′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78328′,’ROLANDO’,'G’,'MARTINEZ’,’7006 PRINTING PROJECTS’,’11607 GLENWOLDE DRIVE’,'HOUSTON’,'TX’,’77099′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78332′,’JUAN’,'C’,'VASQUEZ’,’7006 PRINTING PROJECTS’,’1255 N POST OAK RD’,'HOUSTON’,'TX’,’77055′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78657′,’MICHAEL’,'T’,'GANNON’,’7006 PRINTING PROJECTS’,'P.O. BOX 2102′,’LEAGUE CITY’,'TX’,’77574′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79108′,’AUBREE’,'A’,'GERARDI’,’7006 PRINTING PROJECTS’,’931 W. 25TH ST UNIT C’,'HOUSTON’,'TX’,’77008′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79293′,’JARRET’,'E’,'HUGHES’,’7006 PRINTING PROJECTS’,’9889 CYPRESSWOOD DR #8302′,’HOUSTON’,'TX’,’77070′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79307′,’LAURA’,'H’,'MALFER’,’7006 PRINTING PROJECTS’,’16610 BOBCAT TRAIL’,'CYPRESS’,'TX’,’77429′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79419′,’JONAH’,'I’,'NAULLS’,’7006 PRINTING PROJECTS’,’3505 STANFORD STREET’,'HOUSTON’,'TX’,’77006′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79476′,’KATRINA’,'N’,'ROUNDTREE’,’7006 PRINTING PROJECTS’,’8919 KETCHWOOD DRIVE’,'HOUSTON’,'TX’,’77099′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79672′,’CHRIS’,'W’,'GIANAKOS’,’7006 PRINTING PROJECTS’,’12815 CAREYWOOD DR’,'SUGARLAND’,'TX’,’77478′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80153′,’LOUISE’,'C’,'BAUM’,’7006 PRINTING PROJECTS’,'P. O. BOX 346′,’STAFFORD’,'TX’,’77497′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81336′,’JACLYN’,'A’,'READER’,’7006 PRINTING PROJECTS’,’938 OXFORD’,'HOUSTON’,'TX’,’77008′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81659′,’NORMAN’,'C’,'BENDER’,’7006 PRINTING PROJECTS’,’1711 BRIARMOOR CT’,'HOUSTON’,'TX’,’77062′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81662′,’WILBERT’,'X’,'MERCADO’,’7006 PRINTING PROJECTS’, ’2721 JEB STUART DR’,'LEAGUE CITY’,'TX’,’77573′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’1692′,’WILLIE’,'E’,'VIVERETTE’,’7103 AD SUPPORT’,’6023 IRONSIDE TURN’,'HOUSTON’,'TX’,’77053′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’2148′,’BESSIE’,'M’,'GREEN’,’7103 AD SUPPORT’,’5008 FAIRVENT ST’,'PASADENA’,'TX’,’77505′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78975′,’STEPHEN’,'L’,'SHANNON’,’7103 AD SUPPORT’,’10018 SAGEASPEN LANE’,'HOUSTON’,'TX’,’77089′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78976′,’MICHAEL’,'P’,'MURPHY’,’7103 AD SUPPORT’,’1818 CALYPSO COVE CT’,'SEABROOK’,'TX’,’77586′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80377′,’TRESSA’,'A’,'BARZILLA’,’7210 DISPLAY ADVT-WESTCHASE’,’710 BERING DRIVE #K’,'HOUSTON’,'TX’,’77057′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78581′,’LINDA’,'N’,'TRAN’,’7211 WOODLANDS/S. MONTGOMERY CO.’,’13806 BINK COURT’,'HOUSTON’,'TX’,’77014′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78804′,’KIMBERLY’,'E’,'TOLAR’,’7211 WOODLANDS/S. MONTGOMERY CO.’,’217 ADOBE TERRACE NORTH’,'MONTGOMERY’,'TX’,’77316′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80552′,’LUCILLE’,'M’,'KROGMAN’,’7211 WOODLANDS/S. MONTGOMERY CO.’,’13719 AMSBURY LN’,'CYPRESS’,'TX’,’77429′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81015′,’LAUREN’,'M’,'HODGES’,’7211 WOODLANDS/S. MONTGOMERY CO.’,’19614 BRENTONRIDGE LN’,'SPRING’,'TX’,’77379′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81507′,’PAMELA’,'A’,'ELDER’,’7211 WOODLANDS/S. MONTGOMERY CO.’,’1215 GLEN HOLLOW DR’,'HUMBLE’,'TX’,’77338′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78306′,’DEREK’,'R’,'PETERSON’,’7212 DISPLAY ADVT-NORTH CENTER’,’25115 CALICO WOODS’,'KATY’,'TX’,’77494′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78371′,’KRISTA’,'E’,'JACOCKS’,’7212 DISPLAY ADVT-NORTH CENTER’,’3206 ANN ARBOR DRIVE’,'HOUSTON’,'TX’,’77063′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’13598′,’CYNTHIA’,'A’,'SMEDSTAD’,’7213 DISPLAY ADVT-SOUTH CENTER’,’2800 E. LEAGUE CITY PKWY #311′,’LEAGUE CITY’,'TX’,’77573′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80294′,’DAVID’,'A’,'BERCOVICH’,’7213 DISPLAY ADVT-SOUTH CENTER’,’2425 SAGE ROAD #79′,’HOUSTON’,'TX’,’77056′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78207′,’RENEE’,'M’,'BUNCH’,’7214 HOUSE MAJORS – 5128′,’4715 BROADMOOR DRIVE’,'LEAGUE CITY’,'TX’,’77573′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’20476′,’STEVEN’,'L’,'KNOTT’,’7400 NATIONAL ADVERTISING’,’3711 REAGAN #2′,’HOUSTON’,'TX’,’77009′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78427′,’NANCY’,'K’,'FOWLER’,’7400 NATIONAL ADVERTISING’,’6330 WOODBROOK LANE’,'HOUSTON’,'TX’,’77008′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78584′,’RHONDA’,'K’,'WARREN’,’7400 NATIONAL ADVERTISING’,’1146 HARVARD STREET’,'HOUSTON’,'TX’,’77008′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79024′,’JASON’,'W’,'SABAYRAC’,’7400 NATIONAL ADVERTISING’,’2027 CUTTER RD’,'LEAGUE CITY’,'TX’,’77573′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81218′,’DANA’,'M’,'HARDEMAN’,’7608 EMPLOYMENT’,’3519 PLUM VALLEY’,'KINGWOOD’,'TX’,’77339′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81303′,’ROBERT’,'D’,'CRAVARITIS’,’7608 EMPLOYMENT’,’26118 ALLENFORD COURT’,'KATY’,'TX’,’77494′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79754′,’PAMELA’,'X’,'CARRALES’,’7609 REAL ESTATE’,’16938 CLAN MACINTOSH’,'HOUSTON’,'TX’,’77084′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80077′,’HEATHER’,'M’,'BRINKLEY’,’7609 REAL ESTATE’,’7550 KIRBY DR #313′,’HOUSTON’,'TX’,’77030′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78179′,’VIRGINIA’,'X’,'MARTINEZ’,’7610 CONTACT CENTER’,’11522 CARLA STREET’,'HOUSTON’,'TX’,’77076′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78907′,’NICHOLAS’,'P’,'FRIZZELL’,’7610 CONTACT CENTER’,’12414 NARCISSUS VIEW TRAIL’,'HOUSTON’,'TX’,’77089′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79479′,’STEPHEN’,'A’,'GISSENDANNER’,’7610 CONTACT CENTER’,’4617 ORANGE CIRCLE N’,'PEARLAND’,'TX’,’77581′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80324′,’SHELLANE’,'T’,'NEWELL’,’7610 CONTACT CENTER’,’7910 FALL HOLLOW DR’,'HOUSTON’,'TX’,’77041′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78550′,’FRANK’,'C’,'CARUSO’,’7611 CLASSIFIEDS-AUTOMOTIVE’,’5927 ALMEDA’,'HOUSTON’,'TX’,’77004′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78852′,’KEVIN’,'F’,'MIMS’,’7611 CLASSIFIEDS-AUTOMOTIVE’,’4022 KRISTEN LEE COURT’,'HOUSTON’,'TX’,’77014′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79012′,’NATHASCHA’,'M’,'GRAVES’,’7611 CLASSIFIEDS-AUTOMOTIVE’,’6203 PEBBLE CANYON CT’,'KATY’,'TX’,’77450′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81219′,’BRANDON’,'J’,'BURAS’,’7611 CLASSIFIEDS-AUTOMOTIVE’,’115 W. 10TH ST’,'HOUSTON’,'TX’,’77008′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79291′,’REYMUNDO’,'R’,'GAMEZ’,’7830 ONLINE BUS DEV/TECH’,’418 ROCHELLE DR’,'VICTORIA’,'TX’,’77905′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’79673′,’TOMMY’,'Q’,'MA’,’7833 DIGITAL AD SERVICES’,’13342 AVONSHIRE’,'HOUSTON’,'TX’,’77083′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80646′,’THOMAS’,'W’,'LOPEZ’,’7833 DIGITAL AD SERVICES’,’3615 FIR FOREST DR’,'SPRING’,'TX’,’77388′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81716′,’WILLIAM’,'J’,'RIGNEY’,’7833 DIGITAL AD SERVICES’,’19401 TOMBALL PKWWY #622′,’HOUSTON’,'TX’,’77070′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’11470′,’DIRON’,'R’,'OVERBY’,’6221 CITY-NORTH’,’15814 MEDINA LAKE’,'CYPRESS’,'TX’,’77429′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’69049′,’PATRICIA’,'L’,'DRYE’,’6221 CITY-NORTH’,’658 FATHOM DR’,'SAN MATEO’,'CA’,’94404′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80904′,’SARIKA’,'V’,'BHOSALE’,’6221 CITY-NORTH’,’2402 HENDRICKS LAKE DR’,'SPRING’,'TX’,’77388′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80906′,’GLORIA’,'J’,'KERNS’,’6221 CITY-NORTH’,’11407 LOYOLA DR’,'CYPRESS’,'TX’,’77429′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80907′,’STEPHANIE’,'D’,'LANDRY’,’6221 CITY-NORTH’,’11339 WALNUT MEADOWS’,'HOUSTON’,'TX’,’77066′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80910′,’ROBERT’,'K’,'WELCH’,’6221 CITY-NORTH’,’3307 NORTH SUTTON SQUARE’,'STAFFORD’,'TX’,’77477′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80926′,’STEPHANIE’,'L’,'SIMS’,’6221 CITY-NORTH’,’11023 SAGEVALE’,'HOUSTON’,'TX’,’77089′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80943′,’RANI’,'M’,'FIGUEROA’,’6221 CITY-NORTH’,’10506 MIST LN’,'HOUSTON’,'TX’,’77070′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80947′,’DAVID’,'B’,'MCBRIDE’,’6221 CITY-NORTH’,’20315 NORTHOAKS DRIVE’,'HOUSTON’,'TX’,’77073′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80948′,’JUDY’,'A’,'MCFARLAND’,’6221 CITY-NORTH’,’435 NORTHPINES DRIVE #434′,’KINGWOOD’,'TX’,’77339′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80949′,’VALARIE’,'J’,'MARCHBANKS’,’6221 CITY-NORTH’,’14173 N.W. FWY #215′,’HOUSTON’,'TX’,’77040′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80951′,’MARK’,'L’,'HAYS’,’6221 CITY-NORTH’,’2522 CARRIAGE LANE’,'STAFFORD’,'TX’,’77477′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80953′,’ESTELA’,'M’,'MEJIA’,’6221 CITY-NORTH’,’2947 RISING SUN DR’,'KATY’,'TX’,’77449′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80957′,’DOROTHY’,'S’,'PUGLISI’,’6221 CITY-NORTH’,’6758 SHINING SUMAR AVE’,'HOUSTON’,'TX’,’77084′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’80962′,’VISHWAS’,'G’,'BHOSALE’,’6221 CITY-NORTH’,’2402 HENDRICK LAKES’,'SPRING’,'TX’,’77388′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81002′,’GEORGE’,'M’,'COX III’,’6221 CITY-NORTH’,’1941 HILLSHIRE DRIVE’,'DEER PARK’,'TX’,’77536′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81003′,’REGINALD’,'D’,'HANKINS’,’6221 CITY-NORTH’,’1802 WINDING CREEK DRIVE’,'PEARLAND’,'TX’,’77581′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81004′,’WEN’,'F’,'LOH’,’6221 CITY-NORTH’,’1838 OAK VALLEY DRIVE’,'KEMAH’,'TX’,’77565′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81011′,’MICHAEL’,'A’,'REYES’,’6221 CITY-NORTH’,’4810 CREPE MYRTLE LN’,'PASADENA’,'TX’,’77505′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81013′,’TERRY’,'E’,'WILLIAMS’,’6221 CITY-NORTH’,’4624 LARKSPUR’,'HOUSTON’,'TX’,’77051′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81019′,’RONALD’,'E’,'RICHTER’,’6221 CITY-NORTH’,’5739 WIGTON’,'HOUSTON’,'TX’,’77096′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81021′,’KISMET’,'X’,'COLLEY’,’6221 CITY-NORTH’,’6202 PECAN WOOD’,'HOUSTON’,'TX’,’77088′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81024′,’STEVEN’,'J’,'THOMPSON’,’6221 CITY-NORTH’,’4927 RIDGE HARBOR DRIVE’,'HOUSTON’,'TX’,’77053′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81025′,’JANIE’,'M’,'CRITTLE’,’6221 CITY-NORTH’,’5111 PINEWILDE DR’,'HOUSTON’,'TX’,’77006′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81029′,’QUAN’,'M’,'NGUYEN’,’6221 CITY-NORTH’,’8218 WORTHINGTON DRIVE’,'HOUSTON’,'TX’,’77083′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81036′,’JOSEPH’,'W’,'NORMAN JR.’,’6221 CITY-NORTH’,’10506 MIST LANE’,'HOUSTON’,'TX’,’77070′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81039′,’MICHAEL’,'C’,'EMANIS’,’6221 CITY-NORTH’,’12811 JOLIET ST.’,'HOUSTON’,'TX’,’77015′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81041′,’MALCOLM’,'A’,'CONEO’,’6221 CITY-NORTH’,’8208 CONSTELLATION’,'HOUSTON’,'TX’,’77075′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81042′,’SHELLEY’,'D’,'ROSIGNON’,’6221 CITY-NORTH’,'P O BOX 680628′,’HOUSTON’,'TX’,’77268′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81071′,’SCOTT’,'M’,'CONEO’,’6221 CITY-NORTH’,’8202 CONSTELLATION’,'HOUSTON’,'TX’,’77075′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81074′,’DARRYL’,'F’,'MURRAY’,’6221 CITY-NORTH’,’6432 DUCKETT PARK DR’,'HOUSTON’,'TX’,’77086′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81076′,’ADRIAN’,'N’,'FISHER’,’6221 CITY-NORTH’,’3333 PALM ST’,'HOUSTON’,'TX’,’77004′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81102′,’DANNY’,'R’,'MOGOLLON’,’6221 CITY-NORTH’,’17906 HARBOUR BRIDGE PT DR’,'CYPRESS’,'TX’,’77429′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81153′,’LYNDA’,'M’,'LOWE’,’6221 CITY-NORTH’,’8811 MOOR PARK LN’,'HOUSTON’,'TX’,’77064′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81154′,’JAIME’,'X’,'SANTIAGO’,’6221 CITY-NORTH’,’20810 DEWBERRY CREEK LN’,'KATY’,'TX’,’77449′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81158′,’EVANS’,'K’,'BROWNE II’,’6221 CITY-NORTH’,’5143 CANYON BLANCO’,'HOUSTON’,'TX’,’77045′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81159′,’PAUL’,'C’,'SNOWDEN’,’6221 CITY-NORTH’,’2400 OLD SOUTH DRIVE #2521′,’RICHMOND’,'TX’,’77406′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81161′,’JAMES’,'J’,'LEWANDOWSKI’,’6221 CITY-NORTH’,’10511 CUTTING HORSE LANE’,'HOUSTON’,'TX’,’77064′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81163′,’RONNIE’,'L’,'NEWMAN’,’6221 CITY-NORTH’,’9701 MEYER FOREST #11309′,’HOUSTON’,'TX’,’77096′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81166′,’JOSE’,'F’,'PINEDA’,’6221 CITY-NORTH’,’8727 WILSON REID’,'HOUSTON’,'TX’,’77040′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81215′,’JAKARRA’,'Y’,'WADE’,’6221 CITY-NORTH’,’17817 CLUSTER CT’,'SPRING’,'TX’,’77379′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81216′,’KENTON’,'R’,'BARNETT’,’6221 CITY-NORTH’,’14230 BEAU HARP’,'HOUSTON’,'TX’,’77049′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81217′,’REBECCA’,'L’,'MARKETTO’,’6221 CITY-NORTH’,’10300 CYPRESSWOOD DR #2235′,’HOUSTON’,'TX’,’77070′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81332′,’JOHN’,'A’,'VIGIL’,’6221 CITY-NORTH’,’12003 NORTH LANE CIR’,'HOUSTON’,'TX’,’77086′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81335′,’JOHN’,'M’,'CAVE’,’6221 CITY-NORTH’,’1901 LAKESIDE DR APT 406′,’SEABROOK’,'TX’,’77586′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81437′,’DELFORD’,'J’,'GEORGE’,’6221 CITY-NORTH’,’1310 HEIGHTS’,'EL CAMPO’,'TX’,’77437′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81448′,’AZHAR’,'A’,'ABEDI’,’6221 CITY-NORTH’,’14551 BEECHNUT #8105′,’HOUSTON’,'TX’,’77083′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81483′,’AHMED’,'X’,'MANSOUR’,’6221 CITY-NORTH’,’1915 ROARING SPRINGS DR’,'PEARLAND’,'TX’,’77584′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81497′,’CHRISTOPHER’,'B’,'AMMONS’,’6221 CITY-NORTH’,’14607 S. BROOKS RD’,'CONROE’,'TX’,’77302′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81506′,’JONATHAN’,'B’,'RHEA’,’6221 CITY-NORTH’,’6402 GRAND CYPRESS LANE’,'KATY’,'TX’,’77449′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81509′,’SAM’,'R’,'WILSON’,’6221 CITY-NORTH’,’4903 FALLS CIRCLE’,'MISSOURI CITY’,'TX’,’77459′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81528′,’CHARLES’,'E’,'GWOSDZ’,’6221 CITY-NORTH’,’1100 FOX MEADOW #133′,’ALVIN’,'TX’,’77511′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81589′,’CONRAD’,'K’,'FRANCIS’,’6221 CITY-NORTH’,’16138 BARBAROSSA DR’,'HOUSTON’,'TX’,’77083′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81606′,’NIA’,'L’,'GLAZE’,’6221 CITY-NORTH’,’2340 SPERBER LANE’,'HOUSTON’,'TX’,’77003′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81607′,’JEWL’,'B’,'JOHNSON’,’6221 CITY-NORTH’,’4011 SPRING MEADOW DRIVE’,'PEARLAND’,'TX’,’77584′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81637′,’KYLE’,'C’,'BOWMAN’,’6221 CITY-NORTH’,’901 E. 40TH ST #211′,’AUSTIN’,'TX’,’78751′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81661′,’TRACY’,'L’,'DANIELS’,’6221 CITY-NORTH’,’3603 CHESAPEAKE COURT’,'PEARLAND’,'TX’,’77584′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’81763′,’ROY’,'C’,'MANLEY’,’6221 CITY-NORTH’,’6115 PLANTATION FOREST’,'KATY’,'TX’,’77449′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);
insert into openquery(UW_2011,’SELECT txtEmpID,txtFirstName,txtMI,txtLastName,txtDepartment,txtAddress1,txtCity,txtState,txtZip,txtCompany,txtEMail FROM tblEmpInfo’) VALUES (’78326′,’CHAD’,'A’,'CARPENTER’,’8406 SALES & MARKETING ADMIN’,’2950 OLD SPANISH TRAIL #363′,’HOUSTON’,'TX’,’77054′,’334 HOUSTON CHRONICLE’,'HERE–EMAIL’);

********************

Read More
TOP

SQL: Select Where IN

select * from cadcus where alt_addr1!=’‘ and csurr in
(select csurr from cadord where qrysched like ‘JOB%HI%’)

Read More
TOP

SQL – Using GROUP BY to collapse rows

select distinct SILVERPOP__LEAD__C, MAX(SILVERPOP__OPEN_DATE_TIME__C)
from meSilverPop GROUP by SILVERPOP__LEAD__C

Read More

Switch to our mobile site