Questions related to query optimization, finding complex results.
Experience in the area: I have been working in the field since 2005 year. Education/Credentials: BE IT, First Class, 2005 Batch.
BE IT, India
Its changing everyday and so one can get many things to learn.
The pronunciation of the word "SQL" is sequel or S Q L, which is more official?, as Microsoft it self sometimes say sequel, is still a mystery for me.
Dear Santhosh, If we have yo query a table from Database B in the Database A, what we write is Select * from B.do.TableName in a query pan of A database. Instead a synonym pointing to B.do.TableName
Dear Santosh, It generally happens when the database has those objects as synonyms. Synonyms are a pointer for SQL database. Read more about those, its good read. Feel free to follow-up
Dear Kristin, This is an example of a need where we want to use SELF JOIN. First find all first and last name which have I9 form and get all except those guys. This might work for you: SELECT
Dear Assaf, Here you would need to use either subquery or self join. As there's only one column to join two queries or tables (member id), subquery would be the easiest one to use. with subquery:
Hi Rana, I would think this will involve more coding inside outlook (VBA coding) to perform as mentioned. This way, it will be a VBA code to download attachment from the email to some predefined