Hi Ed Wagner,

The sample data added is no diff to the existing.

So I was not relying on FULLSCAN.

What is NCI??

Also I updated the stats of Clustered Index on...

Yes,

It was my FACT Table where i've updated the stats of the Index, which has hit the perfomance.

Perviously it use to take 14 Secs to retrive the data. now...

@kumar-2/All,

can you specify the string we can use as the EXPRESSION under the derived column transformation.

I've also attached a screenshot in the URL https://picasaweb.google.com/103673862776965329044/March92014#5988691608810460146%5B/img%5D.

Please see...

Hi Folks,

Even me getting the same error.

If i suppose the sample data as (considering CR and LF as usual.

MonthDayOfWeekExpenses

JanuarySunday200

JanuaryMonday100

JanuaryTuesday123

JanuaryWednesday154

Febuary Sunday200

MarchFriday100

MayTuesday123

JuneThursday 154

And my expected o/p(8...

Hi Folks,

Thanks again to every1 looking into this for me.

I was in need to generate Alphanumeric ID ( An Identity which is based on PRIMARY KEY [assigned to every row...

Hi Lynn,

i was mistaken about including the Column name in the syntax for IDENTITY_INSERT.

Well i was looking continuity for one of my table column entries which is the primary key...

Thanks Folks!!

2nd question is now addressed

an you also let me know what special we need to do to get the below executed correctly

SET IDENTITY_INSERT USERS.ID ON

Where USERS(ID INT PRIMARY KEY,...

I Also tried

SET IDENTITY_INSERT ON

but the error as above. Please help on both of above.

Agaiin Thanks Jeff!!!!

Can we consider the below way?

*ResumeID is used for tracking changes in resume(Date, new file etc)

*Naming Conventions for OS are now matched.

6) OperS(OperSID, OperSName, OperSDuration)

*DOB and GENDER are...

Thanks a lot Jeff. I would like to add 1 more table to that list.

1) Opening( OpenID, OpenName)

2) Resumes( ResumeID, CandidateID, LastDateOfUpdate,Resume)

3) ResumeAvailability(OpeningID, ResumeID) - (Derived Table)

4) Skills(SkillID, SkillName,SkillDuration)

5) SkillAvailability(SkillId,...

Thanks A Lot!!!!:-):-)

That worked perfectly. Yes were are only two records in the table as of now.

Where i wanted to swap the city details to some desired.

Well do...