Handle Error: format

Showing posts with label format. Show all posts

Friday, March 30, 2012

Having SQL Profiler while SQL Express Installed

This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C6B584.FD651AD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Dear All,
Is it possible for me to have a SQL profiler install in my local while i = have running SQL Express in my machine?
Please advise, thank you.
--=_NextPart_000_0008_01C6B584.FD651AD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Dear All,

Is it possible for me to have a SQL profiler install in my local = while i have running SQL Express in my machine?

Please advise, thank you.
--=_NextPart_000_0008_01C6B584.FD651AD0--This is a multi-part message in MIME format.
--=_NextPart_000_0034_01C6B540.6D9D7D50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
If you have a copy of sql server and want to install the management =tools you can install them on a machine regardless of the edition of sql =server actually running on the machine. However, I haven't tried running =Profiler against SQL Express, but I don't see why you can't. But you'll =have to actually try that yourself.
Mark
"Connie" <yfchan@.kdu.edu.my> wrote in message =news:%23LrYcIUtGHA.1888@.TK2MSFTNGP03.phx.gbl...
Dear All,
Is it possible for me to have a SQL profiler install in my local while =i have running SQL Express in my machine?
Please advise, thank you.
--=_NextPart_000_0034_01C6B540.6D9D7D50
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

If you have a copy of sql server and =want to install the management tools you can install them on a machine =regardless of the edition of sql server actually running on the machine. However, I =haven't tried running Profiler against SQL Express, but I don't see why you can't. But =you'll have to actually try that yourself.
Mark
"Connie" wrote in message news:%23LrYcIUtGHA.=1888@.TK2MSFTNGP03.phx.gbl...
Dear All,

Is it possible for me to have a SQL profiler install in my =local while i have running SQL Express in my machine?

Please advise, thank you.

--=_NextPart_000_0034_01C6B540.6D9D7D50--sql

Wednesday, March 28, 2012

Having Problems exporting to Excel

Hi all,
I am facing problems while exporting a report to Excel format
I am using Excel 2000 bundled with MS Office 2000 and RS Evaluation version
Do I need to do any configurations,
Is any one facing the same issue or a problem with my installation
Can anyone help regarding this...
Regards,
GirishYou need RS SP1 to export to Excel 2000
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Girish Kumar" <GirishKumar@.discussions.microsoft.com> wrote in message
news:1F82A63A-32C4-45D0-9F5C-DC949A95B14C@.microsoft.com...
> Hi all,
> I am facing problems while exporting a report to Excel format
> I am using Excel 2000 bundled with MS Office 2000 and RS Evaluation
version
> Do I need to do any configurations,
> Is any one facing the same issue or a problem with my installation
> Can anyone help regarding this...
> Regards,
> Girish

Monday, February 27, 2012

Handling nulls in calculated rport items

Hello,
How do I block null values from displaying "#Error" when I format a
datetime.
dbuchananWould an IIF statement not work in the expression
for example:
=IIF (Fields!Date.Value = "NULL", "",Fields!Date.Value)
This would bring up a blank space (or whatever you want it the output to be)
if the value is NULL, otherwise it just brings out the value.
Im fairly new to all of this so its just a thought.
"dbuchanan" wrote:
> Hello,
> How do I block null values from displaying "#Error" when I format a
> datetime.
> dbuchanan
>|||Theoretically yes that would work but in practice it doesn't as you have to
write
=iif(Fields!Date.Value is system.dbnull.Value, "", Fields!Date.Value)
otherwise deal with it in the initial query.
Greg
"Robert Seal" <RobertSeal@.discussions.microsoft.com> wrote in message
news:AB5060A6-88AE-4FB4-A224-C1C548418EFB@.microsoft.com...
> Would an IIF statement not work in the expression
> for example:
> =IIF (Fields!Date.Value = "NULL", "",Fields!Date.Value)
> This would bring up a blank space (or whatever you want it the output to
> be)
> if the value is NULL, otherwise it just brings out the value.
> Im fairly new to all of this so its just a thought.
> "dbuchanan" wrote:
>> Hello,
>> How do I block null values from displaying "#Error" when I format a
>> datetime.
>> dbuchanan
>>

