This might be your solution:

SELECT H.claimid, H.servunits, MAX(H.revcode) as revcode

FROM #myHead H

INNER JOIN (

SELECT claimid, MAX(servunits) servunits

FROM #myHead

GROUP BY claimid

) DT ON DT.claimid = H.claimid and DT.servunits = H.servunits

GROUP BY...

7 SQLCHAR 0 30 ",\"" 6 AMT ...

Look at the delimiter you specified between CREATED_BY and DATE_ORD.

Sorry, missed that piece.

Was looking for WHERE and ORDER...

Reindexing of clustered index changes order of pages for all other indexes on the same table.

So, clustered indexes must be processed first. I don't see where your script takes care...

You cannot defrag tables. You can defrag only indexes.

To be defragmented table must have clustered index first.

halifaxdal (8/20/2008)

---

I got it, here is the code:

ORDER BY

Case When NextReviewDate < getDate() then '1'

When NextReviewDate >= getDate() And NextReviewDate < getDate() + 30 then '2'

When NextReviewDate...

Tomm, I believe this version of the code

create procedure procname

as

BEGIN

statement 1

statement 2

...

statement n

END

grant execute to procname to role1

grant execute to procname to role2

go

would change nothing and users would still receive...

select count(CASE WHEN date >= @MonthFrom THEN sale_id ELSE NULL END ) as 'MTD',

count(CASE WHEN date >= @YearFrom THEN...

GOTO WHERE COMEFROM

😛

timbw,

First, look on Jack's code and learn to post the test data code.

Always.

If not Jack's post I would reply here.

Because I'm quite busy with my own tasks.

Second, there is...

If your StudentName is not longer than NVARCHAR(128) then use

QUOTENAME(StudentName, '"')

This wraps values with double quotes so it will be read correctly by anything you would use to read it.

1. Coorect. It's useless here. It even may produce an error in some circumstances.

2. No.

3. Yes.

4. Very bad idea.

You probably have absolutely wrong idea about SQL Server memory usege.

Memory is...

Select @col1 = col1, @col2 = col2, @col3 = col3, @col4 = col4, @col5 = col5

from #Temp

Execute storedproc @col1, @col2, @col3, @col4, @col5

But why not just use #Temp inside...

Any chance of having empty strings or other values not convertable to datetime?