milenio

Hi all, I hope anyone can give some pieces of advice on the following matter. I have developped internal server with a few DB in our company. Recently the system has been introduced to the all users, which willl acccess the data via Business intelijence SW (Business Objects in p[articular). …

Hi all, first i would like to apologize if my question seems out strange or not well define, but I've never do this before. here it is my problem: I have a txt file with a delimiters. I have a XML file that should be used to load the data, …

I would try with this: Select left(cast(Date as nvarchar),1) as Month sum(Value) as Value Group By left(cast(Date as nvarchar),1)

Hi all, I faced up the following problem: I have a table: ID|server | target | action ---------------------------- 1 |a | b | attempt 2 empty row 3 |a | b | success 4 empty row 5 empty row 6 empty row 7 |b | a | attempt Does someone …

Hi all, recently I had have to import a text file ( row are separated by TAB and each column by a space) into a new database. Here i will try to give example: this is how the text file looks LUA 25.614397 43.06958 261 0 1 7 0 57:51.8 …

Hi all, i hope anyone of you can help me on the following matter: I have two tables: Recordingid Connection Sequenceno 1233036621 1 3 1233036621 1 4 1233036621 2 8 1233036621 2 9 And the second one: Recordingid Connection Sequenceno Code Cause 1233036621 1 1 21 9 1233036621 1 2 …