Friday, February 24, 2012

Handling a double or float value for inserting into DataTime field.

Hi,

I was trying to enter the non-normalised exponential format of double or float value into the DataTime field in my data base. It is allowing to store any kind of data passed to this field. If the same non-normalised exponential value for eg: 4.235E-329 is passed to float or double field we are getting a TDS error but when same thing is used to store in DateTime field it is simply inserting the value.

Now my concern is that SQL Server 2005 should give me such kind of exception when I am trying to insert in-valid double or float value to DateTime field. Is this a bug in SQL Server 2005? Please kindly help me how to implement this one.

Thanks,

I get the same results on SQL 2000 and SQL 2005 when I run the script below.

I get
Server: Msg 168, Level 16, State 1, Line 2
The floating point value '4.235E-329' is out of the range of computer representation (8 bytes).

and the value 1900-01-01 00:00:00.000 is inserted into the datetime field and the value 0.0 gets inserted into the float field.

Can you please clarify your question or provide a repro?

Thanks!
use tempdb
go

create table t1(d datetime)
go

create table t2(f float)
go

insert into t1 (d) values (4.235E-329)
go

insert into t2 (f) values (4.235E-329)
go

select * from t1
go

select * from t2
go

drop table t1
go

drop table t2
go

|||

Unfortunately, SQL Server is a bit inconsistent in its compliance with the IEEE floating point standards. The value 4.235E-329 is less than 2^(-1023), and it can only be represented as a reduced-precision "denormalized" value. In some situations, these values will be understood and used correctly, and in others they will generate errors. The best advice I can offer is to be cautious with them, unfortunately. In SQL Server 2000, for example (and I expect in 2005 as well), the first code snippet here will succeed, but the second will fail:

declare @.f float
set @.f = 1e-307
set @.f = @.f/100000000000000
select @.f
go

declare @.f float
set @.f = 1e-322
select @.f
go

Steve Kass
Drew University

|||Problem Repro steps:

Create table tblTest1(id int, fld1 float, dtfld datatime)
Go

insert into tblTest1 values(10, 4.235E-329, '10/29/2005')
Go

This insert will give an error
Server: Msg 168, Level 16, State 1, Line 2
The floating point value '4.235E-329' is out of the range of computer representation (8 bytes).

If we selected the data then we will see there will be no record inserted.

now change the insert statment as

insert into tblTest1 values(10, 4.23, 4.235E-329)
Go

Then this will say that 1 record inserted and when we select the table to display the rows we will see that the record inserted. My Question is that if we insert a wrong non-normalised (Exponential) double or float value into float or double column it is raising an error and the trasaction is rolled back, but if we have given the same value to a datatime field, it is not raising any error and the record is inserted. We want to know is that a Bug in SQL Server 2000 / 2005.

Our main concern is that we want to get a such a kind of exception when we try to insert a wrong non-normalised (Exponential) value into datatime field and the transaction should be rolled back. Is there any work around to get rid of this issue, please mention me

Thanks|||When I ran your scripts on SQL 2005, both insert statements would throw a warning (msg 168), and then the insert would continue and insert one row into the table. The warning indicates that there is an UNDERFLOW for the floating point value, and the value is turned into 0. Is this not the result you are seeing?

Because floating point is imprecise itself, we chose to map denormalized values to zero. Note that the values inserted into the table are actually 0, not the denormalized value. I understand that you might want to see an error, but such behavior would potentially break other existing applications.

Regards,
Jun
|||Hi Jun Fang,

According to your message you said that a warning(msg 168) is thrown when the transaction is happening, please kindly help us how to trap this warning message from the ADO.Net 2.0 (front end application) so that we can show the message and roll back the entire transaction for this kind of scenario.

Thanks