One way you could tackle this is to concatenate all the columnB values into one string per colA:

a 1,3,5

b 1,2

c 1,3,5

d 2

Then you take a DISTINCT over colB and split...

It's just a placeholder I made up.

You have to substitute it with your own values/columns/variables...

The following expression works:

=iif(Fields!ColumnB.Value = "" Or IsNothing(Fields!ColumnB.Value),"Bold","Normal")

I used the following data set:

SELECT 'Test' AS ColumnA, 'Not Empty' As ColumnB

UNION ALL

SELECT 'Test2',NULL;

In the second statement, I also used an empty...

Does the stored procedure itself run successfully on MySQL?

You can add the EXISTS statement to the WHERE clause of the INSERT statement.

A mock-up:

INSERT INTO order_master

SELECT values

FROM somewhere

WHERE EXISTS (SELECT 1 FROM category-subcategory-association WHERE cat_id = myCatID and sub_cat_id...

mickyT (6/17/2014)

---

Sorry, this function is from this article[/url] by...

Grant Fritchey (6/16/2014)

---

Koen Verbeeck (6/16/2014)

---

Sean Lange (6/16/2014)

---

Koen Verbeeck (6/16/2014)

---

Evil Kraig F (6/16/2014)

---

Any chance one of y'all with inroads to the powers that be at RedGate could get someone to update...

Jeff Moden (6/16/2014)

---

I suspect the people that made that requirement don't know that UDFs have 3 forms, one of which...

Msg 208, Level 16, State 1, Line 3

Invalid object name 'dbo.DelimitedSplit8K'.

Shadab Shah (6/16/2014)

---

Do you know a article or blog in which this things are mention , that which column name is search in the other table.

And where can i find...

Easy one (as I recently read this blogpost: Change data through CTE’s[/url]). Thanks for the question!

Sean Lange (6/16/2014)

---

Koen Verbeeck (6/16/2014)

---

Evil Kraig F (6/16/2014)

---

Any chance one of y'all with inroads to the powers that be at RedGate could get someone to update the spam filters on...

OK, so TSQL windowing functions are out of the picture unfortunately.

Although still perfectly possible in TSQL, you can calculate a YTD in SSRS itself:

Cumulative...

Evil Kraig F (6/16/2014)

---

Any chance one of y'all with inroads to the powers that be at RedGate could get someone to update the spam filters on the site for the...

Which version of SQL Server are you on?