With out Mention the Status Getting the Fields in SqlServer

Question

0.00/5 (No votes)

See more:

SQL

SELECT EmpName, [Visited], [ptp]
FROM
(SELECT EmpName, Code
FROM @ClientVisit) As Souce
PIVOT (COUNT(Code) FOR Code IN ([Visited], [ptp])) As p.

Hi This is My database query it working fine. But Actual my problem is i am mention in the query like [visited],[ptp]. These fields are how to pick database automatically.
Because client add new text in future.

Posted 2-Apr-12 21:08pm

ARK Kambhampati

Updated 2-Apr-12 21:19pm

v2

Add a Solution

Comments

P.Salini 3-Apr-12 3:13am

Don't Repost question
you have already posted here
http://www.codeproject.com/Questions/359303/Using-Pivot-in-SqlServer

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasad_Kulkarni · Answer 1 · 2012-04-02T21:14:00

Solution 1

You have already ask'd this question :Using Pivot in SqlServer[^]
Don't re-post the question, if you're not getting the answer then user 'Improve question' widget and update your question.

Posted 2-Apr-12 21:14pm

Prasad_Kulkarni

With out Mention the Status Getting the Fields in SqlServer

1 solution

Solution 1

Add your solution here

Preview 0

With out Mention the Status Getting the Fields in SqlServer

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us