;with EconSearch(SomeValue) as

(

select 'D.01.01.01' union all

select 'D.01.01.02' union all

select 'D.01.01.03' union all

select 'D.01.01.03.00'

)

select len(SomeValue) - len(Replace(SomeValue, '.', '')) as NumberOfPeriods

from EconSearch

Not much details here to provide anything resembling a coded solution but maybe NULLIF would work?

NULLIF(HistoryTable.Col1 = MainTable.Col1)

Thanks for the nod Lowell.

Assuming like Lowell said you are looking for these references in code and not in the actual values you could also just install SQL Search from RedGate. It is a...

Jason-299789 (3/22/2013)

---

You can do it using

CREATE PROCEDURE dbo.TEST

AS

DECLARE @ProcName sysname

SET @ProcName= OBJECT_NAME(@@PROCID)

...

What do you mean it didn't work? Remember I don't know what you want for final output. I...

Are you asking if there is a way to determine the name of the currently running stored proc from within the stored proc? I don't know of any way to...

Please take a few minutes and read the article at the first link in my signature for best practices when posting questions. We need to see ddl, sample data and...

Please take a few minutes to read the first article in my signature about best practices when posting questions. We need to see ddl, sample data and desired output.

If you...

I can't get to your image but can you just replace the comma with a carriage return?

Select Distinct State, (Select Stuff((Select char(10) + City

From #tempCityState

Where State = t.State

FOR Xml Path('')),1,1,''))...

I think you are asking how to get the results of your select into a table?

If it is a table that doesn't exist you could use select into:

WITH cte AS

(

SELECT...

You are welcome. Thanks for letting me know that worked.

No you should ignore my...

OK I think I get what you were saying. I was just too dense to get it. I think something like this should get you started.

CREATE PROC dbo.insert_into_child(@list_of_string_vals varchar(8000))

AS

BEGIN TRY

BEGIN...

Evil Kraig F (3/21/2013)

---

In this case Sean, since he's looking more for tuning help than code help, I'd request something a bit different.

As mentioned, we want to see the DDL...