What if you wrap the call inside a stored procedure or function and use EXECUTE AS to change the privileges the command is executed under?

My psychic abilities are failing me... could you explain what your goal is? Looks like you're trying to calculate a change in grades for a single (student,course) between two...

Kind of an old post, but this is how i did it.

1. Add a calculated field to the dataset.

2. Function: OnTime=IIf(Fields!Actual.Value<=Fields!Predicted.Value,1,0)

3. Add a tablix to the report

4. 1st column:...

Kind of an old post, but this is how i did it.

1. Add a calculated field to the dataset.

2. Function: OnTime=IIf(Fields!Actual.Value<=Fields!Predicted.Value,1,0)

3. Add a tablix to the report

4. 1st column:...

Open the report in design view.

Right-click a column, show properties.

Click on the Visibility tab.

When the report is initially run HIDE

Display can be toggled by this report item (choose a textbox)....

While you could certainly do it that way, I absolutely would not. If you concatenate everything and dump it into a new column or create a calculated column, you're...

Why do you need to create a table in SQL Server at all for this? You can base your report on a stored procedure and you're off to the...

Brad,

Welcome to SSC... consider yourself schooled. (I'm still there, and I've been here for a while!)

Looks like you're a recovering Access/VB(A) programmer. Definitely true what Jeff said. ...

One way to do what you want is to attempt the insert inside a TRY/CATCH block, and then use an OUTPUT parameter to return the error number to it when...

BETWEEN 2013-11-26 13:49:00 AND 2013-11-26 13:49:59?

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

Happy reading!

You mean something like this?:

SELECT UniqueNum

,Somenum

, CHAR(ROW_NUMBER() OVER (PARTITION BY SomeNum ORDER BY UniqueNum ASC)+64) AS LetterSuffix

FROM #temp_Alpha_num

ORDER BY uniquenum,Somenum ASC;

so that when you get 121A to 121F and then...

And if you want a pretty good introduction to backup and restore, look on YouTube for ScaryDBA - Grant Fritchey has a video on doing just backups (differential, full, TLog)...

You can attach to lower versions, but not higher ones.

What is your compatibility level set to on the database?

To figure it out, right-click the database, go to Properties and then Options. I would bet that it's set to...