Search results for query: *

Hi, Use linked server or the openrowset function where you can provide connection information. Regards /Mattias

Hi, One thing is that you have left out the alias "at" in the from clause. One other thing I would try is to be concistent. Use ansi style all the why, don't mix it. Use inner join, left join etc. I think that could solve your problem. Regards /Mattias

Hi again, When this is accomplished export the data to a csv file and use DTS to import the data. Regards /Mattias

Hi, A simple but effective solution to your problem is this: 1. Make sure that all users have a password that you know about. 2. Make a new simple database called Master with all the fields you need. 3. Make a new database with a script that connects to the copy and imports the data via...

Hi, You have to declare a field where you store your SQL statement, This statement you'll have to build dynamically via scripts or calculated fields. When you import don't write the statement in the import dialogbox, choose the variable/field containing your sql statement. Regards /Mattias

Hi! I think that you can accomplish this by a simple portal trick. regards /Mattias

Hi, What is it that you want to accomplish with the task? Would a simple export do the trick? Regards /Mattias

Hi, Use Inserted or Deleted as described above if you want the ID for the row you have updated. If you want to know what field you updated use ColumnsUpdated(). regards /Mattias

Hi, Use openrowset, see BooksOnLine. Regards /Mattias

Hi, If it's few records in the table, I would create a stored procedure that updates the current Branch, then after that I would create a temp table with identity id (the rank) and insert the rows from your originally table ordered by Sales. After that update the rank from the temp table...

This is a way to address your problem: select convert(char(8), Mydate, 112) as MyDate2, MyID, Max(MyDate) from MyTable group by convert(char(8), Mydate, 112), MyID Regards /Mattias