In the code that i have pasted, i am getting value from DT_KEY field from the database and storing it in Sheet3.
My requirement is in the sql that i have used:
I need to get the date from Sheet1!C2 field. So let me know how can i change the query to get the input from Sheet2.
I am copy pasting the sql which is in the code,
" SELECT DT_KEY FROM CCDM_MSTR.DT_DIM WHERE CAL_DT=[B]to_date('1/3/2013'[/B]--instead of giving the date i want to pick it from Sheet1's C2 field,'mm/dd/yyyy')"
Please Login or Register to view this content.
Bookmarks