I don't think there is any possibility using a CASE. I think defining 2 conditions with an OR might work:

SELECT *

FROM Account

WHERE

( @Territory = 'Domestic' and...

hi SQLSACT,

23 Indexes seems to very very very much for a simple log table. I personally think it's very much for any table. You should check the sys.dm_db_index_usage_stats() too. When...

In this case the clustered index should hardly have fragmentation. Only if there are many updates on existing records there might be page...

hi there,

with the appropriate version of SQLServer you can do the rebuild with the ONLINE-option so there would not be any downtime. Otherwise use the REORGANIZE-command instead of the REBUILD.

REORGANIZE...

hi jitendra.padhiyar,

as so many times the answer is: "it depends"

If you want to add new databases you have to create a new publication. As far as I know it is...

And to finally answer this question:

The separator lines are grouping criteria. It's kind of user configuration. This means a user inserts the...

Hello Eugene Elutin,

the problem with the details is: they are no details.

The shown table is the result of a quite complex select out of a database that I've never seen...

Phil Parkin (12/11/2012)

---

WolfgangE (12/11/2012)

---

You misunderstood. I cannot use the house numbers in my query. That was just to show how the result should be. I have not only 1...

This looks quite good. And so simple. I already tried something similar making a join between a table containing the separators and the non-separators but it did not work...

Thank's a...

You misunderstood. I cannot use the house numbers in my query. That was just to show how the result should be. I have not only 1 street in my...

I'm still not sure, but yes, the statement above deletes ALL rows that contain the free spaces in the two columns.

If you only want delete the last row there are...

You say the rows with the total contain blanks in the first two columns, the other rows do not. So if this is your criteria the query is quite easy:

select...

To make your statement work you have to convert @pid in the string concatenation.

SET @sql = 'delete from ' + @tablename + ' where '+ @pidname + '...

I don't understand your explanations. Post some example data and try to explain again using these data.

Here is the same example using large, permanent tables.

create table dbo.Parcel (

ParcelId int,

Shipper varchar(50),

Consignee varchar(50)

);

create clustered index cix_dboParcel_ParcelId on dbo.Parcel ( ParcelId asc );

create table dbo.ParcelDetail(

ParcelId int,

ScannedAtStation varchar(50),

ScannedAtTime datetime

);

create clustered...