This is great stuff! Thanks very much!

I have several SQL CLR Table Valued Functions and I'm able to call the same function multiple times with no issues at all. However, my functions don't make web calls.

Salam! izayak ya mohammed? 😛

Manage the platform backend servers. In addition to database tuning and performance monitoring.

Maybe.. depends on the size of the company.

Take care of the database design...

You're welcome!

Perhaps there is no need for three...

Three updates looks a bit ugly though... I'm trying to figure out how to do this with one update.

SQL_Kills (11/21/2013)

---

Hi,

I have the following table

CREATE TABLE [dbo].[Orders](

[orderNo] [varchar](10) NOT NULL,

[orderLineNo] [int] NOT NULL,

[product] [varchar](10) NULL,

[orderQty] [int] NULL,

[receivedQty] [int] NULL,

[orderStatus] [varchar](10) NULL

) ON [PRIMARY]

GO

insert into Orders values ('A1000',1,'ABC100',10,10,NULL)

insert into Orders...

My attempt:

update Orders

set OrderStatus = 'Complete'

WHERE orderNo IN ( select orderNo

from orders

group by orderno

having sum(OrderQty) - sum(receivedQty) = 0)

update Orders

set OrderStatus = 'Some'

WHERE orderNo IN ( select orderNo

from orders

group by...

Thanks for the confirmation guys.

jchapman (11/16/2013)

---

Thanks for the reply Benjamin. Yeah, I'm still lurking around.

I had forgotten about this post. We did finally convince the IT guys to disable Sophos and we...

jervyn_almanon (11/20/2013)

---

Thank you Sir for the replies I appreciate it a lot.

I am clueless sir where and what to study first I'm currently reading an ebook on "How to be...

Firstly, welcome to SCC 😀

There have been loads of discussions on this topic in the past. Try with the search box (top-right) and see what you find.

Here is one I...

Can I...

Perhaps an ORDER BY clause in your query is now using the index...

dwain.c (11/18/2013)

---

A couple of caveats to using this technique:

- All columns created will default to allow NULL...

Dwain's probably asleep right now.. I think he's from New Zealand. 🙂

Temp tables local with single # or global with ## are always created in tempdb.

Can I suggest you expand...