Did I get current source code?

Hi,
I have been working with a programmer overseas for the past six months.
Every so often I request and get the source code for a Delphi program
running on MSSQL. My question please is, how can I tell if I am getting
valid or current source code?
regards,
s
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.805 / Virus Database: 547 - Release Date: 03-Dec-04Use Delphi to compile and test it?
This isn't a SQL Server question.
David Portas
SQL Server MVP
--

Diagram, sorting and series groups

Say you have two values for each region: current month and previous month. I
have a column in datase called period_offset (0 for current month and -1 for
previous month).
I want to sort the diagram over current month, where previous month is just
for informational purposes (previous month is also colored gray, btw).
For series group, I have =Fields!period_offset.Value, and under sorting:
=Fields!period_offset.Value.
Currently, the diagram seem to sort by the previous month value (where
=Fields!period_offset.Value = -1). How can I sort by current month
(=Fields!period_offset.Value = 0) ?
Thanks
TiborWhere I say "Diagram", I'm referring to the chart control, btw.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
> Say you have two values for each region: current month and previous month.
I
> have a column in datase called period_offset (0 for current month and -1
for
> previous month).
> I want to sort the diagram over current month, where previous month is
just
> for informational purposes (previous month is also colored gray, btw).
> For series group, I have =Fields!period_offset.Value, and under sorting:
> =Fields!period_offset.Value.
> Currently, the diagram seem to sort by the previous month value (where
> =Fields!period_offset.Value = -1). How can I sort by current month
> (=Fields!period_offset.Value = 0) ?
> Thanks
> Tibor
>|||It seems like the order for the rows are determined from the order returned
in the SQL Query. When I add an ORDER BY to the query so that for each
region, that current month is returned before last month, the diagram is
sorted over the current month column.
I can change ASC/DESC in my SQL ORDER BY and the sort in the diagram changes
accordingly...
Is above assumption correct?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u%23te0gkmEHA.644@.tk2msftngp13.phx.gbl...
> Where I say "Diagram", I'm referring to the chart control, btw.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
> > Say you have two values for each region: current month and previous
month.
> I
> > have a column in datase called period_offset (0 for current month and -1
> for
> > previous month).
> >
> > I want to sort the diagram over current month, where previous month is
> just
> > for informational purposes (previous month is also colored gray, btw).
> >
> > For series group, I have =Fields!period_offset.Value, and under sorting:
> > =Fields!period_offset.Value.
> >
> > Currently, the diagram seem to sort by the previous month value (where
> > =Fields!period_offset.Value = -1). How can I sort by current month
> > (=Fields!period_offset.Value = 0) ?
> >
> > Thanks
> > Tibor
> >
> >
>|||Unless you define an explicit sort expression on the chart series grouping
or the chart or the dataset, the data will be processed and grouped in RS in
the order they come from the data provider.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uwo5nkkmEHA.1652@.TK2MSFTNGP09.phx.gbl...
> It seems like the order for the rows are determined from the order
returned
> in the SQL Query. When I add an ORDER BY to the query so that for each
> region, that current month is returned before last month, the diagram is
> sorted over the current month column.
> I can change ASC/DESC in my SQL ORDER BY and the sort in the diagram
changes
> accordingly...
> Is above assumption correct?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:u%23te0gkmEHA.644@.tk2msftngp13.phx.gbl...
> > Where I say "Diagram", I'm referring to the chart control, btw.
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> > message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
> > > Say you have two values for each region: current month and previous
> month.
> > I
> > > have a column in datase called period_offset (0 for current month
and -1
> > for
> > > previous month).
> > >
> > > I want to sort the diagram over current month, where previous month is
> > just
> > > for informational purposes (previous month is also colored gray, btw).
> > >
> > > For series group, I have =Fields!period_offset.Value, and under
sorting:
> > > =Fields!period_offset.Value.
> > >
> > > Currently, the diagram seem to sort by the previous month value (where
> > > =Fields!period_offset.Value = -1). How can I sort by current month
> > > (=Fields!period_offset.Value = 0) ?
> > >
> > > Thanks
> > > Tibor
> > >
> > >
> >
> >
>|||Thanks Robert. This is in line with what I have experienced.
In this particular situation, I just couldn't get RS to sort the way I wanted...
But I did manage when combining sorting on Group/Series and in the SQL query. I'll probably stick
with what I have until I have the time to learn enough about sorting and the relation between
sorting in grouping vs. series.
I found the documentation lacking information rather severely in this area, I should add. And it
just wasn't intuitive enough for me. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23u3BxyzmEHA.2140@.TK2MSFTNGP11.phx.gbl...
> Unless you define an explicit sort expression on the chart series grouping
> or the chart or the dataset, the data will be processed and grouped in RS in
> the order they come from the data provider.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uwo5nkkmEHA.1652@.TK2MSFTNGP09.phx.gbl...
>> It seems like the order for the rows are determined from the order
> returned
>> in the SQL Query. When I add an ORDER BY to the query so that for each
>> region, that current month is returned before last month, the diagram is
>> sorted over the current month column.
>> I can change ASC/DESC in my SQL ORDER BY and the sort in the diagram
> changes
>> accordingly...
>> Is above assumption correct?
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
>> message news:u%23te0gkmEHA.644@.tk2msftngp13.phx.gbl...
>> > Where I say "Diagram", I'm referring to the chart control, btw.
>> >
>> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in
>> > message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
>> > > Say you have two values for each region: current month and previous
>> month.
>> > I
>> > > have a column in datase called period_offset (0 for current month
> and -1
>> > for
>> > > previous month).
>> > >
>> > > I want to sort the diagram over current month, where previous month is
>> > just
>> > > for informational purposes (previous month is also colored gray, btw).
>> > >
>> > > For series group, I have =Fields!period_offset.Value, and under
> sorting:
>> > > =Fields!period_offset.Value.
>> > >
>> > > Currently, the diagram seem to sort by the previous month value (where
>> > > =Fields!period_offset.Value = -1). How can I sort by current month
>> > > (=Fields!period_offset.Value = 0) ?
>> > >
>> > > Thanks
>> > > Tibor
>> > >
>> > >
>> >
>> >
>>
>|||Regarding BOL:
Yes, our UE/documentation team is working on improving the entire charting
documentation. Updates should be available on MSDN in the next few months.
Regarding sorting:
Grouping/sorting specified in the commandtext is done on the data source's
database server. Grouping/sorting/filtering defined in the RDL is done in
the RS processing engine internally.
If you specify a sort expression on group expressions in the report, the
processing engine will apply sorting. I.e. if you don't specify any explicit
collation settings on the RDL dataset, we will - in case of a live execution
against a SQL 2000 data source - determine the collation settings from the
data source. Otherwise, we will do sorting based on the culture settings of
the report.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e3fKkA1mEHA.2140@.TK2MSFTNGP11.phx.gbl...
> Thanks Robert. This is in line with what I have experienced.
> In this particular situation, I just couldn't get RS to sort the way I
wanted...
> But I did manage when combining sorting on Group/Series and in the SQL
query. I'll probably stick
> with what I have until I have the time to learn enough about sorting and
the relation between
> sorting in grouping vs. series.
> I found the documentation lacking information rather severely in this
area, I should add. And it
> just wasn't intuitive enough for me. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:%23u3BxyzmEHA.2140@.TK2MSFTNGP11.phx.gbl...
> > Unless you define an explicit sort expression on the chart series
grouping
> > or the chart or the dataset, the data will be processed and grouped in
RS in
> > the order they come from the data provider.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:uwo5nkkmEHA.1652@.TK2MSFTNGP09.phx.gbl...
> >> It seems like the order for the rows are determined from the order
> > returned
> >> in the SQL Query. When I add an ORDER BY to the query so that for each
> >> region, that current month is returned before last month, the diagram
is
> >> sorted over the current month column.
> >>
> >> I can change ASC/DESC in my SQL ORDER BY and the sort in the diagram
> > changes
> >> accordingly...
> >>
> >> Is above assumption correct?
> >>
> >>
> >> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote
> > in
> >> message news:u%23te0gkmEHA.644@.tk2msftngp13.phx.gbl...
> >> > Where I say "Diagram", I'm referring to the chart control, btw.
> >> >
> >> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote
> >> in
> >> > message news:uC169yjmEHA.3396@.tk2msftngp13.phx.gbl...
> >> > > Say you have two values for each region: current month and previous
> >> month.
> >> > I
> >> > > have a column in datase called period_offset (0 for current month
> > and -1
> >> > for
> >> > > previous month).
> >> > >
> >> > > I want to sort the diagram over current month, where previous month
is
> >> > just
> >> > > for informational purposes (previous month is also colored gray,
btw).
> >> > >
> >> > > For series group, I have =Fields!period_offset.Value, and under
> > sorting:
> >> > > =Fields!period_offset.Value.
> >> > >
> >> > > Currently, the diagram seem to sort by the previous month value
(where
> >> > > =Fields!period_offset.Value = -1). How can I sort by current month
> >> > > (=Fields!period_offset.Value = 0) ?
> >> > >
> >> > > Thanks
> >> > > Tibor
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >
> >
>

