the file must exist on the server, unless you explicitly call a unc path like \\servername\c$\Files\12656.jpg

even then, the service account that SQL runs under must be the one with permissions...

ok while this gives me the desired results, it bothers me to be using distinct.

under the covers it's twisting these five rows into 250K rows, and back down to ~1300...

the question really is WHY do you need to know if any are happening, if the developers are allowed to do that. what do you want to do that is...

you ar emissing the empty string part i put in my example:

ISNULL(person_name,'')

null cannot be compared to any value, as NULL is undefined,so it affected your logic.

...AND ISNULL(person_name,'') NOT IN ('john smith', 'sally brown') would resolve the issue.

its possible, but you have to have defined the matching criteria.

until you define logic for identifying the duplicates, you cannot consolidate duplicates. also, you probably need additional logic, since you...

i showed you a basic example that gets...

the best way this is done by joining to a permenant Calendar table first, which contains all possible dates, and left joins to your data.

if you don't have one, you...

i believe when you grant VIEW ANY DEFINITION TO [SpecialUser], that inherently grants connect permissions to each database; you do not need to add anything additional for that permission.

it...

the datalength of an NVARCHAR is doubled, as that is telling you how much storage is required in SQL;

i don't think that is relevant in c#, is it?

/*--Results

(No column name)(No...

then no, you cannot do what you are asking.

you cannot concatenate an image to text.

you might be able to display text and image...

since this is an instance, and you already conencted to a default instance on port 1433, i doubt very much the named instance is listenting on 1433 like you think.

connect...

well, this has more to do with the display medium more than anything. if you mean checkbox is actually code like this:

<img src="Mywebsite.checkbox.gif">

or

<input type="checkbox" >

or your image is actually a...

inside the CLR, if you are using a datatable to hold the data, you can find the max length of the values in the a column, , or if...