You've talked alot about Serializable e.g. Declaring the UDT as Serializable allows the UDT to be Serialized. Well ur, yeah, obviously! But what does that mean? What can you do with a...

I will be in Dallas 25th Sept - 1st Oct. I'm already looking for stuff to do on the weekend after the conference and Steve Jones recommended the LA Angels...

This seems to work. It assumes that your table is called cursor_test:

create procedure pivot_my_table
as
 declare mycursor CURSOR for
  select col1,col2,col3 from cursor_test
 
 declare @col1 int, @col2 decimal, @col3 decimal
 
 if exists (select * from #temp)
  DROP...

What has happened to the "10" in column2?

Sunil,

You can write an Update statement in an OLE-DB Command component but this does row-based updates rather than set-based updates (i.e. an UPDATE statement is issued for every row that...

<Wayne>I prefer consistancy even at the cost of efficiency in many things, the deciding factor being something that demands performance/efficiency</Wayne>

Amen to that!!!

It helps to remember the logical order in which the clauses in a SQL statement are evaluated. The order is (I think): FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY....

Note that SQL Server Express does not contain SSIS.

Try doing:

SELECT * FROM TableC WITH (NOLOCK)

That sometimes works. Let me know if it works or not - i'd be interested to know.

Thanks everyone for the replies.

We now know that there is a group of people that can always open the object without any problems whereas another group always DO have problems....

They are using MS Access 2002 ad it is an MDB file.

But that isn't the issue. Remember that I opened up the same thing on the same machine and it...

Doh, I'm not thinking straight. Relinking the tables won't make any difference. Remember that when I open the mdb it works OK, but when the users open it, it hangs....

Hi Pascal, thanks for the reply.

Re-linking the tables is a good idea. As soon as I've sent this mail I'll try that out. I'll report back if there's any success.

Yes,...

MDXBuilder is a pure MDX authoring tool. A quick scan of google didn't tell me where you van get it from but you can get a trial version here:

Steve,

Err....I'm more one of these people that accepts their pay packet rather than analyses it but...

According to 1 reputable source: