Search results for query: *

Hi I have a SQl Query which returns rows with E-Mail address, username,some of other details. How do I write a procedure which sends E- mail to all the people returned by query and their rest of the details should be included in message part which should display in HTML format. Below is the...

HI Thanks, But the code gets exec only for 1 person, it selects 1 person's email randomly out of the list of rows Could you just tell me why its happening ? Thanks Shivali.

I have a query which gives set of rows containing Email-Id with respective Names. Below is stored procedure which sends mail to 1 person at a time. declare @rc int exec @rc = master.dbo.xp_smtp_sendmail @FROM = N'MyUsername@xxx.com', @TO = N'FriendsUsername@yyy.com'...

How Could I get all the transactions which took place from the begining of the week to current date for example if I run query today 14th jan then I should get all the transactions from 12th Jan - Monday to 13th jan excluding current date and the same query should execute even when the user runs...

How could I get all the transactions which took place from the begining of the Year to Current date excluding current date and if the query is executed on Jan 1st of the year 2004 then all transactions of the previous whole year should be displayed and if the query is executed on March 14th 2004...

How could I get all the transactions which took place from the begining of the week to current day excluding current date and if the view is executed on monday then all the transactions of the previous whole week should be displayed.

SQL Server 2000 - Query Analyzer : I need to write a view where I need to extract all the transactions which took place from the begining of the month till Current Date excluding the current Date, this holds good if the user is seeing the results of the view during the mid of the month ,if the...

In SQL Server - 2000 Under Query Analyzer For a view I need all the transactions in the past 7 Days excluding the current Day. I have a field Transaction Date Field in the Database. How Could I extract only those Transactions ?

My Report Needs Weekly,monthly and yearly Report on the Totals(Filed in Database) Sales for each Agent (Filed in Database) in their respective region(Filed in Database). I donno how to do it? PLZ let me know as early as possible. Thanks Shivali.