group by Ntext

[ozmodius]

hey guys, I'm a complete noob when it comes to SQL, thanks for any help you can give.

the folowing query wants me to group by fields that are Ntext and this can't happen. any suggestions?

SELECT Distinct 'ticketStatus.a spx?ticketNum=' + CONVERT(varChar ,dbo.sv_inquiry .inquiry_id) AS URL ,dbo.sv_inquiry .transfer_rep,d bo.sv_inquiry.i nquiry_id AS [Ticket #],
dbo.sv_inquiry. logged_dt AS [Logged Date],sv_inquiry.clo sed_dt,ltrim(rt rim(dbo.account _contact.first_ name)) +' ' + ltrim(rtrim(dbo .account_contac t.last_name)) AS Customer,dbo.sv _inquiry.priori ty,dbo.sv_inqui ry.status+' - '+dbo.sv_inquir y.state AS status,
dbo.sv_inquiry. it_short_desc AS [Short Desc], dbo.account.nam e as Property, dbo.sv_inquiry. type as type, dbo.sv_inquiry. it_source as Src, dbo.sv_inquiry. it_service as Service, DATEDIFF(n,sv_i nquiry.logged_d t,sv_inquiry.cl osed_dt) as Elapsed,
CAST(dbo.sv_inq _txt.inquiry_tx t AS nvarchar(100)) AS Details, CAST(dbo.sv_sol ve_txt.solution _txt AS nvarchar(100)) AS Solution
FROM (SELECT dbo.sv_inquiry. inquiry_id as ID, dbo.sv_inquiry. logged_dt as logged_dt , MIN(dbo.sv_inqu iry_audit.actio n_dt) AS action
FROM dbo.sv_inquiry WITH (NOLOCK) INNER JOIN
dbo.sv_inquiry_ audit WITH (NOLOCK) ON dbo.sv_inquiry. inquiry_id = dbo.sv_inquiry_ audit.inquiry_i d INNER JOIN
dbo.account WITH (NOLOCK) ON dbo.sv_inquiry. account_id = dbo.account.acc ount_id left Outer JOIN
dbo.grp WITH (NOLOCK) ON dbo.sv_inquiry. transfer_grp = dbo.grp.name
WHERE dbo.sv_inquiry. state ='Closed' and ia_action = 'Status Change' and new_value = 'Resolved' Group by logged_dt, dbo.sv_inquiry. inquiry_id) DERIVEDTBL inner Join dbo.sv_inquiry on dbo.sv_inquiry. inquiry_id = ID INNER JOIN
dbo.account WITH (NOLOCK) ON dbo.sv_inquiry. account_id = dbo.account.acc ount_id INNER JOIN
dbo.account_con tact WITH (NOLOCK) ON dbo.sv_inquiry. account_contact _id = dbo.account_con tact.account_co ntact_id INNER JOIN
dbo.sv_inquiry_ audit WITH (NOLOCK) ON dbo.sv_inquiry. inquiry_id = dbo.sv_inquiry_ audit.inquiry_i d INNER JOIN
dbo.sv_inq_txt WITH (NOLOCK) ON dbo.sv_inquiry. inquiry_id = dbo.sv_inq_txt. inquiry_id INNER JOIN
dbo.sv_solve_tx t WITH (NOLOCK) ON dbo.sv_inquiry. inquiry_id = dbo.sv_solve_tx t.inquiry_id INNER JOIN
dbo.grp WITH (NOLOCK) ON dbo.sv_inquiry. transfer_grp = dbo.grp.name

group by dbo.sv_inquiry. logged_dt, dbo.sv_inquiry. inquiry_id, dbo.sv_inquiry. transfer_rep, dbo.sv_inquiry. closed_dt, dbo.account_con tact.first_name , dbo.account_con tact.last_name, dbo.sv_inquiry. priority, dbo.sv_inquiry. status, dbo.sv_inquiry. state,dbo.sv_in quiry.it_short_ desc, dbo.account.nam e, dbo.sv_inquiry. type, dbo.sv_inquiry. it_source, dbo.sv_inquiry. it_service, dbo.sv_inquiry. inquiry_id

[code green]

At least take some time to use Code tags when posting code.
Apart from that
What are you tring to do?
What is happening?

the folowing query wants me to group by fields that are Ntext and this can't happen. any suggestions


This is meaningless