2k5: Interactive Sort - Total Line moving

When using the interactive column sort in a table, I have one report that the
Total (footer) actually moves with the interactive sort. How can I keep the
footer fixed as the footer?
--
Steve Funk
Application Developer
iHomeowners, Inc.Cancel this request. This report called a proc which I was not farmiliar
with and the stored proc sent over a calculated total line at the bottom of
the rows. The report footer was not being used.
--
Steve Funk
Application Developer
iHomeowners, Inc.
"Steve Funk" wrote:
> When using the interactive column sort in a table, I have one report that the
> Total (footer) actually moves with the interactive sort. How can I keep the
> footer fixed as the footer?
> --
> Steve Funk
> Application Developer
> iHomeowners, Inc.

2005 Internal Functions

There are several instances where I've seen this sort of thing:
%%ColumnEx(ObjectID = @.object_id, Name =
@.identity_column).SetIdentityNotForRepl(Value = @.value).
Anyone know what the full syntax is, where they are listed, if we can take
advantage of them etc?
TIA
Those are, as you noted, internal functions -- they are undocumented and
available only within the scope of the resource database. I haven't seen
anything yet, but I'm sure at some point someone will figure out how to hack
SQL Server to get a full list of them -- it's only a matter of time
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"JB" <JB@.Acme.Com> wrote in message
news:OujsIr2IGHA.3452@.TK2MSFTNGP12.phx.gbl...
> There are several instances where I've seen this sort of thing:
> %%ColumnEx(ObjectID = @.object_id, Name =
> @.identity_column).SetIdentityNotForRepl(Value = @.value).
> Anyone know what the full syntax is, where they are listed, if we can take
> advantage of them etc?
> TIA
>
|||I think that the proc sp_identitycolumnforreplication will do what you are
looking for. These system calls are only executable by system processes. You
may be able to find references to them in the system stored procedures and
functions. I don't know how to call them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JB" <JB@.Acme.Com> wrote in message
news:OujsIr2IGHA.3452@.TK2MSFTNGP12.phx.gbl...
> There are several instances where I've seen this sort of thing:
> %%ColumnEx(ObjectID = @.object_id, Name =
> @.identity_column).SetIdentityNotForRepl(Value = @.value).
> Anyone know what the full syntax is, where they are listed, if we can take
> advantage of them etc?
> TIA
>
|||And even if someone does, they are undocumented for a reason. There is no
guarantee they will function the same from one hotfix to another let alone
one service pack to another. What are you trying to do?
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uM7vn42IGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Those are, as you noted, internal functions -- they are undocumented and
> available only within the scope of the resource database. I haven't seen
> anything yet, but I'm sure at some point someone will figure out how to
> hack SQL Server to get a full list of them -- it's only a matter of time
>
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "JB" <JB@.Acme.Com> wrote in message
> news:OujsIr2IGHA.3452@.TK2MSFTNGP12.phx.gbl...
>

2005 Internal Functions

There are several instances where I've seen this sort of thing:
%%ColumnEx(ObjectID = @.object_id, Name = @.identity_column).SetIdentityNotForRepl(Value = @.value).
Anyone know what the full syntax is, where they are listed, if we can take
advantage of them etc?
TIAThose are, as you noted, internal functions -- they are undocumented and
available only within the scope of the resource database. I haven't seen
anything yet, but I'm sure at some point someone will figure out how to hack
SQL Server to get a full list of them -- it's only a matter of time :)
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"JB" <JB@.Acme.Com> wrote in message
news:OujsIr2IGHA.3452@.TK2MSFTNGP12.phx.gbl...
> There are several instances where I've seen this sort of thing:
> %%ColumnEx(ObjectID = @.object_id, Name => @.identity_column).SetIdentityNotForRepl(Value = @.value).
> Anyone know what the full syntax is, where they are listed, if we can take
> advantage of them etc?
> TIA
>|||I think that the proc sp_identitycolumnforreplication will do what you are
looking for. These system calls are only executable by system processes. You
may be able to find references to them in the system stored procedures and
functions. I don't know how to call them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JB" <JB@.Acme.Com> wrote in message
news:OujsIr2IGHA.3452@.TK2MSFTNGP12.phx.gbl...
> There are several instances where I've seen this sort of thing:
> %%ColumnEx(ObjectID = @.object_id, Name => @.identity_column).SetIdentityNotForRepl(Value = @.value).
> Anyone know what the full syntax is, where they are listed, if we can take
> advantage of them etc?
> TIA
>|||And even if someone does, they are undocumented for a reason. There is no
guarantee they will function the same from one hotfix to another let alone
one service pack to another. What are you trying to do?
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uM7vn42IGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Those are, as you noted, internal functions -- they are undocumented and
> available only within the scope of the resource database. I haven't seen
> anything yet, but I'm sure at some point someone will figure out how to
> hack SQL Server to get a full list of them -- it's only a matter of time
> :)
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "JB" <JB@.Acme.Com> wrote in message
> news:OujsIr2IGHA.3452@.TK2MSFTNGP12.phx.gbl...
>> There are several instances where I've seen this sort of thing:
>> %%ColumnEx(ObjectID = @.object_id, Name =>> @.identity_column).SetIdentityNotForRepl(Value = @.value).
>> Anyone know what the full syntax is, where they are listed, if we can
>> take advantage of them etc?
>> TIA
>>
>