Diagnose SQL Procedures.

Hi there,
Is there any way I can create one user defined stored procedure that will
let me know all the stored procedure and functions in current database have
compiled successfully, there is no compilation error in the stored
procedures ?
Basically, I have a database and there are around 90 stored procedure and I
want to check all the stored procedures compiled successfully or still they
need to compiled so I need any query or stored procedure through which I can
diagnose this...
Thanks in advance
What exactly do you mean by compile? Sp's only get compiled the first time
they are run. They get parsed and checked when you create them. There really
isn't anything such as an unsuccessful compilation.
Andrew J. Kelly SQL MVP
"Rogers" <naissani@.hotmail.com> wrote in message
news:%23VA1H30MGHA.1132@.TK2MSFTNGP10.phx.gbl...
> Hi there,
> Is there any way I can create one user defined stored procedure that will
> let me know all the stored procedure and functions in current database
> have compiled successfully, there is no compilation error in the stored
> procedures ?
> Basically, I have a database and there are around 90 stored procedure and
> I want to check all the stored procedures compiled successfully or still
> they need to compiled so I need any query or stored procedure through
> which I can diagnose this...
> Thanks in advance
>
|||Andrew J. Kelly wrote:
> What exactly do you mean by compile? Sp's only get compiled the
> first time they are run. They get parsed and checked when you create
> them. There really isn't anything such as an unsuccessful compilation.
Maybe he wants to know how to verify existing procedures against a
schema that has changed. If that's the case, there's some information
here that might help:
http://groups.google.com/group/micro...eb685e696368c1
David Gugick - SQL Server MVP
Quest Software

