Search results for query: *

Hi all How do I load the names of all my distribution lists from MS Outlook 2000. I'm using Delphi 6 Professional. Also once I've loaded the names of the distribution lists, how do I load all contacts within a specific distribution list? Thanks Louis

Hi there I want to pass a variable value to the xp_sendmail procedure such as the following: EXEC xp_sendmail @recipients = @email, @query = 'SELECT * from myTable inner join anotherTable on myTable.myColumn = anotherTable.anotherColumn', @subject = 'Report', @message = 'This is a...

Does anyone out there know how to use the DBGridEH control? The problem I'm having is that the grid can shift select on one page, but as soon as you scroll down to the next page with shift held in and want to make another selection then, then your selection from the previous page is not...

Just one last question. What does the code look like for the view vw_Count? Sorry if I'm pestering, but I'm quite a newbie at SQL. Thanks

Just a question about this though. What is in the view vw_Count in the last line your joining the view, but on which column? Thanks Louis

But I don't actually want to group the table by all the fields, otherwise it's useless if I want to add totals by member and by company. How will I do that?

Whenever I execute the following query:select member_id, company.company_code, company.credit_limit system, member_id, first_name, last_name, members.credit_limit, members.email, date_sent, count(*) from Company, Members left outer join Reminders on members.email =...