Recent content by Bluelove

Great appreciate your help it works now :) Thanks

It's very complex, and i didn't wrote any comments yet, but a product has 6 prices, 3 normal and 3 promo prices, according to the promostatus and the customer his status, the correct price should be displayed, so that's what it is all about and for every product (above) i need the price, to put...

the sp_productprice already returns an output @Price of type "money"

Hi, i have this problem in a stored procedure i have a SELECT statement, and in this SELECT statement another stored procedure should be executed Is this possible? Cause now i have this and i get 2 errors CREATE PROCEDURE sp_1 ...... ...... INSERT INTO OrderItem (OrderID, ProductID, Quantity...

ok thanks for you answer and Visio can't create the sql statements for the database either then? well i'll redesign my ERD in PowerBuilder then

I have a complete ERD of my database in MS Visio, does anyone know whether i can and howto input this directly into MS SQL Server. I don't know if it's possible, if not i have to input all tables and fields once again :) Thanks

i have 1 mdf database with according ldf file i don't have ms sql server, how can i use this database? thx

ok and how do i code it that when my scanner reads the barcode , Access searches for the number of that record and displays the item on the screen to make the receipt?

owkee i'm a total newbie to this barcode linked with access thing but for a new project i have to link all stock items to a barcode label meaning new items get a new barcode label and all items in current stock need to be labelled too (and added to the database) it's for a shop, but how do i...