Hi Andy

Thanks for that. I got it working with your pointer

I still need to read up on this partion thing

I do agree with most of your points. But still fail to see couple of things from my understanding of how computers function.

Wheather the code is inLine or scalar function...

Eugene

Would like to know if there is lot of differnce in the perfomance bitween

User Defined Functions (like what I have posted)

and system defined functions like DateAdd and DateDiff

and if...

The last date of the previous month compared to 4/1/2012 is 3/31/2012 which is a Saturday. According to the OP's requirements, it should return the next weekday after that which,...

Agree AND is not divion (I didnt mean divion was AND, I meant the expalantion I had written is how AND works)

I was using the divion to convert our normal...

I have used Bulk Insert to do this but my files have been Comma Serperated

I also have a table speacially for this purpoase. In your case you have a table...

It should read

Papersdue 1 ; Papers due (2^1) 00000001

Dueflag 2 ; Due letter sent flag (2^2) 00000010

Chaserflag 4 ; Chaser letter sent flag (2^3) 00000100

Feesettle 8 ; Fees settlement...

Sorry there is a & operator in SQL

and the solution given by the vetran does work once converted to int

The decimal or integer doesnt matter as long as the principal is understood

This is what he said and can be represented further (just concentrate on the number not the decimal...

You need to add this function

CREATE Function [dbo].[Get_MyDate]( @dDate DateTime ) Returns DateTime

AS

begin

declare @mDate DateTime,@m1 Int,@m2 Int,@d1 Int

...

This is what he said

Papersdue 1 ; Papers due (2^0)

Dueflag 2 ; Due letter sent flag (2^1)

Chaserflag 4 ; Chaser letter sent flag (2^2)

Feesettle 8 ; Fees settlement flag (2^3)

Statement...

These are like Bits in a Byte being switched on or off

AND ing with whatever (in this case 32) is the correct way

However doing that seems to be a problem...

Hi Guys, Last time I wrote something here I was castigated. Just tell me if my method is bad

It Pivots the test and the joins test1

I know some will say...

I have read the article "Converting Rows to Columns".

I dont undertand why at the start we are using the case stament to split it into 4 quarters

group By...

Morning Folks, Is every one on this site in UK ?

Let me tell you my reasoning why I do it my way. When I got switched over to SQL few...