don't forget - MVP is a certification - those guys have earned their stripes

if i ever see one of his ISO xxxx posts i think i may scream

If I were put into such a position where 2 candidates were exactly equal and I could only chose one, then I'd find some way to break the tie but...

you could argue that a university degree is also worthless - but we still use it as a measure for most professional candidates...

the professional certifications are an affordable way...

likewise

it's almost definatly the nolock hint

your query plans are for the query

SELECT * FROM [PRINT_CASH_POINT] WHERE [CASH_POINT]=@1 AND [DAT1]>=@2 AND [DAT1]<=@3 ORDER BY [DOC_NO]

is this some sort of view on the data?

might i suggest that...

yes -lynn - it was a blind cut and paste from pinal dave's site (his other functions are fine, but i failed to notice the convert) - as per my...

the only way i've found to do this is to build a cross join of all clients and all weeks in the year where they are present

e.g (pseudo)

select weeknumber,count(*)

from clients...

do you...

yes

select count(distinct orglevel)

,x

,y

,z

from ...

where x=a

group by

x

,y

,z

try the following

declare @mydate datetime

set @mydate=GETDATE()

SELECT dateadd(dd,4,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))-1),DATEADD(mm,1,@mydate)),101) )

see Pinal Dave's blog post on these

http://blog.sqlauthority.com/2007/05/13/sql-server-query-to-find-first-and-last-day-of-current-month/

edit: the other suggestions are better than mine - i did a cut an poste from...

dwilliscp (6/8/2012)

---

I can not seem to figure out what I did wrong.. this does not return any records...( trying to build a statement that will get the 5th day of...

Mathew M.Varghese (6/8/2012)

---

Yes the query...

anthony.green (6/8/2012)

---

everything is written to the transaction log you cannot stop that, it all...