logic needed for date

Question

Post reply

logic needed for date

Viewing 6 posts - 16 through 20 (of 20 total)

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

Sri8143 SSCertifiable Points: 5251 More actions · Answer 1

Sri8143

SSCertifiable

Points: 5251

February 27, 2008 at 10:42 am

#782724

thkz miller ...got it

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

Sri8143 SSCertifiable Points: 5251 More actions · Answer 2

can i know what is checksum what does it do i tried in msdn but i couldnt understand the exact us of that i tried some examples but i didnt get that

select checksum(listprice)from dbo.nydirect

8447545

where as the listprice is 48.75 ...whats the check sum then ???? n even checksum_agg and otheres can u give any example or link whcih is clear ......

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 3

A link it is:

ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/tsqlref9/html/e26d3339-845c-49c2-9d89-243376874c13.htm

or if the link fails (it refers to BOL - Books On Line - your trusty manual for SQL Server)

download and install BOL from here

http://www.microsoft.com/downloads/details.aspx?FamilyID=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

and then look up 'CHECKSUM function' and 'CHECKSUM_AGG function'.

🙂

/Kenneth

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 4

Ken... the OP actually wants to know what the algorithym is for the CheckSum function.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 5

Oh really? Must have missed that.. I read it as a question of what checksum was used for.. 😉

Anyways, what use would anyone have on how MS have implemented these functions?

Much better imo to find out how they work and how they behave.

The algorithm behind it isn't of any use to anyone of us, what we need is what does these functions guarantee us, and what not, should we use and depend on them.

Or am I missing something?

Anyways, that is written in BOL.

/Kenneth

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 6

Sorry, previous knowledge... he's asked for it before on a different thread.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions