weston_086 (3/5/2012)

---

ya. number of days in week means =monday to friday(working days).and for that in my table column workday has 'Y' or 'N'.where y=monday to friday and 'N' means...

weston_086 (3/5/2012)

---

ya..this is my table

CREATE TABLE dt3

(

dates DATETIME,

workday ...

to clarify

this is your "table"

CREATE TABLE dt3

(

dates ...

Hi

not sure about your requirements...are you looking to build a "calendar" table?

Dani_87 (3/4/2012)

---

My aplogise, here is more info.

This is my table

PERSON_IDYEARTERMBANKPAYRATING

1020076NABCASHB

1020077NABCredit G

...

http://msdn.microsoft.com/en-us/library/ms203721(v=sql.90).aspx

try this link

http://www.sqlservercentral.com/Books/

some are free

assefam (3/4/2012)

---

My Expected result will be ,remove Column C3 and C5 and returns the other as it is

The orginal value is

PKC1 C2 C3 ...

abhilasht (3/4/2012)

---

So we must have the details on the Periods.

Here i created one sample periods #period table. and come one more issue to find the available periods. So it...

abhilasht (3/4/2012)

---

Yes PIVOT is the best

CREATE TABLE #Sales (SalesDate smalldatetime,Customer int,Sales decimal(20,4))

INSERT INTO #Sales Values ('2011/11/01',1,10)

INSERT INTO #Sales Values ('2011/11/02',1,10)

INSERT INTO #Sales Values ('2011/05/02',2,25)

INSERT INTO #Sales Values ('2011/12/01',2,20)

INSERT INTO #Sales...

R.P.Rozema (3/3/2012)

---

? I think I don't get it? But isn't this simply answered by no longer specifying the columns names as 'Jan', 'Feb', etc, but simply label the columns something...

siva 20997 (3/3/2012)

---

The reply to the original question will be long and hard to understand once done

hence I just touched upon the subjects which is needed to be understood to...

does the following give any more ideas?

USE [tempdb]

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id...

Hehe...thought so, sorry.

anyways....please read this post/thread....http://www.sqlservercentral.com/Forums/FindPost1223418.aspx by Jeff Moden

will give you...

not sure if this is what you are really asking for....maybe something more dynamic perhaps

but this answers your question 🙂

CREATE TABLE #Sales (SalesDate smalldatetime,Customer int,Sales decimal(20,4))

INSERT INTO #Sales Values ('2011/11/01',1,10)...