iam working on cryastal reports 8.5
iam facing one problem
how to apply the left top corner text in crosstab so that it sholud be in every page
for me it is there in only one page it is not coming in other page
please if any one as solution post me
waiting for replyDid you use formula and place it there?sql
Showing posts with label facing. Show all posts
Showing posts with label facing. Show all posts
Monday, March 26, 2012
Monday, March 19, 2012
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.
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.
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.
Friday, February 24, 2012
how to add a field in existing table database
im facing some problem.i wantto add a single field with 15varchar but it
couldnt i have tried before it works fine but know it gives me message as
(Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
able to findout ecaxt solution need your suggestion with appropriate solution.
Hi
Look up the ALTER TABLE command in Books online or at
http://msdn.microsoft.com/library/de...asp?frame=true
and use the version:
ALTER TABLE MyTable ADD mycolumn verchar(15)
You may have to use an UPDATE statement afterwards to update the existing
data.
John
"shoeb" <shoeb@.discussions.microsoft.com> wrote in message
news:C3E6D6B8-2B0D-4F0F-AA3C-1F4DA38FCC04@.microsoft.com...
> im facing some problem.i wantto add a single field with 15varchar but it
> couldnt i have tried before it works fine but know it gives me message as
> (Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
> able to findout ecaxt solution need your suggestion with appropriate
> solution.
couldnt i have tried before it works fine but know it gives me message as
(Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
able to findout ecaxt solution need your suggestion with appropriate solution.
Hi
Look up the ALTER TABLE command in Books online or at
http://msdn.microsoft.com/library/de...asp?frame=true
and use the version:
ALTER TABLE MyTable ADD mycolumn verchar(15)
You may have to use an UPDATE statement afterwards to update the existing
data.
John
"shoeb" <shoeb@.discussions.microsoft.com> wrote in message
news:C3E6D6B8-2B0D-4F0F-AA3C-1F4DA38FCC04@.microsoft.com...
> im facing some problem.i wantto add a single field with 15varchar but it
> couldnt i have tried before it works fine but know it gives me message as
> (Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
> able to findout ecaxt solution need your suggestion with appropriate
> solution.
how to add a field in existing table database
im facing some problem.i wantto add a single field with 15varchar but it
couldnt i have tried before it works fine but know it gives me message as
(Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
able to findout ecaxt solution need your suggestion with appropriate solutio
n.Hi
Look up the ALTER TABLE command in Books online or at
http://msdn.microsoft.com/library/d...asp?frame=true
and use the version:
ALTER TABLE MyTable ADD mycolumn verchar(15)
You may have to use an UPDATE statement afterwards to update the existing
data.
John
"shoeb" <shoeb@.discussions.microsoft.com> wrote in message
news:C3E6D6B8-2B0D-4F0F-AA3C-1F4DA38FCC04@.microsoft.com...
> im facing some problem.i wantto add a single field with 15varchar but it
> couldnt i have tried before it works fine but know it gives me message as
> (Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
> able to findout ecaxt solution need your suggestion with appropriate
> solution.
couldnt i have tried before it works fine but know it gives me message as
(Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
able to findout ecaxt solution need your suggestion with appropriate solutio
n.Hi
Look up the ALTER TABLE command in Books online or at
http://msdn.microsoft.com/library/d...asp?frame=true
and use the version:
ALTER TABLE MyTable ADD mycolumn verchar(15)
You may have to use an UPDATE statement afterwards to update the existing
data.
John
"shoeb" <shoeb@.discussions.microsoft.com> wrote in message
news:C3E6D6B8-2B0D-4F0F-AA3C-1F4DA38FCC04@.microsoft.com...
> im facing some problem.i wantto add a single field with 15varchar but it
> couldnt i have tried before it works fine but know it gives me message as
> (Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
> able to findout ecaxt solution need your suggestion with appropriate
> solution.
how to add a field in existing table database
im facing some problem.i wantto add a single field with 15varchar but it
couldnt i have tried before it works fine but know it gives me message as
(Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
able to findout ecaxt solution need your suggestion with appropriate solution.Hi
Look up the ALTER TABLE command in Books online or at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_3ied.asp?frame=true
and use the version:
ALTER TABLE MyTable ADD mycolumn verchar(15)
You may have to use an UPDATE statement afterwards to update the existing
data.
John
"shoeb" <shoeb@.discussions.microsoft.com> wrote in message
news:C3E6D6B8-2B0D-4F0F-AA3C-1F4DA38FCC04@.microsoft.com...
> im facing some problem.i wantto add a single field with 15varchar but it
> couldnt i have tried before it works fine but know it gives me message as
> (Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
> able to findout ecaxt solution need your suggestion with appropriate
> solution.
couldnt i have tried before it works fine but know it gives me message as
(Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
able to findout ecaxt solution need your suggestion with appropriate solution.Hi
Look up the ALTER TABLE command in Books online or at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_3ied.asp?frame=true
and use the version:
ALTER TABLE MyTable ADD mycolumn verchar(15)
You may have to use an UPDATE statement afterwards to update the existing
data.
John
"shoeb" <shoeb@.discussions.microsoft.com> wrote in message
news:C3E6D6B8-2B0D-4F0F-AA3C-1F4DA38FCC04@.microsoft.com...
> im facing some problem.i wantto add a single field with 15varchar but it
> couldnt i have tried before it works fine but know it gives me message as
> (Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
> able to findout ecaxt solution need your suggestion with appropriate
> solution.
Subscribe to:
Posts (Atom)