Not sure, but I think Compute Scalar deals with the column which will be updated (i.e. fornavn). You might try to convert the new value to NVARCHAR(80) explicitly and look if...

... and another way how to write it, which can come handy in some situations, where the calculations are more complicated than a simple SUM - by separating the CASE...

No, no... Nice try, Terry, but I'm sorry - you really don't need cursor and dynamic SQL for that. The query is pretty simple and you can run it directly from...

Nice article. Probably nothing new for those who use SQL for years, but very handy for those new to SQL and confused from the way it is described in BOL or some other book.

So...

As I understand it, you have some text file with dates and want to import it into datetime column correctly...

Look into the "CAST and CONVERT" topic in BOL. You can...

I agree with John and Michael. For 3GB database with 25 users, your system should be good enough... I would suggest to start with these things:

- get rid of RAID...

Well, that even does not include any text columns... and with such a simple update (no references to other tables, only one column in WHERE clause), on a table with...

Hi Mads,

please post the DDL for your table (CREATE TABLE .... don't have to include all columns, just all that enter in any way into this update), and the actual...

Hi,

as I see - at least in your post - some statement s are listed with Yes and some with No for recompliation. SET DATEFORMAT is not in the list...

Just an idea... this might help you, if you want to fetch the text that is between two occurences of the string {PN}. It only works with first two, if...

Shashi,

I tried to test your code, but you didn't declare most of the variables and are updating a table which is unknown to me... so I tried to guess the...

Depends on how it is in UK at the moment... we had a major change a few years ago in Czechia. Before, you had to dial 0 in front of...

Hi,

main limitation of the above solution is, that:

- you have to modify it any time there is a new value

- the more different values there is in the column, the...

Thanks.

If I would be asked to sum values of this type, I would refuse to do it, because there is no way to do it, unless all inputs follow the same pattern...

Hi Widya,

we need some data to test this. Please post a CREATE TABLE statement (you can include just the 2 columns, wr_id and A) and INSERT INTO with some sample...