Thanks, that works perfectly
I need to create an SQL that will show amount of sales for specific agencies and what percentage of all sales this number represents Create table...
I am trying to write an SQL statement to update a large table (6 million rows) from a smaller one (3000 rows) TABLE A booking int...
I am using the OPENQUERY to read data from a remote database and insert into SQL Server. The procedure can be quit slow, is there a database...
NO there is no primary key int the table, both indexes can have mulktiple entries
The table is as follows create table flglobal_old(departure datetime, sold int,product char(6),branch char(2),tr_date datetime,gateway char(3),dest...
I have a table (3.8 million rows) that has 2 indexes defined (product, departure) but when I use a select statement specifying only 1 or other index,...
I am working on a data warehouse system which requires inventry to be reported on a monthly basis. The main system uses inventory on a daily basis....
I am using SQL Query Analyzer Version SQL 8.00.20399
I am currently using the SQL database as the database for Bi reports and graphs. Data is extracted from a database on an HP_UX system and put into...
I found the problem, one of the dirtectories on the Unix box I was reading from ran out of disc space
I have been running the same overnight job for the past five months without a problem and now I am getting Server: Msg 7399, Level 16, State 1, Line...
Sorry about the 2000/2005 mix up. I did not realize what version I was using until this problem came up. The report write I am using (Esperant) can...
That would be great if I had that version of SQL but I am using 2000. Are there any other ideas?
I have created a user functions which returns a table. The function has one parameter which is the date. Is it possible to create a view where I can...
I created a view that uses a join, that seems to work. Thanks for your help
I have a table which contains all of the booking information. I need to be able to extract information from this table IE # passengers, sales, etc...
thanks for the help
Your suggestion will not work since the information you requested from table a exists in 2 tables. I have table 1 with name and booking I have table...
I have two tables. One with booking number,destination,departure date and the other with booking and passenger name I need to create a list of...
Separate names with a comma.
