Search results for query: *

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...

I was trying that, and it seems to work in a tab-delimted export, but fixed field it drops the 0's.

OK, I set the formatted query to 00000000, if this is correct I am getting 698 again.

All, Does anyone know how to export to a text file, a column set to autonumber with padded 0's? That is, I have column formatted to 8 positions (00000000), the column in the table says 00000698, but when I get the text file its 698 when I really need 00000698 Thanks

All, I have a 10,000 record table, and I would like to create queries that work within this table but only certain rows. Query 1 - Returns rows 1-999 (easy enough) Query 2 - rows 1000 - 1999 Query 3 - rows 2000 - 2999 etc I do not have any record # field in the table, otherwise I might be...

Yep, we restarted the box. I opened a ticket with MSFT and found a checkbox was unchecked Recpt. Update Service. How it got that way we'll never know, but its working now.