Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rds207
Posting Yak Master
198 Posts |
 Posted - 2009-11-19 : 13:46:47
|
I HAVE 2 TABLESTABLE 1:DW_T_BUILD_VERSIONS-WHICH HAS PHONE BUILD INFORMATIONTABLE 2:DW_T_BATCH_RECORDS-WHICH HAS JOB DEATILSI HAVE TO CREATE A VIEW JOINING THESE 2 TABLES , THE ONLY COLOMNS I CAN MATCH HERE IS PHONE_BUILD AND JOB_NAME , PLEASE FIND THE BELOW LINK FOR THE STRUCTURE OF TEH TABLES AND JOIN CONDITION FOR THE VIEWhttp://download.yousendit.com/ZW9COU1RTXZnYU1LSkE9PQISSUES fACING:1.POOR PERFORMANCE2.UNABLE TO RETRIVE ACCURATE RECORDS(THERE ARE TWO CATEGORIES OF BUILDS 1.TARGET 2.SBA, AN SBA RECORD IS BEING RETRIVED FOR THE TARGET BUILD )PLEASE SEE THE LINK FOR EXCEL SHEET FOR THE SAMPLE DATA , http://download.yousendit.com/ZW9COU1TTk1GOFNGa1E9PQCAN ANYONE SUGGEST A BETTER JOIN CONDITION FOR THE VIEW OR BETTER OPTION TO PARSE THE CHARACTERS AND MATCH JOB_NAME AND PHONE_BUILD..PLEASE EMAIL RDS207@GMAIL.COM , IF THE LINK DOES'NT OPEN...PLEASE HELP .... |
|
|
|
|
|
Better Join Condition