i want to make project

i want to make a database for pharmacy using sql server and VB.NET
so any body can give me illuminations
thanks in advance
george albertHire a DBA?

Specific questions, please...|||No, but I have plenty of penumbras. $2 college word of the day for Blindman's sake.|||Without looking it up, isn't the penumbra the area of partial shadow during a solar eclipse?
Not sure how you wound up with many of them...|||not quite.

http://www.m-w.com/dictionary/penumbra

it came to my mind because he used illumination. these 2 words i believe are both used in a certain court case to establish the constitutional right to privacy. that is where I got my word association from.sql

I want to convert datetime value into MonthName.

In Page Body, there is a textbox whose value is in "mm/dd/yyyy" form. So I want it in "dd MonthName yy" format. How to do it.

Suppose the field name is field1 which has date in dd/mm/yyyy format, use this in the value expression

DatePart("dd", field1) & " " & MonthName(field1) & " " & DatePart("yy", field1)

|||

It's acually even simpler than that.

In the format properties of the textbox enter in the Format Code: box (top left of tab)

dd MMMM yyyy to return a date such as 03 Novermber 2006

or

dd MMM yyyy to return a date such as 03 Nov 2006

i need to converse my database from 2005 to 2000.

hi evey body:

I have a sql 2005 database. But now i need to turn this database to be sql 2000 database. How can i do that.

There is no direct way of going back from 2005 to 2000. You can use DTS/SSIS to export all the objects to 2000.

|||

Try the publishing wizard that is stickied at the top of this forum.

I need SQL server2005 materials

hi every body ;

Ineed sql server 2005 material

Can you please be more specific?|||

mindshunter:

hi every body ;

Ineed sql server 2005 material

Try the link below to download the latest BOL(books online) run a search for all you need to know. Hope this helps.

http://www.microsoft.com/downloads/details.aspx?FamilyID=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

|||

I need sql2005 DB implemnting ,DB maintenance &DB security

|||

mindshunter:

I need sql2005 DB implemnting ,DB maintenance &DB security

Run a search for all of the above in the BOL (books online) after you install it.

|||

Thanks for reply

mindshunter

I need help creating a procedure

Please I need some body to guide me here. I dont know how to create a store procedure.

If the user wants to delete one transaction I need to do the following to be able to delete the transaction. What I'm trying to do here is update the items to the state that they were before the transaction.

What I want to do is something like this, I never have made a store procedure this is just an example to make easy to understand what I need to do.

CREATE PROCEDURE `videodb`.`CancelTransaction` (transaction_id INT)
BEGIN

DECLARE sale_types VARCHAR(25);
DECLARE sale_ids INT;
DECLARE item_ids INT;
DECLARE deposit_ids INT;

/*Here I need to select the required fields that are needed to do what’s next*/

SELECT rents.id, rents.item_id, rents.type, deposit_id INTO sale_ids, item_ids, sale_types, deposit_ids
FROM VideoDB.transactions
INNER JOIN VideoDB.rents ON rents.transaction_id=transaction.id
WHERE id=transaction_id;

WHILE (sale_types <> NULL) DO

SELECT CASE WHEN (sale_types='Rent') THEN

/*Here the rent is deleted and the item is updated to available*/

DELETE FROM VideoDB.rents WHERE id=sale_ids;

UPDATE VideoDB.TransactionItems SET status='Available' WHERE id=item_ids;

WHEN (sale_types='Sale') Then

/*Here the sale is deleted and if the item that was sold was a sale item the inventory is updated and if the item that was sold was a rent item the item is updated to available*/

DECLARE cur_keep_inventory BIT;
DECLARE cur_item_type VARCHAR(25);
DECLARE cur_item_inventory INT;

DELETE FROM VideoDB.rents WHERE id=sale_ids;

SELECT keep_inventory, inventory, item_type INTO cur_keep_inventory, cur_item_inventory, cur_item_type
FROM VideoDB.items WHERE id=item_ids;

SELECT CASE WHEN (cur_keep_inventory=1 And cur_item_type='Sale') THEN

UPDATE VideoDB.items SET quantity=cur_item_inventory+1 WHERE id=item_ids;

WHEN (cur_item_type='Rent') THEN

UPDATE VideoDB.items SET status='Avalable' WHERE id=item_ids;

END;

WHEN (sale_types='Overdue Payment') Then

/*Here the Overdue deposit is added to the current overdue and is deleted*/

DECLARE cur_paid_amount DOUBLE;
DECLARE cur_deposit_id INT;
DECLARE cur_overdue_amount DOUBLE;

SELECT paid_amount, deposit_id, r.paid_amount INTO cur_paid_amount, cur_deposit_id, cur_overdue_amount
FROM VideoDB.rents, VideoDB.rents r WHERE rents.deposit_id=r.id AND id=sale_ids;

UPDATE VideoDB.rents SET paid_amount=cur_overdue_amount+cur_paid_amount WHERE id=cur_deposit_id;

DELETE FROM VideoDB.rents WHERE id=sale_ids;

WHEN (sale_types='Debt Payment') Then

/*Here the Debt deposit is added to the current debt and is deleted*/

DECLARE cur_paid_amount DOUBLE;
DECLARE cur_deposit_id INT;
DECLARE cur_debt_amount DOUBLE;

SELECT paid_amount, deposit_id, r.paid_amount INTO cur_paid_amount, cur_deposit_id, cur_overdue_amount
FROM VideoDB.rents, VideoDB.rents r WHERE rents.deposit_id=r.id AND id=sale_ids;

UPDATE VideoDB.rents SET paid_amount=cur_debt_amount+cur_paid_amount WHERE id=cur_deposit_id;

DELETE FROM VideoDB.rents WHERE id=sale_ids;

END;
END WHILE;
END

Amendez:

Your pseudocode looks like you have the problem pretty well thought through. The next step for you is to convert your pseudocode into actual SQL syntax. Use books online and begin the conversion. Since you are new to this my feeling is that you need to do this learning phase on your own as much as possible so I will leave the bulk of this work to you. Some topics that you are going to need to examine are (1) variables, (2) cursors -- I don't like cursors, but that appears to be the way your pseudocode is aimed, (3) IF and ELSE statements, (4) WHILE, (5) CREATE PROCEDURE and more. Make a full pass at converting your pseudocode into a stored procedure and then let us know how it is going.

Something that you are going to need to learn somewhere down the road are reasons to avoid using cursors. The main thing that you need to know about this for the moment is that MS SQL Server is more efficient when operating on sets of records than when working on records one at a time. Think about this for now and we will discuss this after you have completed your first pass.

Good Luck,
Dave

I need Crystal report Tutorial in PDF form

Hi all,
I need Crystal report Tutorial in PDF form. So please send me the website address or otherwise please send me if any body having tutorial.
Bye,
R.Ragupathi.Refer this
http://support.businessobjects.com/library/docfiles/cps10/docs_en.asp

Madhivanan