Recent content by voxinforma

strongm, I bow to you!

I guess I oversimplified my problem: there can be any number of characters between 'q' and 'q', so this isn't a simple (for me) replace. Thanks in advance for your help.

I need to replace the 'x' character with the 'y' character whenever it occurs between two 'q' characters. How can this be done using replace and regex? Thanks in advance for your help!

I am creating an aging trial balance view, but can't figure out how to find the data corresponding to the 'distribution' form (Inquiries>purchasing>transaction by vendor>distribution). The usual table hints and dex.ini sql logging haven't produced an answer. I need something that links a PM...

I have a matrix report and would like to hide or remove the document map when the report is rendered. How to do it? Thanks.

sorry, i'm xp'd out this afternoon. i mean xp_readmail.

I am trying to get the output of xp_sendmail into a table. I've had limited success looping through xp_findnextmsg for the message_id, but what I really want is a full dump of xp_sendmail output inserted into a table. Tried using the info in BOL to set up the table but haven't gotten it to...

I am trying to connect to the exchange inbox of a specific user and return the date of the most recently received email there. any suggestions? thanks!

thanks for the response. im leaning toward partitioned views as being far easier to manage than replication; also it seems too easy to make the error of launching a second snapshot of the source production data after the older records had been deleted, and then all the effort of configuring...

I have a production server that contains sales data for the following years: 2002 2003 2004 I want to create a second, reporting (read-only) database containing all the 2002-2004 data, and then delete all but the 2004 data from the production database so that current transactions will process...

I am upgrading a sql 7/WinNT setup to a sql2k/Windows2k with Active Directory. My NT domain was called Olddomain and my 2k called Newdomain. Am using NT authentication. Is there an easy way to modify all my sql users to change them all from olddomain/username to newdomain/username without...

thanks!!

I have a document with multiple section breaks. I would like the page footer to read 2.1 for the first page of section 2, etc., resetting page number to 1 at the start of each section. How??? Thanks!

thanks for the link. I will probably change the export file type to xls, as that seems to work fine without any truncation.

I have a DTS which runs a query that concatenates some varchar fields and exports results to a text file. The query runs fine alone and returns records no matter what the length, but the text file seems to truncate each record after 255 chars. Is there a way to address this?