Going deeper with the CROSS APPLY suggestion :

Consider something like this >

SELECT SUM(someNumberColumn) / (SELECT SUM(someNumberColumn) FROM Table) AS westCoastSalesAsA%OfTotal

FROM Table

WHERE someFilterColumn= 'west coast'

Could be done with...

From here what you should do is is create columns in the report (just to audit) that list the return values of these functions to see what actually got returned...

SELECT @ORDER_NUMBER = i.ORDER_NUMBER, @ID = i.ST_ID, @Name = i.FULL_NAME, @Timestamp = i.ORDER_DATE

from inserted i

This above will fail whenever the application inserted more than one row as part of...

First , just to explain >

CDBL(

MID(

Fields!PRE_LAB_VAL.Value,/* column to look in */

INSTR(Fields!PRE_LAB_VAL.Value,"=")+1,/* position in the string to begin at */

INSTRREV(Fields!PRE_LAB_VAL.Value,"=")...

Hugo Kornelis (3/4/2016)

---

MMartin1 (3/2/2016)

---

Without the try_convert function built in, I just did a simple

select convert(varchar(1), 234523); and got back the asterisk. What the meaning was when deciding to do...

Without the try_convert function built in, I just did a simple

select convert(varchar(1), 234523); and got back the asterisk. What the meaning was when deciding to do this, I do...

This does make more sense. How do you handle situations when all professors are maxed out and can take no more assignments? Create a new professor? If you provide create...

I would still not mind knowing how this applies to a real world situation. Or are we just solving a fun programming problem? I read you that you want us...

Raxter (2/25/2016)

---

This is dummy data. I can not post the actual production data. The idea is that if a certain value is in the table more than a certain number...

Jeff Moden (2/24/2016)

---

MMartin1 (2/24/2016)

---

sharonsql2013 (2/23/2016)

---

How can I show last days for past 3 months say..

Jan 2016 (2016-01-31 23:59:59.000)

, Dec 2015

and Nov. 2015

Need to be dynamic as it...

TeraByteMe (2/24/2016)

---

Thanks for all the advice. They all would work well if there was any form of procedure and accountability in the company I work with.

I started the job almost...

sharonsql2013 (2/23/2016)

---

How can I show last days for past 3 months say..

Jan 2016 (2016-01-31 23:59:59.000)

, Dec 2015

and Nov. 2015

Need to be dynamic as it will change with...

Why not both be 7, or three? What...

bwinchester (2/14/2016)

---

I understand what you are saying and I agree. I'm my situation, I am updating product information on a remote sql server with data from a local sql...

From MSDN >

sys.objects

Notice it says "within a database."

Further,

sys.all_objects

Shows the UNION of...