lCustID INTEGER := 203 - Production Customer3 lCustID INTEGER := 202 - Production Customer2 lCustID INTEGER := 201 - Production Customer1 lCustID INTEGER := 105 - Testing Customer5 lCustID INTEGER := 104 - Testing Customer4 lCustID INTEGER := 103 - Testing Customer3 lCustID INTEGER := 102 - Testing Customer2 lCustID INTEGER := 101 - Testing Customer1 lCustID INTEGER := 5 - Development Customer5 lCustID INTEGER := 4 - Development Customer4 lCustID INTEGER := 3 - Development Customer3 lCustID INTEGER := 2 - Development Customer2 LCustID INTEGER := 1 - Development Customer1 I'm not great with cursors, am not sure if that'd be the right answer, but figured I'd ask you all since you all have helped me quite a bit in the past. However, the last statement is a query and I want it to return in the results window, but it's telling me it's expecting an INTO statement. I wanted to create tabs for each different type of export and have variables for the different customers in each tab so I can easily run them on any DB instance for any customer. They're the same queries for each customer but are filtered by an ID. I have queries for some exports for different customers. Sorry for the very generic title, can't think of the best way to put it in short words.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |