Search Results | SQL Server Performance Forums

Negative float numbers not imported?

Post by: mikachu, Jul 12, 2007 in forum: Getting Started

This is getting even stranger.. If I SELECT * from the table, negative values (e.g. -123.45) can be seen, but if I take only the MeasurementValue...

Negative float numbers not imported?

Thread by: mikachu, Jul 12, 2007, 2 replies, in forum: Getting Started

I'm having a very strange problem. I got some measurement data in SQL Server 2000 table, which I would like to copy to another table. INSERT INTO.....

Easy way to find out if date is in a given period

Post by: mikachu, May 11, 2007 in forum: Getting Started

Probably not the most optimized solution, but works smoothly <img src='/community/emoticons/emotion-1.gif' alt=':)' /> Thanks for help guys! <br...

Easy way to find out if date is in a given period

Post by: mikachu, May 11, 2007 in forum: Getting Started

<blockquote id="quote">quote:<hr height="1" noshade id="quote"> WHERE ((StartDate...

Easy way to find out if date is in a given period

Post by: mikachu, May 10, 2007 in forum: Getting Started

Thanks for prompt replies. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] <blockquote id="quote"><font size="1"...

Easy way to find out if date is in a given period

Post by: mikachu, May 10, 2007 in forum: Getting Started

Okay, the answer to the first question was very apparent ... OR (StartDate < '01-Apr-2007') AND (EndDate > '30-Apr-2007') Any ideas to second...

Easy way to find out if date is in a given period

Thread by: mikachu, May 10, 2007, 14 replies, in forum: Getting Started

Hi! I got two questions related to my application. Its database structure looks like this: RowID | StartDate | EndDate | Amount...

Best way to convert RSS pubDate to DATETIME?

Post by: mikachu, Jan 19, 2006 in forum: General Developer Questions

Thanks for prompt reply. Yeah, I could take a part of the string and convert it to datetime. Does this mean SQL Server has no understanding of...

Best way to convert RSS pubDate to DATETIME?

Thread by: mikachu, Jan 19, 2006, 3 replies, in forum: General Developer Questions

Hi, I'm developing a RSS news reader to company website and would like to archive some RSS news to database. Everything works fine, but I would like...

Problem with MIN+SUM

Post by: mikachu, Sep 2, 2005 in forum: General DBA Questions

Thanks for your prompt reply. What it should result is: Process1 | 1 | 123 Process2 | 2 | 1245 Process3 | 4 | 123 So for Process2 it sums...

Problem with MIN+SUM

Thread by: mikachu, Sep 2, 2005, 4 replies, in forum: General DBA Questions

I have a table with data as follows: | ProcessName | EquipmentID | TimeProcessed | ... ----------------------------------------------- | Process...

Acquiring user password from SQL server?

Thread by: mikachu, Jan 17, 2005, 1 replies, in forum: General Developer Questions

Hi, Is there any possibility to acquire user password for SQL account from MS SQL server with sp_password? I'm developing company intranet and would...

Using ADO Filter property & distinct

Thread by: mikachu, Dec 2, 2004, 0 replies, in forum: General Developer Questions

Hi, Is there any way to use ADO Filter property and SQL distinct together? RecordSet.Filter = "SELECT DISTINCT COMPANY FROM blah blah.." doesn't...

Converting varchar to number

Post by: mikachu, Nov 1, 2004 in forum: General Developer Questions

Thanks Tom for quick reply. REPLACE works fine. -Mika

Converting varchar to number

Thread by: mikachu, Nov 1, 2004, 2 replies, in forum: General Developer Questions

Hi, I get following error message: "Error converting data type varchar to numeric." The problem is I need to calculate gross margin...