Something like this?

IF OBJECT_ID('TEMPDB..#CONCAT_COLUMN_VALUES') IS NOT NULL

DROP TABLE #CONCAT_COLUMN_VALUES

CREATE TABLE #CONCAT_COLUMN_VALUES

(

GROUP_ID INT,

COL_VAL VARCHAR(5)

)

INSERT INTO #CONCAT_COLUMN_VALUES

SELECT 1, 'A' UNION ALL

SELECT 1, 'B' UNION ALL

SELECT 1, 'C'...

Man, your select was the most basics of select 😀

select * from students

Anyways, good that you got it working. And i did not ask you to post you entire table...

sqlfriends (4/10/2012)

---

How can I write one query to limit records?

Schoolname, Grade

Pathfinder K

South Shore 2

Whittier K

Lawton 2

Washington 06

Garfield 09

I want to select all the students in each...

Somehting like this?

DECLARE @CurrentDate DATETIME = GETDATE()

,@PrevDate DATETIME

;

SELECT @CurrentDate = DATEADD(MM,DATEDIFF(MM,0,@CurrentDate),0)

;

SELECT @PrevDate = DATEADD(MM,-1,@CurrentDate)

;

;WITH WorkDayNumbers (N) AS

(

...

March has the following working week days

dATE dAY

----------------------- ------------------------------

2012-03-01 00:00:00.000 Thursday

2012-03-02...

I still quite cant get my head wrapped aroound the logic. Can you please elaborate! I understand how u arrived at March's data (date and Weekday) but how did u...

Brandie, are there any Dynamic SQL somwhere that may alter that table's proprety? Normally, u cant catch if that table name is updated/used in a dynamic sql! I know that...

hbtkp (4/10/2012)

---

i am getting result like

item1 item2 item3

1 pen 34

1 pen...

Come on bro!...

What are you trying to do? You did not give us any insight into what your CAST/CONVERT should do, neither did u say what your query's intentions is. More details...

Lynn/Capt.Hector , correct me if i am wrong, we dont need DATEADD+DATEDIFF in the GROUPBY/ORDER BY; just DATEDIFF would do.

Why i say this, SQL needs to just to wrap the...

Please read this article first:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

To know how to post your data in readily consumable format! We all are volunteers! We wont have full time to guess, compile and produce...

This?

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

DROP TABLE #Temp;

CREATE TABLE #Temp

(

iD INT IDENTITY(1,1)

,CR_DATE DATETIME

,[COUNT]...

This?

DECLARE @TableA TABLE

(

RoomID INT,

BedCount INT

)

;

INSERT @TableA( RoomID ,BedCount)

SELECT 101, 5

UNION ALL SELECT 102, 2

UNION ALL SELECT 105, 3

; WITH Tens...

Or this?

DECLARE @Example

TABLE (

row_id INTEGER IDENTITY PRIMARY KEY,

...