Hi Experts:
I have huge tables that I extract data from on a daily basis.
For example I run a script that does select into a new table whatever fields based on criteria I provide on a field. The...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23064373.html
Zones:
MS SQL ServerDate Answered: 09/08/2008 Rating: 7.7 Views: 0
I need a little help to make this a Stored Proc or a function:
As you can see this a kind of long code and want to make it a little easier on myself when I call it from my ASP web code.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23082523.html
Zones:
MS SQL ServerDate Answered: 01/14/2008 Rating: 9.2 Views: 0
I am trying to Count days, in a table with a function, but it is not working.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23082862.html
Zones:
MS SQL ServerDate Answered: 01/16/2008 Rating: 8.8 Views: 0
I have query and need to select Last PO information for each part in each location:
i.e. Part A is located in loc tm and loc zzz
There are 500 POs in the table for that part and all i need is t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23087009.html
Zones:
MS SQL ServerDate Answered: 02/15/2008 Rating: 7.2 Views: 0
I have a database with 3 tables:
Company (fields: name,phone,internet,affiliations)
Location (address,city,state,zip)
Employees(title,first,last,phone,email)
Each company has multiple locat...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23117607.html
Zones:
MS SQL ServerDate Answered: 01/29/2008 Rating: 8.2 Views: 0
I have 2 tables in 2 different databases.
Fields are not alike.
Source DB: LWS
Source Table: Fedex
Column Name Type
ID decimal(18...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23167529.html
Hello,
I have an RS 2000 report to build and I'm writing a stored procedure which holds the code. Basically I want a report which shows when a complaint was received and when it was resolved. ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2326...
We have a SQL 2000 database which holds information on the amount each of our customer has spent, the table contains the invoice date, amount and customer.
What i need to do is compare the spend...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23314671.html
I have a table "Tasks". This table contains data on the start time of jobs in a scheduling system.
Each job can have 1 or multiple sections to it. Each section for a job has a job number (job_no...
http://www.experts-exchange.com/Database/MySQL/Q_23441042.html
Zones:
MySQL ServerDate Answered: 06/02/2008 Rating: 8.4 Views: 0
I have table called test as shown in Excel file
that table show week & volume
As you can see the week number is not showing from 1- 7....52 , the test table is showing the weeks having the volume...
http://www.experts-exchange.com/Database/MySQL/Q_23465143.html
Zones:
MySQL ServerDate Answered: 06/26/2008 Rating: 9.2 Views: 0
