I generally use this query as a first step in determining missing indexes.

DECLARE @DBName VARCHAR(50) = 'yourDB';

SELECT [Total Cost] = ROUND(avg_total_user_cost * avg_user_impact * (user_seeks + user_scans), 0),

avg_user_impact, TableName...

jdnelson.web (8/24/2012)

---

You are both genii. Thank you very much. A couple of questions which I can assume will be easy for you to answer.

1. How would...

ganeshkumar005 (8/24/2012)

---

I have a table A:

StudIDRollNo

AlphaD1234

betaA1122

charlieD1234

bravoC1342

tomB1964

harryA1122

and table B:

RollNoSubjectCode

D12341001

A11224001

D12342001

C13425001

B19646001

A11223001

I want to join the table A and B. For studID Alpha from table A i want the subjectcode 1001 only from table...

--== CREATE SAMPLE DATA (your should've included this in your post) ==--

-- Note, because you have written your "date" in the format you have, I've assumed

-- it is a VARCHAR...

tshad (8/23/2012)

---

Actually, it isn't exactly the same way.

I was trying to figure out how to get your way to work with a middle table and couldn't get it to work.

You're...

The same way we've already explained.

SELECT *

FROM (SELECT DealerID, DealerCode, DealerName, ForecastId, Name

FROM Dealers d

CROSS JOIN Forecast f)...

Phil Parkin (8/22/2012)

---

Maybe I jumped to the wrong conclusion - I didn't spend much time considering the question itself. I just liked the fact that you had used fairly advanced...

ChrisM@Work (8/22/2012)

---

SELECT

Stringy,

Stuffy = STUFF(STUFF(STUFF(Stringy,x3.startpos+1,x3.endpos-x3.startpos-1,'n'),x2.startpos+1,x2.endpos-x2.startpos-1,'n'),x1.startpos+1,x1.endpos-x1.startpos-1,'n')

FROM (SELECT Stringy = 'A1(1).B22(10).C345(100)') d

CROSS APPLY (SELECT startpos = CHARINDEX('(',Stringy,1), endpos = CHARINDEX(').',Stringy+'.',1)) x1

CROSS APPLY (SELECT startpos = CHARINDEX('(',Stringy,x1.startpos+1), endpos = CHARINDEX(').',Stringy+'.',x1.endpos+1)) x2

CROSS APPLY...

DECLARE @str VARCHAR(256) = 'A1(1).B22(10).C345(100)';

WITH CTE(N) AS (SELECT 1 UNION ALL SELECT 1),

CTE2(N) AS (SELECT 1 FROM CTE x, CTE y),

CTE3(N) AS (SELECT 1 FROM CTE2 x, CTE2 y),

CTE4(N) AS...

Whoops? 😉

ssskumar4u (8/22/2012)

---

Hi Cadavre,

Thanks for your great help.

I observed that for this input :

@str = 'A1(1).B2(2)'

output from your code : Ann).Bnn)

Desired output : A1(n).B2(n)

String manipulation shoud effect only the numbers...

ssskumar4u (8/22/2012)

---

Hi,

I have to peform a string manipulation as below:

Input: A(1).B(23).C(456)

Expected output : 1.23.456 ( need to append '.' for each substring)

Current output with below code : ...

Different approach: -

DECLARE @str VARCHAR(256);

SET @str = 'A(1).BC(10).DEF(100)';

WITH CTE(N) AS (SELECT 1 UNION ALL SELECT 1),

CTE2(N) AS (SELECT 1 FROM CTE x, CTE y),

CTE3(N) AS (SELECT 1 FROM CTE2 x,...

rajemessage (8/22/2012)

---

please take on sample of data.

Entry can be done in from lenght and to lenght like following.

900000.0001,900000.0005 so there is gap of .0004.

starting from .0001 to .0005...

sanjay831 (8/22/2012)

---

No The format is not constant, it can be qwerfgt_ser_sdft , ertgfh_fert_dfgt_ghty. I have to extract the string between first 2 underscores onli i.e. "ser" for the first...