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 ..."An unexpected error has occurred" when sending from distribution lists
I have set up a new computer, installed Outlook 2002 on it
and migrated my files to it from the previous computer.
Now whenever I attempt to send an email addressed via one
of my distribution lists, I get an error message (An
unexpected error has occurred). I also see two Contacts
folders in the Add Address List in the Tools/options in
the address book.
I did change the location of the Outlook pst files, did I
confuse something or ?
Any ideas? Nothing in the Knowledge base helped
...Linking Outlook fields from the "Contact Folder" to a custom form in Outlook...
Using Exchange Server 2003/Outlook 2003, we have created a custom Help
Desk form in Outlook. We would like the ability to link specific fields
from the Contacts Folder (Example B), in a drop-down list box if
possible. We are far from knowing that something like this is even
possible. Would appreciate *any* suggestions. Thank you.
...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
paste i...Copy of "SelfCert.exe"
Anyone have a copy of SelfCert.exe. I need it to make myself an internal
Mac Lingo -
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
"Mac Lingo" <Mac@SV-CaliforniaGirl.Com> wrote in message
> Anyone have a copy of SelfCert.exe. I need it to make myself an internal
> Mac Lingo
...We Need a United Group of Users Re POS Screen
I was just using our POS today and realized that some
items have been scanning without the correct taxes set to
We all need to voice this concern to microsoft to update
the POS screen.
The tax colunm should actually show the tax code so that
the cashier call see which taxes are being applied to each
item and should print a tax code next to item on sales
If someome makes a mistake enter something it Manager then
our cashiers are the next line to catch the mistake. But,
they need to be able to see it.
The check mark on the screen says that taxes are being
applied...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.
But if I sort the rows in Sheet1 the links from Sheet2 back to corresponding rows in Sheet1 lead to presorted locations. Apparen...Pls show me how to delete message in the google group ?
I can't find field delete the message in the google group.
Pls show me. thank a lot !
...sorts not sorting
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...close "ALL"
Excel 2002 SP3
Win XP Pro SP2
Is there a way to "Close ALL Files" (but leave Excel open) with a mouse
click or keyboard shortcut?
Hold the Shift key when you click on the File menu en you see Close all
Regards Ron de Bruin
"stef" <email@example.com> wrote in message news:OpDg6hFLIHA.1204@TK2MSFTNGP03.phx.gbl...
> Excel 2002 SP3
> Win XP Pro SP2
> Is there a way to "Close ALL Files" (but leave Excel open) with a mouse
> click or keyboard shortcut?
Here is one I use...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..."Runtime Error: Subscript Out of Range"
What the heck does this mean? If you hadn't guessed, I'm new to macros
I'm getting this message when I try to run one of mine. THe macro open
another workbook, copies two rows, pastes them, then copies the colo
pallette, then closes the other workbook. When I ran them after writin
them yesterday, they all worked fine, but now, I'm getting an error
Here's the VBA (Which I know nothing about) if it will shed any light
bludovico's Profile: http://www.excelforum.com/member.php?ac...Find a discussion group for Business Portal
I am trying to set up MS Business Portal & have it pull the infomation from
Great Plains (GP). I have a lot of questions but can't find any good
anwsers. I am looking for a user group but so far havn't found any. Can
some one point me in the right direction?
This group is the only one I know of where people regularly contribute.
Charles Allen, MVP
> I am trying to set up MS Business Portal & have it pull the infomation from
> Great Plains (GP). I have a lot of questions but can't find any good
> anwsers. I am looki...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...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.
A few days ago Outlook 2003 (with SP2 installed) had to be closed for
not responding. It then came up next time without the viewing pane (an
unusual occurrence). Today I was unable to access my Inbox folders. I
have run scanpst.exe, which carries on to the end when it asks to
"repair" when it hangs and does nothing. My pst file is less than 2Gb.
I was also unable to access or send mail.
Reading the posts I set up a new profile, identila to the old one bt
with a new name and was then able to send received mail, but now new
folders Inbox/Unread mail/Follow up/Sent items appear in the...Is the bug "Word does not remember position of window" still not fixed?
Operating System: Mac OS X 10.6 (Snow Leopard)
It looks like I've got this problem and in searching this board I notice that its described as a known bug in 2008. <br><br>Can it be that after two years and so many upgrades that Microsoft still has not fixed this? <br><br>OK, its not a huge deal, but I would be most grateful if someone would recommend a work around.
The condition "still exists". But it's not a *Microsoft* bug :-)
To be a bug according to Microsoft, they would have needed to DESIGN Word to
remem...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.
...Exchange 2003 and public folder email address in distribution group
Hello! I would like to add an email address of one of my public folders to a
distribution list in exchange 2003. The public folder already has an email
address of firstname.lastname@example.org
problem is that I dont know how to select this when I try to add this email
in distribution groups. Any help would be great!
In ESM - go to the mail-enabled Public Folder's properties | Member Of tab |
"Dan J.S." <email@example.com> wrote in message
Is there a way to make something like =countif($a$1:$a$100,"=") work as
The function is returning zero when there are clearly cells with the text
"=" in it. If i were to use something like $a:$a as the range, it will just
count all the blank cells in column A.
Microsoft Excel MVP
"rockhammer" <firstname.lastname@example.org> wrote in message
> Is there a...Manager can update membership list check box
Hi, I'm working with W2K3 and E2K3. Is there a way to setup 'Active Directory
Users and Computers' on a workstation so that the check box for 'Manager can
update membership list check box' (Distribution Group, Managed by tab)
So far I can only make that work by remoting into an Exchange server, but
that won't work for administrators, we need them to do this from their
ADUC is probably overkill for just managing distribution group
memberships. Can the manager just manage them through Outlook by selecting
the properti...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
...Export univ dist group members to Excel or text file
Hello....my company recently migrated from Exch 5.5 to Exch 2003 (we are now
in native mode), and Windows 2003 AD. In 5.5, you used to be able to copy
members of a distribution list, and put into text file or Excel. I can not
seem to figure out how to do this with AD and Exchange 2003. Does anyone
know if this can be done? Thanks in advance for any help you can offer!!
All of the distribution list (mail-enabled groups now) and other recipient
information is stored in the Active Directory. Manipulating the Active
Directory is not quite as simple as manipulating the old Exchange dir..."Can't open this item" error
I have an email that's been sitting in my Inbox for about
three months. I can't delete it, reply to it, move it,
forward it, anything. I always get an error "Can't open
this item", "Unknow Error" etc.
Is there a way to get rid of the email. I heard that
Working Offline might work, but I don't know how to do
Can you please help?
Turn off the preview pane and see if you can now delete it.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and fin...