Recent content by KARR

All, I have been working with SQL 2K for a while, but this is the first time I am trying (without luck) to take the results and pivot them, as so to speak. Basically want to take the value in the first row of the 'note' field and combine it with the second row of the note field. Data Set...

All, Does anyone know how in Outlook Express v6 how to copy e-mails in an IMAP account to the local folders through a script or automated application? The IMAP account has a 31 day retention period, and anything older than that would get deleted. Thanks, Rob

All, Need to revisit this topic with one more question... How would I be able to return columns from another table entirley? The working code: select t1.FileNo, t1.Code from table t1 inner join table t2 on t1.FileNo = t2.FileNo and t1.date = t2.date and t1.code <>...

Makes sense, and more importantly I understand. :) Thanks Rob

Was able to get the format I was looking for by removing the * and replacing it with t1.FileNo, t1.code, t1.date. But I am trying to understand why SQL returned the data in that format.

I see, the results I got from your query: TEST5 2004-01-01 X300 TEST5 2004-01-01 X400 TEST5 2004-01-01 X400 TEST5 2004-01-01 X300 TEST4 2007-11-30 X300 TEST4 2007-11-30 X400 TEST4 2007-11-30 X400 TEST4 2007-11-30 X300 How would I get the data to...

Disregard the above response, I had wrong codes in the table. Will re-run query now.

I modified the query to: SELECT Activity1.* FROM Activity1 INNER JOIN (Select FileNo, Code, Max(Date) As Date From Activity1 GROUP BY FileNo, Code) Tbl1 on Activity1.FileNo = Tbl1.FileNo and Activity1.Date = Tbl1.Date and Activity1.Code <> = Tbl1.Code Where Activity1.Code In...

All, Been rattling my brains out on getting this query to return the proper results... Would like to return two records for each "FileNo" that has X300 and X400 for the same date. If a FileNo does not have both a X300 and X400 for the same date, do not return anything for that FileNo. Table...

And yet, the mailboxes on the Exchange 2003 server can send\recieve without any problem. Its just between 2000 and 2003, thats got me baffled.

No error in the returned email, just the contents.

All, I have two exchange servers in my organization, one 2000 and one 2003, as I am in the process of migrating all the mailboxes to the new server. I just finished moving one mailbox to the new 2003 server using the built-in "move mailbox" command, and every time I send an email from that...

Ah..that did it. Thanks!

This would go into the query itself under SQL view?

All, Looking to export a table containing a text column containing data such as 212.59, 11.39, etc. The export will be to a fixed width text file. I am having an issue getting the field to right align\justify. I took a look at the format command try it do it from a query rather than the table...