shilpaprele (10/8/2012)

---

I have one procedure with parameter @P.

If @p= null & table abc has many rows with col1 = null, then following select does not reurn the...

dwain.c (10/7/2012)

---

I find it extremely annoying that this does not work:

DECLARE @Weight FLOAT = 0

,@STDate DATETIME

,@EDate DATETIME

SELECT @STDate=MIN(DATECOL), @EDate=MAX(DATECOL) FROM #SAMPLETABLE

;WITH...

dwain.c (10/8/2012)

---

<<snip>>

Nagaram's is the fastest so far - it's a good 20% faster than mine. I'm having a look to find out why - probably the tally-table generation. Yours does...

dwain.c (10/8/2012)

---

ChrisM@Work (10/8/2012)

---

Hi Dwain, I came up with this last night but ran out of time to post;

;WITH WholeRange AS (

SELECT datecol = DATEADD(day,n,d.Startdate)

FROM (SELECT Startdate = MIN(datecol), daysSpan =...

Hi Dwain, I came up with this last night but ran out of time to post;

;WITH WholeRange AS (

SELECT datecol = DATEADD(day,n,d.Startdate)

FROM (SELECT Startdate = MIN(datecol), daysSpan = 1+DATEDIFF(day,MIN(datecol), MAX(datecol))...

Eliza (10/7/2012)

---

Hi All,

Thanks for some of the solutions, I've tried a few.

SELECT SUBSTRING(@var,28+CHARINDEX ('CustomerFornm: Changed from ',@var),CHARINDEX('CustomerDOB',@var)- CHARINDEX ('CustomerFornm: Changed from ',@var)-28) AS 'Is this really what you

want?'

Doesn't work...

nico 71726 (10/7/2012)

---

whist experimenting with the query noticed that by removing the TOP1 the query suddenly started running in parallel mode which was A LOT faster. Still needed the TOP1...

S_Kumar_S (10/5/2012)

---

This is quite impressive but it doesn't work for some scenarios. e.g. this one :

insert into t1

select 'AAA22222222222222BB5BB 33CCCCCCCCC342234234'

EDIT: I meant it for Chris response:

SELECT

t.name, x.New_Name

FROM...

Sean Lange (10/5/2012)

---

Still nothing to test with but I think this might be close to what you want...

select A, b, MAX(C), MAX(D), MAX(E), MAX(F), g

from

(

SELECT distinct

BASE1.AssetID AS a

,BASE1.Name As b

,case...

The FROM list and WHERE clause of both of the queries is identical:

FROM BMC_CORE_BMC_BaseElement BASE1 (NOLOCK)

LEFT JOIN BMC_CORE_BMC_BaseRelationship RELA (NOLOCK)

ON...

prady_1988 (10/5/2012)

---

Sorry, I may have mislead you.

The values under Relationship is taken from 2 tables.

Table1 -> AssetID, AssetName

Table2 -> Relationship1

Table3 -> Relationship2

Table4 -> Company

Hence for each record I am getting...

Ah,...

kapil190588 (10/5/2012)

---

Hi maida,

here is the query wch list out all the dates 1 year less than the current date..

Select LTRating ,RHDate from Accounts and If LTRating ='D' then RHDate <...

naga.rohitkumar (10/5/2012)

---

thanks for reply

actually the applications user want to take the data directly from the database instead from application

to which he want to create a stored procedure...

S_Kumar_S (10/5/2012)

---

This is really good but problem is that my table has multiple rows and this is a table function. So it has to be a scalar function for me...