Ananth@Sql (6/18/2013)

---

Thanks Gila Monster for the reply.But There is an exception with out searching which procedures are getting used

the table and what are the columns getting used is it...

No. The performance will remain the same as SQL Server will break the query into individual parts before executing.

If the view in indexed, you might see performance benefit as the...

This should give you some idea

SELECTSno,

MAX( CASE WHEN RN = 1 THEN Sname ELSE NULL END ) AS Name1,

MAX( CASE WHEN RN = 2 THEN Sname ELSE NULL END )...

You have probably interchanged the order of columns in your SELECT statement

INSERT INTO @ResultTable (curRN, prevRN, curBid, prevBid, Item, Concat)

SELECT cur.RN AS 'Cur-RN', prev.RN AS 'Prev-RN', cur.Bid AS 'Cur-Bid', prev.Bid...

Something like this

WITH cteexp(q, col) AS

(

SELECTCAST(1 AS INT) p,

CAST( 'X' AS NVARCHAR(100) )AS col

UNION ALL

...

GPO (6/17/2013)

---

Interesting problem. Thanks for posting. I must confess I have not yet read the whole article, but from what I've seen (replacing a cursor or a while loop with...

There are 2 ways to do this

SELECTCONVERT(NUMERIC(17,2),REPLACE(REPLACE(data,',',''),'$',''))

FROMdataconvert

SELECTCONVERT(MONEY,REPLACE(data,',',''))

FROMdataconvert

The explanation is present in the link I had provided earlier. I will add it once again...

WITH CTE AS

(

SELECT DISTINCT

Category

FROM Sampletable

)

SELECT Category,

Organisams = STUFF((

...

Duplicate post. Please direct all your replies here

http://www.sqlservercentral.com/Forums/Topic1463838-391-1.aspx

One simple way would be the following steps:

1. Run the SELECT query in your SSMS( SELECT * FROM YourTableName )

2. In the Results tab, you can select all the grid...

Something like this..

SELECT L_Limit,

U_Limit,

SUM(CASE

...

Hope this helps..

DECLARE @tbl_transaction TABLE

(

MemberIDINT,

CustomerVARCHAR(100),

TransactionDate DATETIME

)

INSERT@tbl_transaction

SELECT1, 'Cust1', '2013-01-01 00:00:00.000' UNION ALL

SELECT1, 'Cust1', '2013-03-01 00:00:00.000' UNION ALL

SELECT1, 'Cust1', '2013-02-01 00:00:00.000' UNION ALL

SELECT1, 'Cust1', '2013-05-01 00:00:00.000' UNION ALL

SELECT1, 'Cust1', '2013-06-01 00:00:00.000' UNION...

You will have to use ROW_NUMBER() to do this easily

If you could provide DDL of the tables involved, some sample data and the expected result, we can come up with...

Please post the table structure along with the indexes.

Have you tried creating an index on your "time stamp" column?