Ahh. Thank you 🙂

You learn something new everyday.

Regards, Hanslindgren!

UNNEST is right now an unused keyword in T-SQL. Maybe you are talking about PL-SQL?

Edited by - hanslindgren on 03/31/2003 09:47:47 AM

Could dbo.Func1 be defined without parameters?

My error msg is when I do that is:

Server: Msg 8144, Level 16, State 2, Line 2

Procedure or function dbo.Func1 has too many arguments specified.

But...

Yes, they are free.

Try:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Happy hunting!

/Hanslindgren

Edited by - hanslindgren on 03/31/2003 08:40:04 AM

Is it possible to supply the code for the Trigger?

/Hanslindgren

Here are my two (euro) cents:

To quote http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B305977

quote:

---

Q: Are table variables memory-only structures that are assured better performance as...

I am happy to hear that the problem has been resolved, happy if I were of any assistance

Good luck in the future!

Regards, Hanslindgren

Just a quick reply, if you have a transaction with a TAB lock, there is basically no different between session specific and table specific. But you are right, the 'turning'...

Gregory:

Moving all the tables with the static data might be a wise move but do remember the problem of having inter-DB foreign keys.

For the time problem of recoding the...

Okay, I am no ASP expert either, but think about this case, in most languages you have some fancy way of formatting your strings. Also the OS at all points...

Getting the data in different columns 'manually' might be hard. You could do:

DECLARE @Data AS VARCHAR(8000)

SET @Data = ''

SELECT @Data = @Data + '|Firm = ' + CAST(Firm AS...

The default mode for SQL Server is to open a transaction for each individual Transact-SQL statement. This transaction is automatically committed when the statement completes.

Since the 'sp_change_users_login' explicitly states ...

Sorry, but WHERE is it displayed like that? What is displaying it like that?

Are you talking about a third party software? Do you have the source code (otherwise fixing it...

Moshe:

I don't think you solved it, you just avoided the error, how is the data now actually stored? How do you translate it back? Is the data even stored in...

Hmm, sorry, then I don't understand the problem? Or is it resolved?

quote:

---

the "date" field shows (for instance, for the date "31/12/2002")...