You might find this link helpful, too.

Unfortunately, Microsoft decided to "hide" all online licencing documentation for SQL 2008. All links refer to 2008R2....

But the best option would be to contact...

Please provide table def, sample data and expected result as decribed in the first link in my signature. It will be much more helpful than a verbal description...;-)

No, it's not clear yet.

We still need a definition of "first occurence" as Cadavre already pointed out.

The following requirement is more than vague:

I want to add the Path from Smalltable...

Please share what you've tried so far and where you get stuck.

There is no way whatsoever to 100% secure a database so that NOONE can "re-engineer" it.

Usually, someone with server based administrative privileges can add a new user. Or the backup...

You might not even need a dynamic SQL.

Did you try the "EXECUTE(query with parameter) AT LinkedServer" approach? You might need to store the returned data in an indexed temp table...

Did you try the FULL OUTER JOIN syntax?

There are two sources I can recommend for descriptions of SSSB troulbeshooting:

Rusanus blog[/url] (not limited to the article this link points to) and

Johans (aka ALZDBA) article[/url].

Those two should help you...

You may have noticed that (by the time I'm writing this reply) almost 50 people did read your post. But noone answered.

The main reason most probably is the incomplete information.

In...

I've participated in intrusion/penetration tests, too.

We thought we were in a good shape until the person we got in to perform the test found a piece of software on our...

tfifield (12/1/2011)

---

As a further comment on what Lutz posted. An updatable query in Access may not be updatable when converted to a view on the SQL Server side. ...

First of all: don't "Dude" me. This is a professional forum and not a kids chatroom.

Regarding the error:

Change ORDER BY DESC to ORDER BY ASC in cte_next_id_part

Hi,

attached is one way to solve this "puzzle" (assuming I understand the requirement correctly).

As a side note: please note how I posted the sample data in a ready to use...

There are several possible reasons for this error message:

1) When using the ACCESS Wizard to link the table, did you mark the identity columns for each table? If not, it...

Then it seems like there hass been a connection to SQL Server data before and the front end still using this "old" connection. Maybe it's even a connection to a...