i think this is 99% correct

with x (name,id,gid)

as

(

select a.name,a.principal_id as id,b.role_principal_id as gid from sys.database_principals a inner join sys.database_role_members b on b.member_principal_id=a.principal_id

where a.principal_id=5

union all

select a.name,a.principal_id as id,b.role_principal_id as gid...

how about in access running a maketable query based on the linked table and then pushing that to your sql server ?

if it's a new development have you considered moving to SQL 2008/2012 and using filestream ?

i've used the file full text search before and it leaves you at the mercy...

or you could just turn the column of data into a CSV format

declare @str varchar(max)=''

select @str=@str+name+',' from syscolumns where....

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