Search results for query: *

I gave the wrong error, that one was from A Microsoft site. This is the error message I receive in SQL Server, but the native code does work in Progress. Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing the query "SELECT Store_no, App_date...

Hello ESquared, Thanks for your response! I got a table in progress "pub.appointement" which contains the 'wrong' date field "app_date". SBHPRO_GSK2 is my linked server "Progress 9.1E " SELECT TOP 1 * FROM OPENQUERY (SBHPRO_GSK2, 'SELECT Store_no, App_date...

Thanks for the replies again! LNBruno, The table I've to access, is a 'production' table, so I cant change the columntype into varchar. SQLDenis, The Openrowset won't work for me :( I am trying to create a public view in progress, which I hope to use in my select statement. The other problem...

Hello, I am trying to import data directly out of Progress 9.1E into SQL Server 2005. For many tables this is no problem, I created a Linked server and am able to connect the tables and can use T-SQL statements to select records out of the tables. SQL Server 2005 has a big F***-up in their...

Does anyone else got any idea how to solve this problem? Henky

should be

I still got the same error when I was trying the code you mentioned above. I did try that before:

Denis, Thanks for your reply. I will store it in a varchar, thats not a problem, but I cant 'read' the record out of the table from linked server. I can use SELECT TOP 1 field1, field2, datefield_with_a_few_invalid_values_for_SQL_Server FROM Table because there is...

At first thanks for the replies LNBruno and gmmastros! I am iusing the dateformat in the right way, the problem isn't in the dmy subject. The problem is founded in a application which excepts every date value (AD) which ever was at this world. So there are dates in that database like...

Hello, I am currently busy to build a datawarehouse and I am importing data out of a linked server (Progress 9.1E). I am working with SQL Server 2005. I will get an error: Msg 8114, Level 16, State 8, Line 1 Error converting data type DBTYPE_DBTIMESTAMP to datetime. The problem occures when...

Here two screenshots of my situation. I just tried the option AtomicWedgie gave me, but it won't work, even whitout the quotes, it won't work. Could the empty field create the troubles, near to the db-logo (cilinder)??

Hi, I am not sure if I am doing something wrong or if it is a bug but, I can not seem to parse a SQL querie in the DTS Wizard. I get the following message. "Unexpected Error occured.The provider has returned an Error result without an Error message". The syntax is: select...

Thanks for the support I'll give it a try... :)

How can I add an auto increment row in a query? Existing table: Names Name John Jamie Adolf Nelson Tony George Kevin I want to make a select ... into query (to create a new table) SELECT Name INTO NewNames FROM Names ORDER BY Name GO The result has to be ID Name 1| Adolf 2| George 3| Jamie...

@vongrunt From sample data it appears that (ref, cust, purch_date) are sorted and unique. Is that always true? ------ Yep. those 3 fields always are unique

The reason I want to do this is because I have to select each record where the CUST is unique. I want to select the whole last row when I use this ORDER BY ref, cust, purch_date Maybe there is anther way to select the whole last row for each unique ref and cust with the highest purch_date. Out...

Hello.... In some (sql)languages there is a possibility to compare a field from row 1 with the same field in row 2. P.E. here is the query: SELECT ref, cust, purch_date FROM sell ORDER BY ref, cust, purch_date GO ref cust purch_date 123 1001 2005-01-03 123 1001 2005-04-01 123 1004...

Hi, I would like to concat to greps to eachother. p.e. file: 016-00.txt job started: thursday 15 july at 23:00:09 file: 017-01.txt job started: friday 16 july at 23:00:08 output after the grep 016-thursday 15 july at 23:00:09 017-friday 16 july at 23:00:08 I was thinking about: grep 'Job...

Hi, I've downloaded "mysql-4.0.20a-win-src.zip" for winXP. After upacking the files I don't know how to get started. I did search at this forum and at mysql.com, but no results. Can you tell me how I can get started with mysql?

hi... when you copy -> paste some numbers they could be changed in text notification. p.a. if you paste the row with numbers in the cells C1:C50 you can make a formula in D1 =C1*1 you've to copy this formula to D2:D50 (the formula in D50 will be =C50*1) after that you've to copy D1:D50 and...