Hi Lynn, I am hoping to get several different ways (cursor/while loop/etc.) to do same thing, so I can try them all and see which is fastest. The stored procedure...

Would like to replace cursor with while loop in the following stored procedure or at least compare

performance with while loop. Can someone supply me with while loop non-cursor T-SQL statement...

Here is Halane's reply in english:

It is more than seven years I studied review of Java, but you must download the JDK in progress on the Sun site and then...

Hi Gift, thanks again. I am still not sure which to choose (Web/Windows development).

I think I will play with both, see which I learn easier/quicker, plus which of the two...

Hi Gift, thanks for your help. Now I have another question.

I am not sure which direction to choose - Web/Windows C# development.

Can you assist me. I know Web development has...

Hi Silverfox. Thanks for your suggestions and also thanks to the other replies.

I want to learn another skill besides SQL, so C# seems a good choice.

I am NOT into...

Hi Silverfox, here's a question. I have 5yrs + SQLDBA experience, of that 1 yrs SQL Reporting + SSIS experience. I want to add some C# development skills. Which route...

Hi Silverfox, you mentioned - application development can be picked up easily.

WOW, you must be a natural at learning C#, VB, delphi, C++. From my experience software development has a...

In my report, one column/cell is grouped by products and it children are sales, dept, employees, etc.

Now I only want to change color of dept cell to red if...

create table Dept (

description varchar(50) NULL

)

this works:

----------

select cast(description as money)

from Dept

this fails:

--------

select cast(description as decimal(4,2))

from Dept

Q:

in select statement, how do you convert from varchar(50) to decimal(4,2)

In my report, one column/cell is grouped by products and it children are sales, dept, employees, etc.

Now I only want to change color of dept cell to red if...

Thanks Denny, you really add value to this site, wish someday the rest of us can do the same.

Thanks Denny, your help is much appreciated.

The server was loaded with SQL 2008 Developer Edition (Eval version),

SSRS was installed, about 20 databases copied to the server, more than 150 SQL...

I have SQL Server 2008 Developer Edition (Evaluation version) installed. It expires in about 2 weeks. Want to upgrade it to SQL Server 2008 Enterprise Edition. Is this possible ?

If...

Can you give me the method/s you used using winscp

Thanks

Regards

Kevin

sonyt65@yahoo.com