How to assign OR get Time value to a colum

How can i store time value in a column. And also i need to compare the values. Another problem is , how can i get the Current time of the server.(something like getdate() ?)

Happy Coding

hi,

there's no other function aside form getdate().

if you want it to be stored automatically to a column you have to enforce a "default constraint"

thanks,

joey

|||

MasterG wrote:

How can i store time value in a column. And also i need to compare the values. Another problem is , how can i get the Current time of the server.(something like getdate() ?)

Happy Coding

Hi,

Please see answer; http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1000324&SiteID=1

Most people wont like you double posting a question here, but it looks like your new so I guess everyone will let you off, just the once

Happy Coding!

hth
Pace|||

What a shame but sorry for duplicate post. But it is caused from my web browser. Sorry for that , and also thanks for your solution.

Very Happy Coding now ha .....

how to Archive the Flat files after they are loaded into a directory

I have to archive the Flat files after they are loaded into an archive folder with a Date time stamp on the folder in the format mmddyyyyhhmmss what task should i use in ssis to complete this and can i do this task for multiple files in the directory, how should i configure such that all files are archived and placed in one directory with a current timestamp, Please Provide me with a solution

Dev2624 wrote:

I have to archive the Flat files after they are loaded into an archive folder with a Date time stamp on the folder in the format mmddyyyyhhmmss what task should i use in ssis to complete this and can i do this task for multiple files in the directory, how should i configure such that all files are archived and placed in one directory with a current timestamp, Please Provide me with a solution

Use the FileSystem Task. You should also look into the MULTIFILE connection manager. See if these do what you want and if you have any problems, reply here.

-Jamie

|||

I am sorry if i had confused with my topic but what i want to do is once i load the Flat file into the dimension i want to archive that file in another directory with the current date time stamp. Please provide me the solution using ssis.

ex: source file abc.txt

i want to archive as abcmm/dd/yyyy.txt in archive folder say folderarchive

|||

I think Jamie pointed you in the right direction. See if this example takes you further:

http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html

|||

Dev2624 wrote:

I am sorry if i had confused with my topic but what i want to do is once i load the Flat file into the dimension i want to archive that file in another directory with the current date time stamp. Please provide me the solution using ssis.

ex: source file abc.txt

i want to archive as abcmm/dd/yyyy.txt in archive folder say folderarchive

I perfectly understand what you want to do and I am trying to help you. What I am NOT going to do is write the solution for you.

Have you identified that the FileSystem task can be used to move files? Hopefully you have. if you want to change the name of the file when you move it then use expressions.

This should particularly help:

Setting expressions

