T-SQL

Question

T-SQL

Viewing 3 posts - 46 through 47 (of 47 total)

You must be logged in to reply to this topic. Login to reply

Dave62 SSCertifiable Points: 7459 More actions · Answer 1

Steve Jones - Editor (1/7/2010)
Doh! It's fixed. I must have made a mistake when I changed the question.
It now shows predicate as the answer. I'll fix points.

Steve, thanks for fixing the points but on the Total Scores page (http://www.sqlservercentral.com/TotalScores) I only see it fixed on the Question of the Day Breakdown table in the Points (won) column. The Score column on the Question of the Day table does not show the correction. You may need to fix it in both places.

Blast that de-normalized data! 😉

Dave

Peter Trast SSCarpal Tunnel Points: 4392 More actions · Answer 2

I got lucky...

I saw IN, clicked operator, hit submit and immediately hit stop on the browser as I saw the Predicate answer.

You may deduct a point if necessary for changing my answer. I throw myself on the mercy of the forum... 😀

I really DO need to read the whole list of answers more carefully...

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems

kapil_kk SSC-Insane Points: 21316 More actions · Answer 3

Recently before attempting the question I read in TSQL fncdamental book that when query filters like WHERE, Having etc used then IN,BETWEEN, LIKE specified as Predicates....

I got correct answer and +1:-P:-D

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/