Search results for query: *

Well, yes it is only one email at a time. table gets dropped and recreated for each email. I'll try coalesce. Thanks.

Hello, I have a table with one column, which is populated by a bulk insert statement that enters the values from an ASCII txt file. Each line in that txt file equates to one row in the table. Now I'm using microsoft's sp_smtp to send emails, and I'm trying to figure out how to make the @body...

Now, being a n00b as I am, may I ask for a link or something that can define how to do that? remember folks, i did say n00b, so sorry for being so dee-tee-dee on all this.

A n00b question, from a n00b: How can I create a button that replaces the standard "back" button on every webnavigator, that when clicked on the current page, will take the user to the prev page and keep all the choices that he made, before moving to the page he is in , now? I take it...

err, makes sense. sorry. I'll try the scripting forum.

Public Function MyScript(Name As Variant) Dim dommail1ldap As Variant Dim ActiveDirectory1 As Variant Dim ADUsername As Variant Dim Email As Variant Dim WScript As Variant Set dommail1ldap = GetObject("LDAP://domainame/O=Flagella") Set ActiveDirectory1 =...

r937 that's it! thanks much, i was COUNT-ing the wrong thing. But again, thanks much for the help!

well like I said there's a column that called SourceFile, from the query I typed above, I get X-number of rows, I want to group that number of rows and categorize them based on the SourceFile column. So several rows will have the same SourceFile value, I want to group the rows, based on the...

Hello I need to figure out to group the results of a query (select * from table1 a where not exists (select * from table2 b where a.columname = b.columname) That query returns 192 rows, now those rows all trace back to a SourceFile file in the SourceFile column, certain rows draw from the...