is there a way that i can import it in to one column and then parse it!!

it is not genereating the report in text also. the job fails while running the databasemaintenance plan!

what is the solution! I tried creating again but still fails too.!!

Thanks

yeah it does have text file. what could it be done though!!

Let me know

thanks

Yeah, but the that table is created on fly by excel file and they have only that to get the site number from database to check wethere the users are...

the relationship is not that complicated. It is just data in the site table with site id. and testtable with site discription but the discription in testtable is not exactly...

just need to update where loanid in fedref table to u_wire_info. from ncenfedref table. but it gives error at set fedrefdatetime?

Please Let me know.

Thanks

It is giving me this error:

Server: Msg 7399, Level 16, State 1, Line 1

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. 

[OLE/DB provider returned message: Unspecified error]

OLE DB error trace [OLE/DB...

i have multiple data that represent same key (item) and it has status date along with it so how can i get the latest update that made on that key...

it somehow doesnot work is there other command through query analyzer that can work?

thanks

hi in

the last response which is update statement i says

Invalid length parameter passed to the substring function.

thanks

Hi,

not it's not numeric!! it's varchar!! how can i make change on to that!!

Thanks

hi,

yes, currently they have the 21.test in one column and now they want to split them and put it in to separat such as 21 in project column and test...

Hi,

I am trying to register on different where i have SQL EM but not able to loging and it fails to register. What user name i hav to log...

no i am trying to prevent other user from edit in record at the same time one user accessing the same record.

Hi the replication agent goes suspect because of the connection to publisher database server. once the netwrok connection is up again try re activate the subscription and run the job...