antonopn
Last Activity: Nov 26 '09, 07:02 AM
Joined: Mar 29 '08
Location:
-
Thank you so much! I appreciate it!!! Helped me a lot!!! -
Month to month yearly results - hard and slow help...
Hello to all!
I'm trying to make a very difficult report. I want to present sales of some products within an year but month-to-month.
lets say that the table would be like this...
customer|specie|quantityJAN|quantityFEB|quantityMAR...
But the problem is I need to make all these columns by hand and the query is like this...
...Code:select customer.name, product.descr,
-
Change codepage in txt file
Hello there,
I have a txt file (lets say 'C:\myfile.txt' ) which has a specific format.
How can I see what is the exact format of this file? And how can I change it to a DOS format? I want to make an import into a DOS program and the I have serious problem with code page.
THANK YOU FOR YOUR TIME!!!! -
Very weird bug with 'like' function
Hello there,
I have just faced a really weird problem with a query in SQL SERVER 2000.
I had a database with collation SQL_Latin1_Gene ral_CP1_CI_AS and converted it in a new database with collation Greek_CI_AI.
The conversion was absolutelly correct. Tables, views, sps, functions etc. where succesfully transfered into the new database. The new database is working fine, but I faced a problem with a "select-from-where-like"... -
Should I create the table before this procedure or not?
Thanks a lot debasisdas!!!!Leave a comment:
-
SQL Loader
Hello there,
I have a semicolon delimited text file (lets say 'c:\myfile.txt' ).
I want to insert it into a table in a 8.1.6 oracle database (lets say 'mydatabase.dbo .mytable')
I tried searching the internet for some scripts, but I get an error message "LOAD DATA not a recognised command" or something like this.
Could someone PLEASE help me? I'm a newbie in oracle. MS SQL procedure... -
Round entire column
Hello there,
In a table, with a field which type is float (lets say MYFLOAT from MYTABLE) I have this value
6.0949997901916 504
It it a value that was imported from an excel sheet.
when I usethe outcome is correctCode:SELECT ROUND(6.0949997901916504,3)
6.0950000000000 000
but when I usethe outcome is again 6.0949997901916 504!...Code:SELECT ROUND(MYFLOAT,3) FROM MYTABLE
-
ck you are the best
Thanks a lot!!!!
SOLVED!!!Leave a comment:
-
Find Day from datetime
Hello there,
I'm trying to make a script that will recognize the exact day of a datetime value.
Example:
2008-12-03 00:00:000 => Wednesday
2008-12-04 00:00:000 => Thursday
2008-12-05 00:00:000 => Friday
etc...
Thank you for your time!!! -
Change Collation Name in a database (SQL SERVER 2000)
Hello there!
I want to change a database's collation name from SQL_Latin_gener al to Greek_CL_AS because some data can not be read.
Thanks for your help! -
MY APOLOGIES not yours :)
Thanks for the answer one more time!!!
It works fine!!!Leave a comment:
-
Thanks for your answer!
Lets suppose I need cursor! My problem is not why should I use cursor but why this "mistake" occurs!Leave a comment:
-
Cursor does duplicate records
Hello there,
this is my problem. I have a table in sql server. lets say it table_read.
I use a cursor like this.
...Code:DECLARE CUR CURSOR FOR SELECT * FROM TABLE_READ OPEN CUR WHILE @@FETCH_STATUS=0 BEGIN FETCH NEXT FROM CUR INTO @local_var1 @local_var2 ... INSERT INTO TABLE_WRITE VALUES (@local_var1, @local_var2...) END CLOSE CUR
-
It Works Fine!
Thanks A Lot!!!!!!Leave a comment:
-
thanks for the immediate answer!
I'm trying to use replicate function but it has errors.
This is the sql server code!
Code:select replicate(code, 1)+','+replicate(name, 1)+','+replicate(afm, 1)+','+replicate(street1, 1)+','+replicate(zipcode1, 1)+','+replicate(phone11, 1) from customer
Leave a comment:
-
Easy question from MS SQL to ORACLE
Hello there,
I have this sql code that runs properly on sql server
How can I transform it to run in an oracle database?Code:select code+','+ name +','+afm+','+street1+','+zipcode1+','+phone11 from customer
Lets suppose the tables and columns are the same!
Thnaks! -
If anyone could help please?
To be more specific.
I have a table with these values
ID | VALUE | DATE
10 | 140.00 | 2008-01-01
10 | 255.00 | 2008-02-10
10 | 102.00 | 2008-03-31
11 | 651.00 | 2008-05-26
12 | 412.00 | 2008-06-15
I execute a VBScript that makes the day=27 no matter the month or the year. But when the ID is the same it does it only for the last row....Leave a comment:
-
Thanks for the answer.
I would be glad if someone could tell me how will I make a loop and execute there the code I quoted.
example:
Code:do where id=123456 ...mycode... end loop
Leave a comment:
-
VBScript help
Hello there...
I have a SQL-VB problem.
I use a program for a company. It inserts values to a table.
lets says table1
ID, date, amount
I use a vbscript that changes the date. But when in table1 many rows with the same id are inserted, only the last row is affected and the date is changed to the desirable value. I want a kind of loop that will be executed when some rows have the same id.
... -
Try this
This will give you the bigest empid number!Code:select top 1 from mytable order by empid desc
Leave a comment:
No activity results to display
Leave a comment: