When using the udf like this:

UPDATE #final SET

     intl_codes1 = dbo.GetInternationalCodes( award_id)

 you're still performing row-by-row actions, and hopping off to a separate function each time to...

You can also take a look into using XML templates to present query results through the SQLXML IIS plugin.  Query + FOR XML + XSLT = web page

Marshall's suggestion of...

I would advise writing a stored procedure to do the work, and grant access to the procedure.

You could include checks in the procedure so it only works in a certain...

1. When a procedure is named sp_<name>  (or dbo.sp_<name> ), SQL Server will search for it in the Master database before searching in the current database.  If you have a server...

If I'm reading this right...

You don't need the DISTINCT statement, the GROUP handles that.

To filter on aggregates after the grouping, use the HAVING clause:

SELECT hist.ConsultancyID
  FROM  ben_vw_consultancy_history hist...

Go for DBA if you want to be a DBA.  The talent pool and market needs change often enough that by the time you're really good at it, the money...

To total the sum of all columns together:

SELECT IntrestMark, SUM(col1 + col2 + col3 + col4 + col5 + col6) AS [Total]
  FROM mytable
 GROUP BY IntrestMark

(See...

First, your current arrangement is actually part of a recommended practice:  put only system tables on the [PRIMARY] group, then create one or more additional filegroups for data tables and...

Take a look at the sp_spaceused_report procedure posted in message

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=265290#bm265442

You can change the final SELECT statement to sum up the #Res table for your result.

You can also remove all...

Reports are delivered either

A: Upon user request, to a browser

B: On a schedule to an email address or network location (or other if you've rolled your own extension), or

C:...

1. The message about the semicolon is part of the answer:

<...>

SET @user-id = 'EC3C39B4-0E80-4EE9-A235-364A17B3A92C';

WITH