the problem with pivots is that you seem to have to know what the columns are before you get the data

the only way you can do this is to use...

you should be able to see from task manager what the AV product is using

if you are concerned about the amount it's using it migt be worth looking at...

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...