davidandrews13 (12/8/2009)

---

sorry, i'm still getting used to what info is required, while at the same time not giving too much of our database structure away.

hopefully this is enough information to...

The issue is, What does 'usp_StoredProcedure' do ?

Firstly you need to expose the code inside that/them to ensure that the code inside can work in a set based fashion.

Try this link

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

Then really you need to go back to him/her and ask for clarification.

No one here will be able to help you.

Hope you have got strong passwords!

Could just be a port scan, are you auditing login failure / success ?

On the subject of homework , its a bit old now, but this ask question was a bit slack on even pretending

http://ask.sqlservercentral.com/questions/1681/need-help-with-queries-please

Nice cut and paste of questions , link to...

Good luck Gus, its always worse when you feel you have been forced into a move.

Thanks, first (and so far last ) useful CLR routine.

@Ismail ,...

Cross post, please keep to one thread

http://www.sqlservercentral.com/Forums/Topic828700-360-1.aspx

Please post query plan and DDL.

See the links in my signature if you are unsure of how to do this.

I have a CLR routine that mails reports on my blog here

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/direct-emailing-of-ssrs-reports-via-sqlclr.aspx

It should be fairly simple to modify that.

I see this

dbo].[udf_UserHasPrivForCountryGroup]( '

+ LTRIM(RTRIM(@UserID)) + ', ''' + LTRIM(RTRIM(@PrivCode))

+ ''', cg.[CountryGroupID]) = ''true''

as a cardinal sin. Microsoft have invested a lot of time and money in creating a...

while i appreciate that you may be a newbie, it was a fairly obvious mistake on my part.

Did you try to fix it ?

Declare @TotCount integer

Select @Totcount = count(*)

...

In which way ,is it not helping ?

Untested but something like this...

Declare @TotCount

Select @Totcount = count(*)

from feedback

Select q1,

(@TotCount/100.0 )...