Search results for query: *

The productId-Supplier combination is not unique; i.e. there can be multiple suppliers for a given product. This is an exercise for school...

Hi SQLScholar, Thanks for helping. With variabls I meant the SP should look for the minimum of each of the following given PruductID's i.e. ProductID =1 ProductID =2 ProductID =3 ProductID =4 I'm interested in finding out the min. 'cost' of only these products from a list of couple of...

Hi, I would like to run a stored procedure on a table of products (tblProducts). Basically the SP needs to: 1. Get the min. 'Cost' for each of the given four products (ProdID = 1, 2, 3, 4) 2. Order the results in Ascending. Thanks for your help!

Hi, We are doing some update/maintenance work on our classic ASP site which is backed by SQL Server 2005. The person doing the work comes from outside the company and needs access to the DB server. I was wondering what type of account and permissions he should be given. The requirements are...

Hi, I have a recordset containing 2 fields; i.e. Item_ID and Item_Name. The recordset is named rsOrders. What I would like to do is to save the recordset rows into an array of huperlinks - something like this: varOrder() = "<th><a href="?itemid=<%=...

Thank you so much! It indeed solved the problem....although I,m scratching my head over 'GROUP BY' since the customers are appearing multiple times in the created view :-(

Hi Everybody, Question from a novice :-) I have 2 tables: 1. tblUsers Fields: UserId, UserName, FromIP, ToIP, Country User ID is PK (unique); FromIP and ToIP are the IP addresses in notation (123.28.47.227) etc. defining the network range of users. 2. tblSessions Fields: IP, Sessions What...

Sorry! It's not working

Hi, I have a view: CustomerID OrderID ItemCost City 10 13 4500 A 30 17 3700 C 20 25 3457 B 50 19 7000 E 10 21 1900 A 40 32 2345 D 30 67 3457 C 20 89 4568 B The field 'OrderID' is unique; Is there a way to list the...

Hi, I am vew to web development & have the following problem: On my ASP page (let's call it ASP-1), I have a form and the values from this form are passed to another page (ASP-2) via javascript-xmlhttprequest. ASP-2 basically serves as a query function and returns the search results that are...

Sorry I overlooked some of the rows. some rows are in a format (showing volume in cubic meter): 1234x4563x46586 m3 Thanks for your reply!

Hi, I have a column named 'volume' having string data in the form: 1234x4563x46586 Is it possible to split it at 'x', then multiply the resulting 3 fields and show as a new column in a view? Basically 'x' is acting as 'delimiter'. Thanks!

yes the database is correct. It might sound like a stupid question: 'is it not necessary to add 'year' part in the query?

Hi, I would like to create a view to filter records from the last 6 months. e.g: select * from Users where loginDATE > DATEADD(MONTH, - 6, GETDATE()) AND loginDATE < DATEADD(MONTH, 0, GETDATE()) I am getting empty records with this although records do exist in the last 6 months! The...

Thanks a lot Everyone!!!!!!

Hi I have a table like this: C_ID Cost Is_employee 100 234 True 134 -587 False 120 457 True ...... Is there a way to find out the row where Is_employee is "True" and Cost is (Mimimum and Positive)? Thanks