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 ?? :roll:
Printable View
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 ?? :roll:
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:-)
thanks app_engine na
Just saw your postQuote:
Originally Posted by PARAMASHIVAN
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
Kirukan
You have not included the 'Having' clause :roll:
I thought the 'having (*) > 1' clause is the 'Only' way to find duplicates ? :roll:
My suggestion was for adding image and ntext in group by clause...Quote:
Originally Posted by PARAMASHIVAN
Oh thanks :)
Does any one here know much about SSRS in SQL server 2005 ?? esp adding parameters to a report?
thanks
Parama .... U could use Report Builder 2.0 which is supposedly user friendly for designing reports
Is it a free download ? :roll: never used it before, this SSRS is so irritating, Stored procedures are 'much better' to query the databse !Quote:
Originally Posted by bingleguy