please .....Two questions in my project

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

please .....Two questions in my project

Author

Topic

B5CSE
Starting Member

25 Posts

Posted - 2005-04-14 : 07:52:16

In my project which about banking system there is combo box in which the client has 2 choices in which the first choice the client has weekly report from talking out
And depositing and the second choice monthly report …..
The problem how make that automatic by SQL server or by vb.net

The second question in banking system I have 3 systems and I want to make for each
System specified users whose passwords in which if the user click the command for
Enter one of the systems the program show form for the user which the user enter the
His /her user name and password then program check user name and password if isn't
Correct then the program don't allow to the user for enter that system

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-04-14 : 11:59:41

wow. I can't make heads or tails of what you are asking.

let's tackle the first question only. What do you mean by "make that automatic"? I don't understand the problem you are trying to address.

-ec

X002548
Not Just a Number

15586 Posts

Posted - 2005-04-14 : 12:32:32

my brain hurts....

Brett

8-)

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-04-14 : 13:43:55

quote:
Originally posted by X002548

my brain hurts....

tell me about it. I had to go take a nap after reading that 2nd "sentence" twice.

-ec

tuenty
Constraint Violating Yak Guru

278 Posts

Posted - 2005-04-14 : 15:14:45

It was very dificult for me to guess what s/he is trying to ask but at least the second thing I think is a username/password validation in one application (that I guess will involve a SP and some encryption for the password field) for three diferent bank systems

A candle loses nothing by lighting another candle

B5CSE
Starting Member

25 Posts

Posted - 2005-04-14 : 23:32:58

my firsrt question how i make report which is executed automatic weekly or monthly by the user

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-04-15 : 00:17:05

"automatic" by the user?????

You want the report automatically executed and "sent" to the user every month?
Do you want just the output of a stored procedure sent to them?
Do you want it emailed, or presented through an application?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

B5CSE
Starting Member

25 Posts

Posted - 2005-04-15 : 00:53:08

i want the report automatically executed and "sent" to the user every month

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-04-15 : 01:08:09

Ahhhh, well setup a scheduled job to run in SQL Server once a month. You can use xp_sendmail to execute a stored procedure with the @query option. Optionally, you could use job to just populate a report table. The application could pull from that table, format the report, and send it to the user.

Is this what you're wanting to know?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

B5CSE
Starting Member

25 Posts

Posted - 2005-04-15 : 01:21:13

could you give me code for make it
since i dont know any thing about mailing by sql server also i havnot books

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-04-15 : 01:22:59

You have Books Online. It comes free with SQL Server. Start\All Programs\Microsoft SQL Server\Books Online.

Look up xp_sendmail on the index tab.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-04-15 : 01:28:17

from the first question, it's not really automated that he wants, it's choosing the reporting period. though automation sounded really cool, so he says it's automation

quote:

there is combo box in which the client has 2 choices

create SP and pass the period as parameter which you can use as criteria for your where clause

now, don't ask me to post the SP, try Derrick's advice and be a good student and check on how to create SP in BOL