One thing that I note here is that you are using a Multi-Statement Table-Valued Functions, and they consist of just inserting data into the (output) table variable to be returned....

Brandie Tarvin (7/29/2015)

---

SQLRNNR (7/29/2015)

---

WayneS (7/29/2015)

---

BL0B_EATER (7/29/2015)

---

You have made me very curious. What was...

Jeff Moden (7/29/2015)

---

Lynn Pettis (7/28/2015)

---

Okay, time for a Chicken Dentist 'cause I'm done trying to pull teeth on thread where someone thinks a loop is the only way to accomplish...

This code is based upon there...

kwashington (7/29/2015)

---

I've been thinking about this one and can not come up with a way to do this that make sense.

Our fiscal year starts on July 1st. Each month...

Perhaps you'd...

Brandie Tarvin (7/29/2015)

---

Well that explains why I lost all my SQL laarnin' yesterday.

Stop...

Table Variables. They...

Hi Wendy,

Can I get you to read the article for the first link in my signature, and then post the DDL for just the necessary columns, and also test data...

newbieuser (7/28/2015)

---

Hi friends,

I created a thread 2 days back on a performance problem RE non-trusted check constraints and foreign key constraints. We are planning to make them trusted...

bikram.g.it (7/28/2015)

---

Hi,

I need to PIVOT a table of the following structure -

[id][firstName] [lastName]

1Fred ...

KGJ-Dev (7/28/2015)

---

Hi mister,

nope, the data is not consistent.

Hi WayneS,

thank you so much for working query. I am curious to learn about cross apply used here. I will play with that....

I love it when I learn something in an area where I thought I knew it all.

KGJ-Dev (7/28/2015)

---

Hi,

Below are the same data

with Sample(Size) as (

select '16.3 Oz.' union all

'1' as union all

'2 Tablespoons' union all

'46. Oz. Each' )

i want to separate number and alphabets....

Hi Peter,

So, you want to make a delimited string, where the delimiter is " > "? I think that this article[/url] will guide you in doing just that, just modify...