IT Professionals

[PARAMASHIVAN]

app_engine

Small problem, I can not 'Group by' any columns that are of Ntext, Image data types, Do I need to convert them all into 'Int' data type ??

[app_engine]

I haven't used group by on image fields but it works for character and numeric fields. If this is for a browser app, I suggest you look up to such communities who may have a quick-fix

[PARAMASHIVAN]

thanks app_engine na

[kirukan]

app_engine

Small problem, I can not 'Group by' any columns that are of Ntext, Image data types, Do I need to convert them all into 'Int' data type ??

Just saw your post

You can try this
--nText
SELECT
Convert(varchar(8000),nTextCol ),
MAX(Amount)
FROM
TableA
GROUP BY
Convert(varchar(8000),nTextCol )

--Image

SELECT
Convert(varbinary(8),ImageCol ),
MAX(Amount)
FROM
TableA
GROUP BY
Convert(varbinary(8),ImageCol )

This may help you

[PARAMASHIVAN]

Kirukan

You have not included the 'Having' clause
I thought the 'having (*) > 1' clause is the 'Only' way to find duplicates ?

[kirukan]

Kirukan

You have not included the 'Having' clause
I thought the 'having (*) > 1' clause is the 'Only' way to find duplicates ?

My suggestion was for adding image and ntext in group by clause...

[PARAMASHIVAN]

Oh thanks

[PARAMASHIVAN]

Does any one here know much about SSRS in SQL server 2005 ?? esp adding parameters to a report?

thanks

[bingleguy]

Parama .... U could use Report Builder 2.0 which is supposedly user friendly for designing reports

[PARAMASHIVAN]

Parama .... U could use Report Builder 2.0 which is supposedly user friendly for designing reports

Is it a free download ? never used it before, this SSRS is so irritating, Stored procedures are 'much better' to query the databse !