joshtheflame (11/14/2010)

---

do one thing plz...I have the following data in TASK_DETAIL...IN TASK_MASTER..u can create just two records with the following n test..results are strange..

task_id.......task_name

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

1 ...

joshtheflame (11/14/2010)

---

I dont have MONTH COLUMN in my table 🙂 as I am populating days of the month dynamically all i have is TASK_ID, TASK_DATE, TASK_COUNT ...thats it..now how to...

@Bitbucket

First of all did you test the query I posted earlier?

The first query does exactly what the OP wants.It continues to execute rest of the script even though...

--Put it all together into a pivot query.

set @sql = 'SELECT Task_Name, ' + @columnnames + ' , Total FROM (';

set @sql = @sql...

OR

Try this

WHEN COUNT(customer_id) = convert(varchar(2),0) THEN 'No customers' ELSE COUNT(customer_id) END

PS - I haven't tested it

When SET XACT_ABORT is OFF,in some cases only the Transact-SQL statement that raised the error is rolled back and the transaction continues processing. Depending upon the severity of the error,...

You can change your @sql part to something like below.I cannot test it since you didn't post your table structure and sample data.

Notice the new column name "TaskTotal"

--Put...

I wouldn't waste my time posting the answers for OP.He is applying for a job he is not eligible for as simple as that.

He should get the required experience or...

set xact_abort off

go

CREATE TABLE #T(Cod VARCHAR(30)primary key)

INSERT INTO #T SELECT 'jkl'

INSERT INTO #T SELECT 'lmn' --Duplicate entry in input stream

INSERT INTO #T SELECT 'abc'

INSERT INTO #T SELECT 'lmn'...

Also my solution will work for SQL 2005 and later.

I am assuming you are using a version greater than SQL 2000 since you have posted your question in SQL 2005...

This is something called as a "derived table" which encapsulates the result of a SELECT statement in the FROM...

You really wanna know?

I thought you would rather...

Craig Farrell (11/9/2010)

---

Sachin.Nandanwar (11/9/2010)

---

Now that's better.

Below is your query.

select * from

(

select *,row_number()over(partition by employeeid order by salary desc)rid from salary

...

Now that's better.

Below is your query.

select * from

(

select *,row_number()over(partition by employeeid order by salary desc)rid from salary

)T where rid<=2

OK.So here is the answer

select * from table

A "Blah Blah" answer for a "Blah Blah" question posted by "Blah...