Database

SELECT Table1.*, Table2.*
FROM Table1 Left JOIN Table2 ON Table1.ID=Table2.Table1ID
WHERE (Table1.Col1=38 OR Table1.Col1=-1) AND Table1.Col2=0

select * from msdb.dbo.sysmail_event_log;

Quote:

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 24 (2011-11-17T17:20:53). Exception Message: Could not connect to mail server. (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 74.125.53.109:25)

-- ENABLE DATABASE MAIL FEATURE IN SYSTEM CONFIGURATION
	use master
	go
	sp_configure 'show advanced options',1
	go
	reconfigure with override
	go
	sp_configure 'Database Mail XPs',1
	go
	reconfigure
	go
	 
	-- DECLARE DATABASE MAIL ACCOUNT PARAMETERS
	Declare @qmail_account_name as varchar(64);
	Declare @qmail_account_description as varchar(64);
	Declare @qmail_account_email_address as varchar(64);
	Declare @qmail_account_display_name as varchar(64);
	Declare @qmail_account_username as varchar(64);
	Declare @qmail_account_password as varchar(64);
	Declare @qmail_account_mailserver_name as varchar(64);
	
	-- DECLARE PROFILE PARAMETERS
	declare @qmail_profile_profile_name as varchar(64);
	declare @qmail_profile_description as varchar(64);
	
	-- DECLARE PRINCIPLES
	declare @qprincipal_name as varchar(16);
	
	-- SET SMTP ACCOUNT DETAILS, USERNAME AND PASSWORD HERE
	set @qmail_account_mailserver_name = 'smtp.live.com'-- SMTP Server Name
	set @qmail_account_username='hellomoney'  -- SMTP User Name
	set @qmail_account_email_address = 'hellomoney@hotmail.com' -- Email Address
	set @qmail_account_password='123'  -- PASSWORD FOR SMTP User
	
	
	set @qmail_account_name = 'TestAdministrator'
	set @qmail_account_description = 'Mail account for administrative e-mail.'
	set @qmail_account_display_name = 'Test Automated Mailer'
	
	-- PROFILE PARAMETERS ASSIGNMENT
	set  @qmail_profile_profile_name = 'MyEmailServiceProfile'
	set  @qmail_profile_description = 'Profile used for database mail jobs'
	
	--PROFILE TYPE
	set @qprincipal_name= 'public'
	if ( @qmail_account_mailserver_name = '' or  @qmail_account_username=''  or  @qmail_account_email_address = ''  or @qmail_account_password='' )
	begin
	        Select 'Please enter SMTP details' as [Comments]
	end
	else
	Begin
	            if exists(select * from  msdb.dbo.sysmail_account where [name]=@qmail_account_name)
	            begin
	            exec msdb.dbo.sysmail_delete_account_sp @account_name = @qmail_account_name
	            end
	
	            EXECUTE msdb.dbo.sysmail_add_account_sp
	              @account_name = @qmail_account_name,
	                @description = @qmail_account_description,
	                @email_address = @qmail_account_email_address,
	                @display_name = @qmail_account_display_name,
	                @username=@qmail_account_username,
	                @password=@qmail_account_password,
	                @mailserver_name = @qmail_account_mailserver_name
	
	            if exists(select * from  msdb.dbo.sysmail_profile where [name]=@qmail_profile_profile_name)
	            begin
	            exec msdb.dbo.sysmail_delete_profile_sp @profile_name = @qmail_profile_profile_name
	            end
	
	            EXECUTE msdb.dbo.sysmail_add_profile_sp
	                   @profile_name = @qmail_profile_profile_name,
	                   @description = @qmail_profile_description
	
	            EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
	                @profile_name = @qmail_profile_profile_name,
	                @account_name = @qmail_account_name,
	                @sequence_number = 1
	
	            EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
	                @profile_name = @qmail_profile_profile_name,
	                @principal_name = @qprincipal_name,
	                @is_default = 1 ;
	end

im very new to asp.net.
i develop a website for e-commerce..now i developing a page to display the statistic of the product that bought by costumer..
here is my database structure..
Table Product-ProductID,ProductName,Description
Table Transaction-TransactionID,User,ProductID,Quantity

-in table Transaction, i store the product that bought by user with user name and quantity.
-table product, store the information about product

-this is my data, assume Bag ProductID=1 and Pencil ProductID=1 in table transaction..
-for table transaction:
TransactionID | User | ProductID | Quantity
1             | ali  | 1         | 2
1             | abu  | 2         | 3
1             | qwe  | 1         | 5

i want make a statistic about the product that bought by users..
im using this Select query= "SELECT Product.ProductName, COUNT(Transaction.ProductID) AS ProductCount FROM Product INNER JOIN Transaction ON Product.ProductID = Transaction.ProductID GROUP BY Product.ProductName"

when using this query the result is,
ProductName | ProductCount
Bag         | 2
Pencil      | 1

i just want my result shown like i stated below..but i dont know how to do it..
ProductName | ProductCount
Bag         | 7
Pencil      | 3

please help me....

_variant_t vFieldName (strFieldName);
_variant_t ret = m_rs->GetFields ()->GetItem (vFieldName)->GetValue();
CString str = (wchar_t *)(_bstr_t)vVal;

_variant_t vFieldName (strFieldName);
_variant_t ret = m_rs->GetFields ()->GetItem (vFieldName)->GetValue();
CString str = (wchar_t *)(_bstr_t)vVal;