Neeta,

When you say "doesn't work" what do you mean by that exactly? Does the control not show up, or the values do not get passed on to the database? Remember, in...

Question for Sergiy,

What if my View is a compund View. Can we update a compund view?

KISS, KISS, KISS

• Site menu on the top, no matter where you are on the website
• User menu on the left
• Ads with on left or right and not in between article headings
• Bigger...

I must say that SQLServerCentral.com has increased my SQL knowledge manifold and it has also provided me with the opportunity to write a couple of articles.

I wish best of luck...

...though in SQL 2000 there is array processing

This definitely stumped me!!!!!

How come?

Try This:

SELECT

CASE WHEN (GROUPING(so.sales_order_phase_id)=1) THEN

'All'

ELSE

CAST(so.sales_order_phase_id AS VARCHAR)

END sales_order_phase_id

,SUM(so.contract_value_local_price)

FROM dbo.bv_sales_order so

GROUP BY so.sales_order_phase_id WITH ROLLUP

The GROUPING keyword adds the name for the extra row (Do a search for ROLLUP...

Exactly what I was looking for

1000 parameters

Are you sure that you have no other options but to pass in 1000 parameters?

I believe passing such a huge number...

Chris,

A very informative article indeed!

We once interviewed a guy who was the Vice President of the local SQL Server Users Group. The resume was a perfect match for the position...

Nice article!

I have been forced to use temporary tables because of the fact that most of our code is very reusable in the form of Stored Procedure and we do...

EXEC SERVERNAME.DATABASENAME.OBJECTOWNERNAME.STOREDPROCEDURENAME

Hope that hepls...

Wow!

Look what it did to my post. I will try to re-post

Have a look at it now

SELECT

@second_last_value_of_primary_key = column_name

FROM dbo.Table_name t

WHERE t.primary_key_column_name = @@IDENTITY - 1

/*Now update the most recently inserted row*/

UPDATE t

SET t.reference_column_name = @second_last_value_of_primary_key

FROM dbo.Table_name t

WHERE t.primary_key_column_name = @most_current_value_of_primary_key

Hope that helps...

My personal experience is that duplicate records in the database means poor validation on both client and DB side as well as poor database design. I agree with those people...

I thought Marh 06th was a Monday