Mine and urs both will do a table-scan, as is with the case of Splitter. But, urs look tidier and i forgot totally i can use comma to concatenate (i...

Eugene Elutin (3/2/2012)

---

ColdCoffee (3/1/2012)

---

Hey R.P.R , the OP does not want the rows that have 12 values , instead the rows that contain the value 12 ; look at the...

Can you please elaborate on what you wnat?

PLease read the following article on how to post your question http://www.sqlservercentral.com/articles/Best+Practices/61537/

Henrico Bekker (3/2/2012)

---

Thanks, you are definitely onto something here, although the results for the second row calc to 0...

idcurrmonth ...

I took the liberty of adding an IDENTITY column to the base table.

Here is my stab at the issue

; with cte as

(

select id,currmonth,nextmonth, monthly,startval , cast( (monthly * 2.00) as...

Hey R.P.R , the OP does not want the rows that have 12 values , instead the rows that contain the value 12 ; look at the expected output and...

Dont open multiple thread for the same request. Have patience, people here will for sure attend your question.

Cross post. Please redirect all replies to this thread http://www.sqlservercentral.com/Forums/Topic1260602-391-1.aspx

Here is one way:

First setting up test data:

IF OBJECT_ID('TempDB..#Sample') IS NOT NULL

DROP TABLE #Sample ;

CREATE TABLE #Sample

( ID INT IDENTITY ,StringVARCHAR(200)) ;

INSERT INTO #Sample (String)

...

something like this, may be?

-- Open a tran

BEGIN TRAN

-- Choose data before update

SELECT * FROM #temp2

UPDATE t2

SET t2.val1 = tCrsApp.val1

, t2.val2...

something like this?

SELECT DISK

,CONVERT(CHAR(10),PollTime,120)AS Date

,AVG(Utilization)

FROM Disk

WHERE CONVERT(CHAR(10),PollTime,120) = '2012-02-20'

AND name = 'TEST'

Group by Disk, CONVERT(CHAR(10),PollTime,120)

Order BY Disk desc

Are you trying do something like this?

IF OBJECT_ID('TempDB..#Sample') IS NOT NULL

DROP TABLE #Sample ;

CREATE TABLE #Sample

( Dates DATETIME , wrange VARCHAR(20)) ;

INSERT INTO #Sample (Dates)

...

I have seen that query somewhere 😀

ANyways, i can what you are trying to do, but why do u need GROUP BY in your code? for every date, you need...

Remove all columns from GROUP BY except DISK and add CONVERT(CHAR(10),PollTime,120)

CoolDown (3/1/2012)

---

I am trying to update val1 and val2 columns based on join of table 1 and table 2 on id column.

When values are updated for both column,...

That depends on...