Can you post some of your code? Guessing could take a while...

ganteng1 (10/15/2014)

---

Thanks for that. I tried the following code below but it returned the wrong answer. Do you have any further suggestions:

declare @Month varchar = '02'

declare @Year varchar = '2014'

select...

Not all string functions work with TEXT datatype (http://msdn.microsoft.com/en-GB/library/ms187993.aspx). Try casting to VARCHAR(MAX) before using string manipulation on the column.

Grant isn't talking about the...

The syntax of your query might work for scalar functions, but it's incorrect for table-valued functions. Try this instead:

SELECT *

FROM dbo.FN_REPLACE('Testing string', 'Test', '') x1

CROSS APPLY dbo.FN_REPLACE(x1.replaced_string,'String','')

Try COUNT() OVER(PARTITION BY...)

You're welcome. Can you post up what you have? There may be improvements / better explanations.

reto.eggenberger (10/7/2014)

---

Thx ChrisM for your CROSS APPLY approach. I tried something like this, but sometimes cross apply is a bit misterious to me ...

Your solution doesn't work, because you can't...

karthik82.vk (10/7/2014)

---

Hi Chris,

I cannot create rows for the missing dates or change the date as its not a permitted- one. the data comes from another system and adding or changing...

DECLARE @tmp TABLE (CustomerID INT, CustomerLink INT, PRIMARY KEY(CustomerID))

INSERT @tmp VALUES

(100001,0),(100002,100001),(100003,100001),(100004,100003),

(100005,100006),(100006,100005),(100007,100006),(100008,0),

(100009,100008),(100010,100013),(100011,100008),(100012,100011),

(100013,100012),(100014,0),(100015,100016),(100016,100015)

;WITH FilledData AS (

SELECT CustomerID, CustomerLink = ISNULL(NULLIF(CustomerLink,0),CustomerID) FROM @tmp

)

SELECT x.GroupID, f.CustomerID, f.CustomerLink

FROM FilledData f

CROSS APPLY (

SELECT GroupID...

karthik82.vk (10/7/2014)

---

Hi,

I have a sql query that gets the count of exams held in each month. In every month there can be some exams happening or may not happening.

Below is...

Several alternatives to the query you've posted are available, and posting the execution plan as Gail suggests will probably help to determine which might be best. Here's one of them...

Proving that there is a performance issue need not take as much time...

pwalter83 (10/6/2014)

---

ChrisM@Work (10/6/2014)

---

You need something with which to associate the two tables. Column EDI_PARTNER_CD looks like the only column in MG_EDI_CONVERSION which might be related to COMPANY_ID or COMPANY_NAME.

Do...

Can you post the actual execution plan for your stored procedure?