ok, i corrected your alias problems, but not the logic.

here's the test code; try it, and see the error you get when inserting the second row:

CREATE TABLE TestUniqueNulls

(RowID int IDENTITY...

i'm pretty sure you have to to drop and recreate the linked server;

i'd script the linked server out and change the script.

I'm not much of a GUI kind of...

a nice first effort!

i think the issues still outstanding are as follows:

i think you are counting all rows, not names:

it's like counting the students in calss(ie 31) but not how...

think it through...how does a simple count() tell you whether there are duplicates?

I'd don't think you have teh test down yet.

are you familiar enough with SQL triggers that you know...

well like i said, the key is a redesign.

first, i agree on getting rid of the xml for the list of years; it might be misleading, but 99 percent or...

Sean Lange (8/7/2012)

---

Just use DBCC Timewarp and you can the Harley today!!!

The funny thing is that your points show as 9,990 next to your icon but shows as 10,000 on...

Thanks for the Articles Gianluca!

good reading.

i've done this in vb.Net / C#.Net; let us know if you are a programmer and just need a deeper code example.

once i had the reference to System.Data.SQLite it's really...

for quesitons,

i tend to read stackoverflow.com;

for code examples i like codeproject.com a lot; i love browsing the codeplex site for other examples as well;

not yet familiar with a decent...

not sure on this one now; i'm clueless on MAS90 in this case; any hints from Google on the issue?

that needs so much work, on so many levels;

there's multiple cursors, cursor within a cursor, wow.

how many total rows are in the EDWGEARS linked server table VW_FRED_AADT_HIST?

is EDWGEARS ...

Daniel Bowlin (8/7/2012)

---

Then there is the other end of the spectrum. I once had an interview that was 8 x 30 minute sessions with a total of 13 people...

here's an example i wrote that splits sys.tables into five columns;

i hope it's obvious how you could apply the same logic to your data.

WITH

baseCTE AS

(

SELECT

...

I had a similar interview like laurie had years ago; they were interested in whether I knew vb6, ADO and whether i knew javascript; the questions had a couple of...

you said if you connect to teh server as your own user, you can select from that table via the linked server, right?

that error sounds like the MAS90 user you...