Search results for query: *

I have a table promotion_schedule that has a field called "where clause". This actually has the where clause used to pull certain items out of another table. If I do a: select where_clause from promotion_schedule it will give me the following: ((acntv.master_sku.retail_cat='some...

I have a cursor that pulls product_id and size and orders them by size asc. I'm passing a size and number(either 1 or 2) to the function. basically what I'm needing to do is return the size that is the next closest to the size I pass in. The issue becomes when I have more than 1 size...

I have a sql query that pulls about 26000 rows in about 3 min. I have added another column that calls a pretty simple function, but it changes the efficiency to about 100 rows/2 minutes. I really need to add three columns using the same function, but at this rate, it would run all day. The...

I have a function that has three parameters(v-mid,P_product_id, n). Inside that function I need to call another function called top_related_prod_type2 that have the same three parameters that were passed to the main function. The synatx around it looks like this: if v_no_of_records < n then...

Okay, I'm in a major crunch here. Here's what I have. There is a gui that allows users to select filter criteria. Each product group can have multiple groups with individual filters in it (ie. Gold month could have a gold rings shop,a gold necklace shop, etc each with their own filters)...

hopefully the title was confusing enough to someone that they may look in to see what in the world I'm talking about. I have a table that contains product_ids, review_dates, and aggregated ratings. Here's what I need: I need to create a file that has every day(starting with the first date a...

Okay, I'll try to explain this as best as I can. I have a table which houses every product we have in stock and their properties. There are four fields that I'm interested in: Prod_type,Gemstone,Retail_cat, and Meterial. I need to find unique combination of the products based on 1,2,3,or 4 of...

OK. I've got an initial procedure that can be passeed an optional date parameter. I need those parameters to be able to be passed to a procedure that is called within the first procedure. Then I need those to be passed again to a third procedure which is called from the second. Make since...

Okay I've got a keyword. Under each keyword can be multiple retail categories with a specific number of orders per category. Keyword category orders diamond gemstones 100 diamond jewelry 20 diamond supplies 8 ruby...

Okay, i've got a table that has duplicate rows(except one column). In other words, rows will have the same ID#(cookie), same visit_date, but different entry page. ie. 765-432 06-07-2007 affiliate 765-432 06-07-2007 search. I'm trying to find a way to combine these rows and make...

I have the following the snippet of procedure the is using an existing table as a parameter, but every time I run it I get an error saying the "table doesn't exist" I guess it is not recognizing the parameter correctly. PLEASE HELP: create or replace procedure nc_new_customer_analysis...

Okay, I'm new to writing in oracle, only VBA and SQL. Its normally pretty easy to define a variable and use it as a table to do a select from. I'm writing a procedure that will be used daily for 30 days, using a select from a table called nc_daily_new_customers. Once the month ends, I want it...

I've inherited a workbook that has 1 data page, and 15+ charts. The text on each of the charts has been manually changed to reflect the month's data that is in the charts. I'm sure there is any easy way to do this through VBA, but I'm not sure of the syntax. My initial thought is just to do a...

i've currently got code automatically checking for passwords, and remote tables using cat.tables.append tbl. Our lan team just set up a locking scheme which apparently doesn't like what I'm using (long story short, it makes two unsuccessfull attempts at linking for every successful attempt and...

I've got a large module which get a password and user ID string from a remote file. Everytime the database is opened the code runs and relinks the tables that are connected to sybase(as we change passwords frequently, this is the best way to not have to touch every database when there is a...

Here is the code I have: Public Function openexcel() Dim xl As Excel.Application Dim sheet2 As Object Dim workbook As Object Set xl = CreateObject("excel.Application") xl.Workbooks.Open ("C:\last eight periods chart.xls") ' substitute your file here xl.Visible = True xl.DisplayAlerts = False...

I've got a workbook called "Last eight periods chart". In this I have a pivot table linked to data in my mdb. I've gotten around the auto refresh dialog box by refreshing the workbook through code. However, now I need to print the chart to a pdf file. I cannot get anything to work. The...

I've got a data page in access that I need to take a screenshot of and email(the reason being if I email just the data page, when you open it, it contains only the template and no data). I'm able to get it to the clipboard using VBA: Private Declare Sub keybd_event Lib "user32.dll" _ (ByVal...

I'm running some code from access that hits a sybase server. The code does some deleting and updating on the server. I've gotten everything to work the way I want it on out test server, but I had to hard code my password and login name in the connection string. The problem is that we don't...

Okay, here was my first attempt at this code to connect to a sybase server, get a recordset of tables, find what column number contains records I need, and then inserting values into a local table. It works. HOWEVER, 1)I have open 3 connections to the same database throughout, 2)It runs slow...