2005 Internal Functions

There are several instances where I've seen this sort of thing:
%%ColumnEx(ObjectID = @.object_id, Name =
@.identity_column).SetIdentityNotForRepl(Value = @.value).
Anyone know what the full syntax is, where they are listed, if we can take
advantage of them etc?
TIAThose are, as you noted, internal functions -- they are undocumented and
available only within the scope of the resource database. I haven't seen
anything yet, but I'm sure at some point someone will figure out how to hack
SQL Server to get a full list of them -- it's only a matter of time
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"JB" <JB@.Acme.Com> wrote in message
news:OujsIr2IGHA.3452@.TK2MSFTNGP12.phx.gbl...
> There are several instances where I've seen this sort of thing:
> %%ColumnEx(ObjectID = @.object_id, Name =
> @.identity_column).SetIdentityNotForRepl(Value = @.value).
> Anyone know what the full syntax is, where they are listed, if we can take
> advantage of them etc?
> TIA
>|||I think that the proc sp_identitycolumnforreplication will do what you are
looking for. These system calls are only executable by system processes. You
may be able to find references to them in the system stored procedures and
functions. I don't know how to call them.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JB" <JB@.Acme.Com> wrote in message
news:OujsIr2IGHA.3452@.TK2MSFTNGP12.phx.gbl...
> There are several instances where I've seen this sort of thing:
> %%ColumnEx(ObjectID = @.object_id, Name =
> @.identity_column).SetIdentityNotForRepl(Value = @.value).
> Anyone know what the full syntax is, where they are listed, if we can take
> advantage of them etc?
> TIA
>|||And even if someone does, they are undocumented for a reason. There is no
guarantee they will function the same from one hotfix to another let alone
one service pack to another. What are you trying to do?
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uM7vn42IGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Those are, as you noted, internal functions -- they are undocumented and
> available only within the scope of the resource database. I haven't seen
> anything yet, but I'm sure at some point someone will figure out how to
> hack SQL Server to get a full list of them -- it's only a matter of time
>
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "JB" <JB@.Acme.Com> wrote in message
> news:OujsIr2IGHA.3452@.TK2MSFTNGP12.phx.gbl...
>

2005 Design Studio vs 2000 Enterprise manager

In 2000 you could sort a list of tables in the right hand window pane by
Create Date, Name, etc...
How do you accomplish that in 2005 ?
In Query daesigner you find a toolbar above the panel, (the same toolbar
where you find the "Report" icon. one of the available icons offers you two
ways to view the object conatined in a container: "List" or "Details"; the
default view is "List"; selecting "Details" you obtain a detailed list
organised on a per column basis; selecting a column name you sort the list by
that column (is a toggle: a first click orders ascending, the second orders
descending).
Gilberto Zampatti
"Rob" wrote:

> In 2000 you could sort a list of tables in the right hand window pane by
> Create Date, Name, etc...
> How do you accomplish that in 2005 ?
>
>

2005 Design Studio vs 2000 Enterprise manager

In 2000 you could sort a list of tables in the right hand window pane by
Create Date, Name, etc...
How do you accomplish that in 2005 ?In Query daesigner you find a toolbar above the panel, (the same toolbar
where you find the "Report" icon. one of the available icons offers you two
ways to view the object conatined in a container: "List" or "Details"; the
default view is "List"; selecting "Details" you obtain a detailed list
organised on a per column basis; selecting a column name you sort the list b
y
that column (is a toggle: a first click orders ascending, the second orders
descending).
Gilberto Zampatti
"Rob" wrote:

> In 2000 you could sort a list of tables in the right hand window pane by
> Create Date, Name, etc...
> How do you accomplish that in 2005 ?
>
>

2005 Design Studio vs 2000 Enterprise manager

In 2000 you could sort a list of tables in the right hand window pane by
Create Date, Name, etc...
How do you accomplish that in 2005 ?In Query daesigner you find a toolbar above the panel, (the same toolbar
where you find the "Report" icon. one of the available icons offers you two
ways to view the object conatined in a container: "List" or "Details"; the
default view is "List"; selecting "Details" you obtain a detailed list
organised on a per column basis; selecting a column name you sort the list by
that column (is a toggle: a first click orders ascending, the second orders
descending).
Gilberto Zampatti
"Rob" wrote:
> In 2000 you could sort a list of tables in the right hand window pane by
> Create Date, Name, etc...
> How do you accomplish that in 2005 ?
>
>