Be careful here. Dwain commented that he has encountered significant performance issues when using a value from a function like that as the first parameter in DelimitedSplit8K. I was rather...

Luis Cazares (5/14/2014)

---

I saw the single...

I would drop the mapping table and add another column to the Item table named ParentItemID. Then this is a simple recursive cte.

smtzac (5/14/2014)

---

I have a database 'DB and Table Growth'. Inside that database table called 'GrowthTrack'.

Now I want to create a store procedure which that takes size of 'AdventureWorks' database...

Not a huge deal...just add some ltrim, rtrim.

with Names as

(

select 'Mike...

Here is one way you might be able to deal with that.

with Names as

(

select 'Mike Davis' as FullName union all

select 'NoSpace'

)

select case when charindex(' ' , FullName, 0) > 0...

That is because you have at least one value that doesn't...

isuckatsql (5/14/2014)

---

I have the following:

(a) One Dynamic SQL Query that takes 37 ms when run as a single query or in an SP.

(b) Three SQL Indexed View queries that take...

sharonsql2013 (5/14/2014)

---

In order to join two tables , I need to flip the name column in one table to bring the last name first.

So If its Mike Davis

I need...

jdasilva (5/14/2014)

---

Thanks. I will. In programing (do a bit of VBA) I always fight with var names. Too long vs. not discriptive enough.

Also, I see you point...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Let's see what this monster looks like with some formatting so we can read it...

/****** Object: StoredProcedure [dbo].[CCPAspProjectCostCatDetail] Script Date: 05/13/2014 15:46:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:

-- Create...

jdasilva (5/14/2014)

---

thanks Sean for the tips.

unfortunately changing the names currently used would be quite a lot of work as it is not only tied to Access but several Visio floor...

Well the query you posted is nothing like the...

I almost spit my coffee on the screen when I saw...