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...

Maybe the person or persons that made this decision and decided to put you as the implementer should take on the task themselves.

If...

ChrisM@Work (2/18/2016)

---

Nikku (2/18/2016)

---

Hi All

I have two tables t1 & t2 which contains the same records. t1 is for bank1 & t2 is for bank2

i.e t1

accno name balance

001000 a...