Development Direction

I'm hoping that someone can suggest a direction for me to get started to
update a current application that I built several years ago. I want to move
the following application to our organization's intranet and will need to get
training in the best method to achieve this. I am versed in Office VBA and
VB 6.0 but have not moved into the .NET arena yet.
The application in question uses SQL Server 2000 as a back end and Access
2000 for the front end. Users basically select options on an Access form
that is used in a pass-through query to SQL Server. The query logs into the
server runs the query and returns the data, not to Access, but to an Excel
spreadsheet. I did this at the request of the users and they have been very
happy with it for many years.
The problem lies when users get new machines or have their machines
re-imaged and our computer support group has to re-install yet another
application. It would be great if I could figure out a way to build a
web-enabled version of this application and it has been beyond the scope of
my knowledge for some time now. I would really appreciate any suggestions
you might have or if you feel I need to direct this question to a different
newsgroup. Please advise. Thank you... AlIf you are able to use Reporting Services this is pretty easy to do what you
want. You have the queries designed. They can use the portal that ships with
RS (Report Manager). Select the parameters and view the report and then
export to Excel. If you had your own web page you could go directly to Excel
but since you don't want to be creating your own web app my suggestion
totally uses the feature of RS. You design and deploy the report and there
you are BUT the problem is going to be the administration. It requires
having RS server somewhere that you can deploy against.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Al" <Al@.discussions.microsoft.com> wrote in message
news:FD312550-1020-4D2B-B913-AE40BB5A28BC@.microsoft.com...
> I'm hoping that someone can suggest a direction for me to get started to
> update a current application that I built several years ago. I want to
> move
> the following application to our organization's intranet and will need to
> get
> training in the best method to achieve this. I am versed in Office VBA
> and
> VB 6.0 but have not moved into the .NET arena yet.
> The application in question uses SQL Server 2000 as a back end and Access
> 2000 for the front end. Users basically select options on an Access form
> that is used in a pass-through query to SQL Server. The query logs into
> the
> server runs the query and returns the data, not to Access, but to an Excel
> spreadsheet. I did this at the request of the users and they have been
> very
> happy with it for many years.
> The problem lies when users get new machines or have their machines
> re-imaged and our computer support group has to re-install yet another
> application. It would be great if I could figure out a way to build a
> web-enabled version of this application and it has been beyond the scope
> of
> my knowledge for some time now. I would really appreciate any suggestions
> you might have or if you feel I need to direct this question to a
> different
> newsgroup. Please advise. Thank you... Al