(http://blogs.conchango.com/jamiethomson/archive/2006/03/11/SSIS-Nugget_3A00_-Setting-expressions.aspx)

As might this:

Searching for "FileSystem" on the SSIS search macro

(http://search.live.com/results.aspx?FORM=QBJK&q1=macro%3Ajamiet.ssis&q=filesystem or http://search.live.com/results.aspx?q=file+system&form=QBRE&q1=macro%3Ajamiet.ssis)

Rafael also has a very good post on it:

File System Task Move and rename files in one step

(http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html)

-Jamie

|||

Jamie Thomson wrote:

Rafael also has a very good post on it:

File System Task Move and rename files in one step

(http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html)

As you now know seeing as he beat me to a reply

|||

Thanks for the quick responses , both the links provided me an insight i will be working on it and let both know about any further issues. Thanks for the response

|||

I was able to do that thanks for the help but i have one more thing ahead is that i have to rename the file using a value taken from the header row in the file. Do i need to use a global variable and capture header into that.

I am a newbie and your direction is encouraging i also need your guidance in checking whether a list of files exist in the directory or not how can i acheive that , i used scripting task to check for whether a single file exists but how to check for multiple files , is there a way we can configure the scripting task to check for list of files.

Please guide me

|||

If you need a data element that inside of the file; you can use an script task to get it.

There are several ways to check if a file already exists. If you already have an script task that check for 1 file; you could embed it in a ForEachLoop with a File enumerator to loop through all files in a directory.

how to Archive the Flat files after they are loaded into a directory

I have to archive the Flat files after they are loaded into an archive folder with a Date time stamp on the folder in the format mmddyyyyhhmmss what task should i use in ssis to complete this and can i do this task for multiple files in the directory, how should i configure such that all files are archived and placed in one directory with a current timestamp, Please Provide me with a solution

Dev2624 wrote:

I have to archive the Flat files after they are loaded into an archive folder with a Date time stamp on the folder in the format mmddyyyyhhmmss what task should i use in ssis to complete this and can i do this task for multiple files in the directory, how should i configure such that all files are archived and placed in one directory with a current timestamp, Please Provide me with a solution

Use the FileSystem Task. You should also look into the MULTIFILE connection manager. See if these do what you want and if you have any problems, reply here.

-Jamie

|||

I am sorry if i had confused with my topic but what i want to do is once i load the Flat file into the dimension i want to archive that file in another directory with the current date time stamp. Please provide me the solution using ssis.

ex: source file abc.txt

i want to archive as abcmm/dd/yyyy.txt in archive folder say folderarchive

|||

I think Jamie pointed you in the right direction. See if this example takes you further:

http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html

|||

Dev2624 wrote:

I am sorry if i had confused with my topic but what i want to do is once i load the Flat file into the dimension i want to archive that file in another directory with the current date time stamp. Please provide me the solution using ssis.

ex: source file abc.txt

i want to archive as abcmm/dd/yyyy.txt in archive folder say folderarchive

I perfectly understand what you want to do and I am trying to help you. What I am NOT going to do is write the solution for you.

Have you identified that the FileSystem task can be used to move files? Hopefully you have. if you want to change the name of the file when you move it then use expressions.

This should particularly help:

Setting expressions

(http://blogs.conchango.com/jamiethomson/archive/2006/03/11/SSIS-Nugget_3A00_-Setting-expressions.aspx)

As might this:

Searching for "FileSystem" on the SSIS search macro

(http://search.live.com/results.aspx?FORM=QBJK&q1=macro%3Ajamiet.ssis&q=filesystem or http://search.live.com/results.aspx?q=file+system&form=QBRE&q1=macro%3Ajamiet.ssis)

Rafael also has a very good post on it:

File System Task Move and rename files in one step

(http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html)

-Jamie

|||

Jamie Thomson wrote:

Rafael also has a very good post on it:

File System Task Move and rename files in one step

(http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html)

As you now know seeing as he beat me to a reply

|||

Thanks for the quick responses , both the links provided me an insight i will be working on it and let both know about any further issues. Thanks for the response

|||

I was able to do that thanks for the help but i have one more thing ahead is that i have to rename the file using a value taken from the header row in the file. Do i need to use a global variable and capture header into that.

I am a newbie and your direction is encouraging i also need your guidance in checking whether a list of files exist in the directory or not how can i acheive that , i used scripting task to check for whether a single file exists but how to check for multiple files , is there a way we can configure the scripting task to check for list of files.

Please guide me

|||

If you need a data element that inside of the file; you can use an script task to get it.

There are several ways to check if a file already exists. If you already have an script task that check for 1 file; you could embed it in a ForEachLoop with a File enumerator to loop through all files in a directory.

sql

How to Archive current sql server logs

Hi Guru's,
It takes me a long time to view in EM under Mangement/SQL Server Logs/current file. Is there a way I can shorten that file so it won't take so long to view the current file?
Thanks in advance. :eek:DBCC ERRORLOG will rotate the logs. I set up a job to rotate mine once per month.|||DBCC ERRORLOG will rotate the logs. I set up a job to rotate mine once per month.

sp_cycle_errorlog will achieve the same effect. You might also consider taking a look at sp_delete_ backuphistory.

Regards,

hmscott

How to archive current sql server logs

Hi Guru's,
It takes me a long time to view in EM under Mangement/SQL Server
Logs/current file. Is there a way I can shorten that file so it won't take so
long to view the current file?
Thanks in advance.
New SQL Server DBA
Hi
EXEC sp_cycle_errorlog
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:29D176A0-3569-437D-8F87-7E68DF978AF7@.microsoft.com...
> Hi Guru's,
> It takes me a long time to view in EM under Mangement/SQL Server
> Logs/current file. Is there a way I can shorten that file so it won't take
> so
> long to view the current file?
> Thanks in advance.
> --
> New SQL Server DBA
|||THANKS!
New SQL Server DBA
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> EXEC sp_cycle_errorlog
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:29D176A0-3569-437D-8F87-7E68DF978AF7@.microsoft.com...
>
>

How to archive current sql server logs

Hi Guru's,
It takes me a long time to view in EM under Mangement/SQL Server
Logs/current file. Is there a way I can shorten that file so it won't take so
long to view the current file?
Thanks in advance.
--
New SQL Server DBAHi
EXEC sp_cycle_errorlog
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:29D176A0-3569-437D-8F87-7E68DF978AF7@.microsoft.com...
> Hi Guru's,
> It takes me a long time to view in EM under Mangement/SQL Server
> Logs/current file. Is there a way I can shorten that file so it won't take
> so
> long to view the current file?
> Thanks in advance.
> --
> New SQL Server DBA|||THANKS!
--
New SQL Server DBA
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> EXEC sp_cycle_errorlog
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:29D176A0-3569-437D-8F87-7E68DF978AF7@.microsoft.com...
> > Hi Guru's,
> >
> > It takes me a long time to view in EM under Mangement/SQL Server
> > Logs/current file. Is there a way I can shorten that file so it won't take
> > so
> > long to view the current file?
> >
> > Thanks in advance.
> > --
> > New SQL Server DBA
>
>

How to archive current sql server logs

Hi Guru's,
It takes me a long time to view in EM under Mangement/SQL Server
Logs/current file. Is there a way I can shorten that file so it won't take s
o
long to view the current file?
Thanks in advance.
--
New SQL Server DBAHi
EXEC sp_cycle_errorlog
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:29D176A0-3569-437D-8F87-7E68DF978AF7@.microsoft.com...
> Hi Guru's,
> It takes me a long time to view in EM under Mangement/SQL Server
> Logs/current file. Is there a way I can shorten that file so it won't take
> so
> long to view the current file?
> Thanks in advance.
> --
> New SQL Server DBA|||THANKS!
--
New SQL Server DBA
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> EXEC sp_cycle_errorlog
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:29D176A0-3569-437D-8F87-7E68DF978AF7@.microsoft.com...
>
>

How to analyze SQLProfiler trace result ?

Hi All,
I plan to run SQL Profiler because my SQL Server 2000 get the users
timed out after running some time, and happen every day.
(see
[url]http://groups.google.co.id/group/microsoft.public.sqlserver.programming/browse_thr
ead/thread/fc287e2b9eb78b92/a05b0496982d258b?lnk=st&q=&rnum=24#a05b0496982d258b[/u
rl])
The question is :
After I get the trace recorded using Profiler, how can I check which
query that cause the problem ?
Or what I see any clue of the problem on the SQL Profiler result ?
Thank you very much,
xtantoA timeout is called "Attention" in Profiler. So make sure you catch that eve
nt. You can now go
backward for a SPID, from the Attention to the SQL:BatchStarted (or similar)
event to see what query
was timed out.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<krislioe@.gmail.com> wrote in message news:1155353854.603424.64300@.74g2000cwt.googlegroups.c
om...
> Hi All,
> I plan to run SQL Profiler because my SQL Server 2000 get the users
> timed out after running some time, and happen every day.
> (see
> [url]http://groups.google.co.id/group/microsoft.public.sqlserver.programming/browse_t
hread/thread/fc287e2b9eb78b92/a05b0496982d258b?lnk=st&q=&rnum=24#a05b0496982d258b[
/url])
> The question is :
> After I get the trace recorded using Profiler, how can I check which
> query that cause the problem ?
> Or what I see any clue of the problem on the SQL Profiler result ?
> Thank you very much,
> xtanto
>

How to analyze SQLProfiler trace result ?

Hi All,
I plan to run SQL Profiler because my SQL Server 2000 get the users
timed out after running some time, and happen every day.
(see
http://groups.google.co.id/group/microsoft.public.sqlserver.programming/browse_thread/thread/fc287e2b9eb78b92/a05b0496982d258b?lnk=st&q=&rnum=24#a05b0496982d258b)
The question is :
After I get the trace recorded using Profiler, how can I check which
query that cause the problem ?
Or what I see any clue of the problem on the SQL Profiler result ?
Thank you very much,
xtantoA timeout is called "Attention" in Profiler. So make sure you catch that event. You can now go
backward for a SPID, from the Attention to the SQL:BatchStarted (or similar) event to see what query
was timed out.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<krislioe@.gmail.com> wrote in message news:1155353854.603424.64300@.74g2000cwt.googlegroups.com...
> Hi All,
> I plan to run SQL Profiler because my SQL Server 2000 get the users
> timed out after running some time, and happen every day.
> (see
> http://groups.google.co.id/group/microsoft.public.sqlserver.programming/browse_thread/thread/fc287e2b9eb78b92/a05b0496982d258b?lnk=st&q=&rnum=24#a05b0496982d258b)
> The question is :
> After I get the trace recorded using Profiler, how can I check which
> query that cause the problem ?
> Or what I see any clue of the problem on the SQL Profiler result ?
> Thank you very much,
> xtanto
>|||Hi Tibor,
Thanks for your answer.
Actually what I want to find with Profiler is not the query that was
timed out, because when the "specific condition" met, "any queries" to
the server, from "any user" will get timed out.
So my goal is to find What Has caused this "specific condition" ?
Thank you very much,
xtanto
Tibor Karaszi menuliskan:
> A timeout is called "Attention" in Profiler. So make sure you catch that event. You can now go
> backward for a SPID, from the Attention to the SQL:BatchStarted (or similar) event to see what query
> was timed out.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <krislioe@.gmail.com> wrote in message news:1155353854.603424.64300@.74g2000cwt.googlegroups.com...
> > Hi All,
> >
> > I plan to run SQL Profiler because my SQL Server 2000 get the users
> > timed out after running some time, and happen every day.
> > (see
> > http://groups.google.co.id/group/microsoft.public.sqlserver.programming/browse_thread/thread/fc287e2b9eb78b92/a05b0496982d258b?lnk=st&q=&rnum=24#a05b0496982d258b)
> >
> > The question is :
> > After I get the trace recorded using Profiler, how can I check which
> > query that cause the problem ?
> > Or what I see any clue of the problem on the SQL Profiler result ?
> >
> > Thank you very much,
> > xtanto
> >

how to Allow Multiple access to data base over network

Hello All, I have a running/ woking database, but only one user can
access the data base at a time on the newtork, If more than one user
try accessing the database, it will frezee until the first to grab the
data base logs out. Please how do I solve this problem. I have sql 2000
enterprise edition running on the server.
Regards
Agboola.1default wrote:
> Hello All, I have a running/ woking database, but only one user can
> access the data base at a time on the newtork, If more than one user
> try accessing the database, it will frezee until the first to grab the
> data base logs out. Please how do I solve this problem. I have sql 2000
> enterprise edition running on the server.
> Regards
> Agboola.
>
First, check the database properties to make sure it's not in
Single-User mode. However, that doesn't sound like your problem.
What exactly freezes up? It sounds like your first user is doing
something that is blocking other users. You can confirm that by
querying the sysprocesses table in the master database, or by issuing
the command 'sp_who2' in Query Analyzer.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Looks like you have the database in restricted or single user mode. But you
should receive messages like these, instead of freezing the session:
Database 'Northwind' is already open and can only have one user at a time.
Database 'Northwind' is in restricted mode. Only the database owner and
members of the dbcreator and sysadmin roles can access it.
Try this first: Using Enterprise Manager, right-click your database,
Properties, select the Options tab and make sure the Restrict access option
is not checked.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"1default" wrote:
> Hello All, I have a running/ woking database, but only one user can
> access the data base at a time on the newtork, If more than one user
> try accessing the database, it will frezee until the first to grab the
> data base logs out. Please how do I solve this problem. I have sql 2000
> enterprise edition running on the server.
> Regards
> Agboola.
>

how to Allow Multiple access to data base over network

Hello All, I have a running/ woking database, but only one user can
access the data base at a time on the newtork, If more than one user
try accessing the database, it will frezee until the first to grab the
data base logs out. Please how do I solve this problem. I have sql 2000
enterprise edition running on the server.
Regards
Agboola.1default wrote:
> Hello All, I have a running/ woking database, but only one user can
> access the data base at a time on the newtork, If more than one user
> try accessing the database, it will frezee until the first to grab the
> data base logs out. Please how do I solve this problem. I have sql 2000
> enterprise edition running on the server.
> Regards
> Agboola.
>
First, check the database properties to make sure it's not in
Single-User mode. However, that doesn't sound like your problem.
What exactly freezes up? It sounds like your first user is doing
something that is blocking other users. You can confirm that by
querying the sysprocesses table in the master database, or by issuing
the command 'sp_who2' in Query Analyzer.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Looks like you have the database in restricted or single user mode. But you
should receive messages like these, instead of freezing the session:
Database 'Northwind' is already open and can only have one user at a time.
Database 'Northwind' is in restricted mode. Only the database owner and
members of the dbcreator and sysadmin roles can access it.
Try this first: Using Enterprise Manager, right-click your database,
Properties, select the Options tab and make sure the Restrict access option
is not checked.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"1default" wrote:

> Hello All, I have a running/ woking database, but only one user can
> access the data base at a time on the newtork, If more than one user
> try accessing the database, it will frezee until the first to grab the
> data base logs out. Please how do I solve this problem. I have sql 2000
> enterprise edition running on the server.
> Regards
> Agboola.
>

How to add YTD (Calculation) to Time Dimension?

Is there any you can add YTD to Time Dimension as attribute? Or it has to be Calculation? Then how do we do this? Is this need to base on Dimension or Measure? I would prefer this to be base on dimension and show in Time dimension hierarchy.

Any inputs on this are highly appreciated.

If you are using Analysis Services 2005 you can open the cube editor and then click on the "Add Business Intelligence" button you will get a wizard that will guide you through the process of adding a "Period Calculations" attribute hierarchy to your time dimension which can be used to support YTD, QTD, MTD and other period calculations.

The following is a link to an excellent article on the "Time Intelligence" wizard that was published in SQLServer magazine:

http://www.windowsitpro.com/Article/ArticleID/46157/46157.html

|||

Although you need to be aware that some of the calculations produced by the Time Intelligence Wizard, including the YTD calculation, don't actually work. See:

http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!379.entry

|||

There are several ways to accomplish this. If your users want a way to select Monthly values vs, QTD, YTD from a selector/slicer you will need to create a Time Utility Dim or a Time Ref Dim.

This Dim will only contain one member for the lowest level of detail. ie. Month or Daily. You would then create calculated members to compute YTD and anyother values that are based on what the user has selected in the Time Dim.

|||Can this be done in AS 2005?

How to add YTD (Calculation) to Time Dimension?

Is there any you can add YTD to Time Dimension as attribute? Or it has to be Calculation? Then how do we do this? Is this need to base on Dimension or Measure? I would prefer this to be base on dimension and show in Time dimension hierarchy.

Any inputs on this are highly appreciated.

If you are using Analysis Services 2005 you can open the cube editor and then click on the "Add Business Intelligence" button you will get a wizard that will guide you through the process of adding a "Period Calculations" attribute hierarchy to your time dimension which can be used to support YTD, QTD, MTD and other period calculations.

The following is a link to an excellent article on the "Time Intelligence" wizard that was published in SQLServer magazine:

http://www.windowsitpro.com/Article/ArticleID/46157/46157.html

|||

Although you need to be aware that some of the calculations produced by the Time Intelligence Wizard, including the YTD calculation, don't actually work. See:

http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!379.entry

|||

There are several ways to accomplish this. If your users want a way to select Monthly values vs, QTD, YTD from a selector/slicer you will need to create a Time Utility Dim or a Time Ref Dim.

This Dim will only contain one member for the lowest level of detail. ie. Month or Daily. You would then create calculated members to compute YTD and anyother values that are based on what the user has selected in the Time Dim.

|||Can this be done in AS 2005?

How to add Total to Matrx Column/Row

Hi there,
I have a report with 2 column groupings and 5 row groupings looks like
this:
+Unit
+Time
+Type +Sub_Type +Start +Result +Orig SUM(!Field1.Value)
I want to add "Total" to every column and every row and final total
like this:
+Unit
+Time
+Type +Sub_Type +Start +Result +Orig SUM(!Fieldxx) Total_of_Row
Total_of_Column Total
How can I add a column at the right end and a row at the bottom? What
kind of expression should I use?
Thanks a lot.
HenryHenry,
I'm not sure how far along you are but I found out how to add Row & column
subtotals by accident. In Layout mode, right click your "Row" or "Coumn"
field and select SubTotal. THe problem I am experiencing is you have very
limited control over the style. ie wanting the subtotals to be bolded.
Hope this helps - Glen
"Henry" wrote:
> Hi there,
> I have a report with 2 column groupings and 5 row groupings looks like
> this:
> +Unit
> +Time
> +Type +Sub_Type +Start +Result +Orig SUM(!Field1.Value)
> I want to add "Total" to every column and every row and final total
> like this:
> +Unit
> +Time
> +Type +Sub_Type +Start +Result +Orig SUM(!Fieldxx) Total_of_Row
> Total_of_Column Total
> How can I add a column at the right end and a row at the bottom? What
> kind of expression should I use?
> Thanks a lot.
> Henry
>|||It works well, Thanks a lot.
Henry
"Glen" <Glen@.discussions.microsoft.com> wrote in message news:<27B4E130-0C08-49DA-82B2-8E94B66B0216@.microsoft.com>...
> Henry,
> I'm not sure how far along you are but I found out how to add Row & column
> subtotals by accident. In Layout mode, right click your "Row" or "Coumn"
> field and select SubTotal. THe problem I am experiencing is you have very
> limited control over the style. ie wanting the subtotals to be bolded.
> Hope this helps - Glen
> "Henry" wrote:
> > Hi there,
> >
> > I have a report with 2 column groupings and 5 row groupings looks like
> > this:
> >
> > +Unit
> > +Time
> > +Type +Sub_Type +Start +Result +Orig SUM(!Field1.Value)
> >
> > I want to add "Total" to every column and every row and final total
> > like this:
> >
> > +Unit
> > +Time
> > +Type +Sub_Type +Start +Result +Orig SUM(!Fieldxx) Total_of_Row
> > Total_of_Column Total
> >
> > How can I add a column at the right end and a row at the bottom? What
> > kind of expression should I use?
> > Thanks a lot.
> >
> > Henry
> >

How To Add Time Field In Crystal Reports 4.6

I want to add Date and Time details in my Report. (Crystal Reports 4.6) Date is ok, But I can't add time field. Please help me to do that.
Regards,
Supunu got two special fields print date and print time use them

How to add time dependent calculed mesure

Is there a way to add time dependent calculed mesure for ex (Delta% of a standard mesure which represent its evolution within the time dimension)

Regards

I guess you're looking for something like this (from Foodmart 2000):

with member [Measures].[Delta] as '[Measures].[Unit Sales]-([Measures].[Unit Sales],[Time].currentmember.lag(1))'

select {[Measures].[Unit Sales],[Measures].[Delta]} on 0,
{[Time].members} on 1
from sales

How to add speed when run sql execute command?

Hi,
the problem i'm facing when i run the sql is when i run
the command- executenonquery or executescalar(), the
system needs a long time to process before come out a
result.
i'm using Intel P4 1.5GHz, 256 RAM.
Can anyone tell me that how to add speed when execute the
sql command'?
thanks.There can be many reasons why the command executes slowly. DDL statements
(Cretae Table etc.), demo data (Insert statements) and the command you re
sending would definitely help solving the problem. You can use Query
Analyzer to anayze the T-SQL query you are sending - you can see the
execution plan and find worst operations, like table scans, sorts...
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"florencelee@.visualsolutions.com.my" <anonymous@.discussions.microsoft.com>
wrote in message news:10a6401c3f435$2e416eb0$a001280a@.phx.gbl...
> Hi,
> the problem i'm facing when i run the sql is when i run
> the command- executenonquery or executescalar(), the
> system needs a long time to process before come out a
> result.
> i'm using Intel P4 1.5GHz, 256 RAM.
> Can anyone tell me that how to add speed when execute the
> sql command'?
> thanks.|||What sort of command are you executing? It will be a good idea to have a
look at the actual query.
--
With Regards,
Deepak
[I code, therefore I am]
http://deepakictim.blogspot.com
"florencelee@.visualsolutions.com.my" <anonymous@.discussions.microsoft.com>
wrote in message news:10a6401c3f435$2e416eb0$a001280a@.phx.gbl...
> Hi,
> the problem i'm facing when i run the sql is when i run
> the command- executenonquery or executescalar(), the
> system needs a long time to process before come out a
> result.
> i'm using Intel P4 1.5GHz, 256 RAM.
> Can anyone tell me that how to add speed when execute the
> sql command'?
> thanks.

How to add speed when run sql execute command?

Hi,
the problem i'm facing when i run the sql is when i run
the command- executenonquery or executescalar(), the
system needs a long time to process before come out a
result.
i'm using Intel P4 1.5GHz, 256 RAM.
Can anyone tell me that how to add speed when execute the
sql command'?
thanks.There can be many reasons why the command executes slowly. DDL statements
(Cretae Table etc.), demo data (Insert statements) and the command you re
sending would definitely help solving the problem. You can use Query
Analyzer to anayze the T-SQL query you are sending - you can see the
execution plan and find worst operations, like table scans, sorts...
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"florencelee@.visualsolutions.com.my" <anonymous@.discussions.microsoft.com>
wrote in message news:10a6401c3f435$2e416eb0$a001280a@.phx
.gbl...
> Hi,
> the problem i'm facing when i run the sql is when i run
> the command- executenonquery or executescalar(), the
> system needs a long time to process before come out a
> result.
> i'm using Intel P4 1.5GHz, 256 RAM.
> Can anyone tell me that how to add speed when execute the
> sql command'?
> thanks.|||What sort of command are you executing? It will be a good idea to have a
look at the actual query.
--
With Regards,
Deepak
[I code, therefore I am]
http://deepakictim.blogspot.com
"florencelee@.visualsolutions.com.my" <anonymous@.discussions.microsoft.com>
wrote in message news:10a6401c3f435$2e416eb0$a001280a@.phx
.gbl...
> Hi,
> the problem i'm facing when i run the sql is when i run
> the command- executenonquery or executescalar(), the
> system needs a long time to process before come out a
> result.
> i'm using Intel P4 1.5GHz, 256 RAM.
> Can anyone tell me that how to add speed when execute the
> sql command'?
> thanks.

how to add report "Templates" to list during wizard?

Hi, I'd like to customize the new report wizard to save me time in building reports.

I know that with most of VS there are files I can copy and edit to do that for new projects, forms, classes etc...

where are they for new reports?Hi,

Well, it actually depends on what you are naming "templates" in the Wizard.

1- If you are referring to the Styles you see at the very end of the wizard, you can add new styles editing the following XML file:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\StyleTemplates.xml

AND the equivalent ones located in the "resource" subfolders like:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\en\StyleTemplates.xml

Of course, make a copy of each file before editing them.

the only caveat is that I do not know where the "preview" image is stored, therefore your style is "blind". May be you can invest some time to find out or someone can jump in with that info.

2- On the other side, if you refer to the "Table/Matrix" and "Stepped" Wizard tab, I gues it is hardcoded.

3- If you refer to the "item types" you can add when adding a new item (not in the wizard, therefore). You can follow Russell Christopher's in http://blogs.msdn.com/bimusings/archive/2005/12/06/500462.aspx

Hope this helps,

Jordi Rambla
SQL Server MVP (Reporting Services)
SolidQualityLearning Iberoamericana|||

Jordi Rambla wrote:

Hi,

Well, it actually depends on what you are naming "templates" in the Wizard.

1- If you are referring to the Styles you see at the very end of the wizard, you can add new styles editing the following XML file:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\StyleTemplates.xml

AND the equivalent ones located in the "resource" subfolders like:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\en\StyleTemplates.xml

Of course, make a copy of each file before editing them.

the only caveat is that I do not know where the "preview" image is stored, therefore your style is "blind". May be you can invest some time to find out or someone can jump in with that info.

2- On the other side, if you refer to the "Table/Matrix" and "Stepped" Wizard tab, I gues it is hardcoded.

3- If you refer to the "item types" you can add when adding a new item (not in the wizard, therefore). You can follow Russell Christopher's in http://blogs.msdn.com/bimusings/archive/2005/12/06/500462.aspx

Hope this helps,

Jordi Rambla
SQL Server MVP (Reporting Services)
SolidQualityLearning Iberoamericana

Yeah, I dug out my copy of the hitchhikers guide to sql rs 2000 and it has this info from the 2000 version and looks like it's almost the same in 2005.

by the way what I have is about 10-15 reports created by another dev where he created each one with a common look, font, page head, foot, title etc...
and the boss likes the look. that guy is now gone -- took a different job.
so I want to capture as much of his settings as I can so that when I create a new report I do not have to spend to much time just chnaging colors and fonts to match what he did.

how to add more than one recored to sql table in the same time

i want to add more than one row in the same time i tried to use for loop but didnt work any ideas please

Please post exactly what you want to do with table names.

|||

Can you show us your code and maybe someone can help you figure out why its not working