Search Results | SQL Server Performance Forums

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

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?

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

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

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...