Where's the Sort by New Message option?
Not sure when the layout of the newsgroups changed but I can't seem to find the ability to sort by new message in a thread instead of sorting by just the original thread date.
That was hugely helpful as I could follow along and see what threads were still active.
If you're gonna hang around in the newsgroups (any newsgroups), you may want to
start using a newsreader.
Microsoft Outlook Express can do it for you.
Saved from a previous post:
You may want to connect to the ms newsserver directly:
If you have Outlook Express installed, try clicking on these links (or copy and
is it possible to use variable for sorting?
declare @sort varchar(10)
SET @sort='column1 DESC'
SELECT ROW_NUMBER() OVER (ORDER BY @sort)AS rowId, * FROM table
Is dynamic SQL only option?
On 15/04/2010 11:28, simon wrote:
> is it possible to use variable for sorting?
> Something like:
> declare @sort varchar(10)
> SET @sort='column1 DESC'
> SELECT ROW_NUMBER() OVER (ORDER BY @sort)AS rowId, * FROM table
> Is dynamic SQL only option?
You can use CASE to he...How to sort account list?
I'm using MS Money 2004 Small Business. In the account list, my accounts
are catagorized by and in this order:
- bank accounts
- credit accounts
- investment accounts
- loans and liabilities
- asset accounts
In the above view, I cannot easily determine totals for assets and
liabilities. The following view does this.
- bank accounts
- investment accounts
- asset accounts
-loans and liabilities
How do I get the above view?
I don't use Small Business. But you can run a Net Worth report to get total
assets and ...insert control to parent at reverse order.
I see that, when insert controls to the same parent on the following way :
control1.parent = commonParent
control2.parent = commonParent
commonParent.controls(0) ' this is coltrol1
commonParent.controls(1) ' this is control2
But, when I am doing so on design time, the order is reversed (and that
what's I need).
commonParent.controls(0) ' this is coltrol2
commonParent.controls(1) ' this is control1
How can I insert into the parent, the controls with reverse-order?
Design time and runtime is not different in VB versions newer th...Row names will not move with sort
Each row in my summary table in Sheet1 is hyperlinked to a corresponding table in Sheet2 with additional details.
I need to move the rows in my summary table (Sheet1) and preserve the links to and from the details tables (Sheet2).
I found that I can move rows in Sheet1 with cut & insert and the hyperlinks are maintained. I can travel from a row in summary table (Sheet1) to details table (Sheet2) and back, even after the corresponding row (Sheet1) was moved.
Using ASP.NET, C# and SQLServer code behind checks whether data
is entered into textbox.
If data was entered into a textbox then the next line of code executes.
alert from the code behind that tells the user to enter data into the textbox
then executes the next line of code in the code behind.
I can use Response.Write to do that but it is not acceptable in this
case because the alert must appear on the same page.
OK- Thanks to everyones help I now i have a list i can work with... but
there are a few problems.... the zips are all 5 digit and now i have to
sort them... the problem is, THEY WONT SORT CORRECTLY!!!!!!! The
numbers are not in order... some are but a lot are not... is there
anyway to fix this???? i need to sort them by zip code but cant seem to
get them to do it correctly.. any ideas???
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
You are going to be far better of...import- number- sort?
I imported this data into a spread sheet- I tried to format it to number,
but when I sort it- I get :
Whats up with this?
Install the TrimAll macro, select the column and invoke
the macro from Alt+F8
Directions to install and use a macro at
I expect that you have spaces or CHAR(128) "Required Blank"
characters in you data you can check is =LEN(A1)
David...Switching SQL Servers
We were experiencing quite a few performance problems in the first month of
our CRM build in production, so we decided to get a dedicated SQL server for
CRM 3.0. I installed SQL2005 on 2K3 R2 Standard, and I don't want it to be
a member server just yet, just a SQL box. Right now, CRM is being loaded
into a SQL 2005 database on the same machine as CRM. How should I make the
switch, from old SQL to new SQL?
Luke Davis, MCSE: Security
by member server are you saying the SQL box is not joined to your domain?
John O'Donn...Demoting a 2003 Domain Controller Hosting SQL Server
We have a 2-node Windows Server 2003 cluster, with both nodes as domain
controllers and running clustered SQL Server 2003. I realise this goes
against all good practice, and that is partly why I am trying to do the
We additionally have two Windows Server 2008 R2 domain member servers, which
we wish to make domain controllers. We then wish to demote the two existing
Is there any reason why I wouldn't be able to demote the 2003 DCs whilst
they are hosting SQL Server 2003? I can stop the instance service, but I
wouldn't want to uninstall SQL Serv...Server/Cashier Banking
We need to be able to do Cashier/Server Banking (every cashier has his/her
own till and it "follows" them around till their shift is over at which
point the cashier AND NOT the register needs to be blind closed and the cash
room needs to update their closing amounts for all the tender types and
print a Z report for the cashier (not the register!) so we can hold them
accountable for over/shorts and potentially other problems like to many
Is other words we need to be able to X, Blind Close, Z, and ZZ individual
cashiers opposed to registers. How can we handle thi...Multiple SMTP Domains to 1 Exchange Server
I know it is possible to have multiple domains deliver email to 1 Exchange
2003 server, but I'm not sure what I'm doing wrong.
I have two domains, one.com and two.net. One.com is my original domain and
internal and external dns are both one.com and everything has always worked
fine. I want to add an additional domain, call it two.net. I setup the
domain in the Recipient Update list in Exchange System Manager and when I
ping two.net from outside my network, it resolves up to the proper external
However, whenver I send mail to email@example.com from externally, I get ...difference between Excel 2000 and Excel XP, and Excel 2002
I would like to know what the differences are between Excel 2000 and Excel XP, and Excel 2002
Go to John Walkenbach's site www.j-wal.com
Lots of info there.
remove CAPS in e-mail address
"Eleanor" <firstname.lastname@example.org> wrote in message
> I would like to know what the differences are between Excel 2000 and Excel
XP, and Excel 2002
This is a multi-part message in MIME format.
Content-Type: multipart/alt...Set Tab Order
Is their a way to set the tab order in an Excel
spreadsheet when I have protected the sheet - so you skip
over locked cells to get to only the uprotected cells?
in the protection dialog uncheck 'select locked cells'
<email@example.com> schrieb im Newsbeitrag
> Is their a way to set the tab order in an Excel
> spreadsheet when I have protected the sheet - so you skip
> over locked cells to get to only the uprotected cells?
...sorting macro #3
I need to sort on 8 cells in a row and on 1500+rows. I can do it one at a
time but I know there must be an easier way. Can ANYONE HELP?
C3:J3 I need these cells sorted and then down to C1532:J1532
I did create a macro to sort after I selected them but still one at a time.
Does it have to be a macro? I can edit a macro but don't really know how to
Yes, it has to be a macro. The following should do it. This macro loops
through all the entries in Column C, and in each row it sorts the values in
Columns C:J. HTH Otto
Dim rColC As Range
Dim i As...Contacts on Delgate computer are different than Mine
So I have a delegate that is an Editor to my mailbox. She takes care
of all my contacts. However the contacts that she has for my mailbox
on her outlook do not match what is in my mailbox - contacts on my pc?
How are they different? Maybe she's not seeing some that you've marked as
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
"DMobley232" <firstname.lastname@example.org> wrote in message
news:3abd1c74-3744-4b88-8ae0-fc...Looking for info/recommendations on server file undelete software
I am a Windows system admin for a city government. We have about 5,000
users, and about 120 Windows 2003 servers.
I have been tasked to look into file undelete software that would allow our
users to recover deleted files from network shares on some of our larger
file servers. I know about the Diskkeeper Network Undelete software, and
had used an older version several years ago, but since we're a government
agency, we need to attempt to evaluate multiple solutions.
The problem is that I'm having trouble finding any other similar software.
I've done various inte...Sorting checking register
How do i sort my check register in Money 2004 Deluxe so
that uncleared transactions appear below cleared
transactions? In Quicken i could click on the column to
provide that sort.
In microsoft.public.money, Dean wrote:
>How do i sort my check register in Money 2004 Deluxe so
>that uncleared transactions appear below cleared
>transactions? In Quicken i could click on the column to
>provide that sort.
You don't. Available choices are chosen by clicking View at the top
of the register.
...i need an sql or .net expert !
it seems like a simple enough problem, but i need some help......
i have a table of messages (like newsgroup messages) in sql server. my
application will allow people to read threads/messages and reply to messages
over the net.
the table has the following columns:
messageId - unique primary key
parent message id - if someone replies to an existing message, the parent
message's id goes here. (if message has no parent then this will be 0).
root message id - the id of the first message in the thread.
subject - the subject of the message
text - the main text of the message.
basically, what...Can we sort a form and also be able to enter new records.
It is possible to sort the data on a form and also be able to enter
new and edit the existing records in it.
On Tue, 15 Jan 2008 15:41:16 -0800 (PST), Rex wrote:
> It is possible to sort the data on a form and also be able to enter
> new and edit the existing records in it.
I assume you mean "Is it".
The form sort order has nothing to do with editing or adding new
records, so the answer is yes.
If you cannot edit or add new records, make sure the form's record
source, if it is a query, is updateable. Some queries are not.
O...SQL Server vs PostGress ,DB2 and Oracle
We are looking @ changing our Oracle DB with either SQL Server 2008 R2,
PostGress or DB2.
Does SQL SErver 2008 R2 support Pl/SQL?
> Does SQL SErver 2008 R2 support Pl/SQL?
No, you will need to alter the script
"BillVAS" <BillVAS@discussions.microsoft.com> wrote in message
> We are looking @ changing our Oracle DB with either SQL Server 2008 R2,
> PostGress or DB2.
> Does SQL SErver 2008 R2 support Pl/SQL?
I seriously doubt that anyone, other than Oracle, supports PL/SQL.
As...using addrress books to sort incoming mail
I use address books to sort incoming mail.
An odd thing: depending on how the sender's name comes across, it doesn't
get caught by the filter (amd moved to the "Family Mail" Folder I have set
up. for example: my mom and dad's email (from email@example.com)
comes as from that address. However, in my contacts, they are listed by
their names: John and Mary Smith, with firstname.lastname@example.org as their
email address and John and Mary Smith as the display name.
What have I done wrong?
1. The big ONE - failed to post your version of Outlook. Rules operate at
...SQL Query help 11-24-09
I have a table containing the following columns: Id, Date, PayDate, Text and
The table contains postings for a number of persons identified by Id.
To get a status of a members transaction I use the following query:
SELECT Date, PayDate, Text, Amount,
(SELECT SUM(Amount) AS Expr1
FROM Postings AS D1
WHERE (Date <= D0.Date) AND (Id =
@MemberId)) AS Total
FROM Postings AS D0
WHERE (Id = @MemberId)
ORDER BY Date
Which gives the following result:
...live communications server alternatives
I have a domain of about 100 users of which only about half are
allowed Internet access.
We previously ran Exchange 2000 and all 100 users had access to the
Exchange IM system via Windows Messenger.
However, we had to upgrade from Exchange 2000 to 2003 for a larger
mail store and just to stay current. As Rich pointed out to me
earlier, Live Communications Server replaced the Exchange IM system
that was in Exchange 2000.
So, we lost the ability to do interoffice IMing.
Management wants me to come up with a solution to restore this
functionality. However, I've been told that ...Unmerge so I can sort
I coy/pasted data into Excell and when I try to sort it I get "This operation
requires merged sells to be identically sized". I understadn the work around
in KB but how do I find which sells are merged?
I wouldn't bother looking.
I'd just remove all the merged cells from the range to sort.
Select that range
uncheck the merge cells box
But if you wanted to search, you can do it via process of elimination. Select a
range, format|cells|alignment tab.
If that merge cells box is checked, then the whole selection is merged. If it's