looks like you haven't applied SP2 to your client tools

Microsoft SQL Server Management Studio9.00.3042.00

Microsoft Analysis Services Client Tools2005.090.3042.00

Microsoft Data Access Components (MDAC)2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)

Microsoft MSXML2.6 3.0 4.0 5.0 6.0

Microsoft Internet...

Yes and it still does!...

even with multiple parameters and ones delimited by single quotes

create proc kev_test

(

@param1 varchar(50),

@param2 varchar(50)

)

as...

All of the answers are flawed

Answer 1 (intentionally wrong): only calculates the value in difference between the 2 years (As BOL states)

Answer 2 (intentionally wrong): doesn't take into account leap...

Jeff, Matt,

that has just blown my socks off! Have you any links to further reading on this 'inner loop' technique.

From looking at your code - I would go with what Andras suggested and remove the common code into separate stored procedures

As GSquared rightly says, we need to see code, but I would be wary about utilising a UDF - you could end up with RBAR.

RBAR? - search this site and...

David,

certainly the *= and =* operators are not supported in compatability level 90 (i.e SQL2005).

As for performance, it should be no worse than a 'real' SQL Server 7.0 instance -...

Mike,

never knew you could pass parameters into those shortcut macros!!!

BTW - have tried it on my version of SQL2005 Management Studio and it works OK.

I was thinking of using...

again assuming data types are right.....

insert into tableB (fullname)

select firstname + ' ' + lastname from tableA

or an UPDATE statement based on some common key between the2 tables.....

Assuming firstname and lastname are strings, use the + operator

select firstname + lastname

or if you need readability

select firstname + ' ' + lastname

of coures you may also want to check...

In the past I have used SQL Scan, part of the SQL Critical Update Kit. It was provided to help identify instances vulnerable to Slammer, but you can just...

sa password!!!!!!!

It's OK - Evaluation Edition is supported on Vista.

And to add to the confusion, Evaluation Edition is a time limited version of Enterprise Edition, so in this case , yes,...

As far as I am aware, Enterprise Edition is not supported on Vista??

When you said (Trial) did you mean Evaluation Edition?

I was wondering.......