The question asked how many rows are returned. It didn't ask which rows were returned.

Dave

Cory,

Ron's explanation is probably correct and openrowset() doesn't support variables only literals.

I thought the brackets worth a go.

Dave

Cory

I think this may have been the subject of a QOTD question (http://www.sqlservercentral.com/questions/T-SQL/88163/) from a couple of weeks ago.

What happens if you change

exec @sql

to

exec (@sql)

Dave

SSRS 2008 R2 introduced Globals!RenderFormat.Name. Unfortunately it's not available in earlier versions of SSRS.

Report items can be displayed/hidden depending on the chosen renderer. If you google globals renderformat there...

Would the windowing version of the MAX function be useful here?

Replace the line

MAX(AP_Ex.Ap_Expt_Date) AS CRN_SIS_AD_AP_Ex_Ap_Expt_Date

with

MAX(AP_Ex.Ap_Expt_Date) OVER (PARTITION BY AP_Ex.Student_ID) AS CRN_SIS_AD_AP_Ex_Ap_Expt_Date

and remove the group by...

I think you're referring to the IDMS product from Computer Associates. There's some information at http://www.ca.com/us/products/detail/CA-IDMS.aspx that states it does support ODBC, but I have no specific knowledge of connecting...

There was a recent QOTD about computed columns. The question can be found at http://www.sqlservercentral.com/questions/features/87846/ and the discussion here http://www.sqlservercentral.com/Forums/Topic1244022-1222-1.aspx

Dave

Paul,

From the earlier postings and my recollections of LAG and LEAD what does the following produce

select a.customer_id

,a.order_date

,LAG(a.order_date) OVER...

Paul,

Take a look at http://msdn.microsoft.com/en-us/library/hh231256(v=sql.110).aspx. Unfortunately, I don't have 2012 installed. However I have used LAG and LEAD with an Oracle database previously.

Dave

Paul,

I know this isn't going to help too much (as this is asked in a 2008 forum) but this seems like an ideal problem for the new LAG and LEAD...

What happens if you change the font to Courier New, or another non-proportional font?

Dave

Sean,

Your CASE statement is a more tailorable solution, rather than relying on the string sort order. I can see the requirements changing and the string sort needing to be changed...

Sean,

Is the group by clause needed in this case?

I tend to use CTEs (and probably overuse them). Is there any advantage to your approach (I think it is called...

One approach is to assign an order to the different form values. Using your sample data the following seems to work

;

with orderedpt as

(

select program,

...

I don't understand the requirements either. However, I would expect the SQL Server solution to be very similar to the Oracle solution. It may help if you were to post...