Stringzz (6/21/2011)

---

Awesome that worked! The missing piece of the puzzle was creating the login with my credentials.

You can use the TOP clause on the outer select, not the inner select.

Now,...

b.lam (6/21/2011)

---

Lynn Pettis (6/20/2011)

---

Have you tried putting the results of the query using just the contains predicate into a temporary table (not a table variable), and then query the results?...

Will a...

Just know that this is not set-based, and is a horribly inefficient way to solve this problem, but you asked for it 🙂

There may be a less horribly inefficient, also...

If you;re a trial and error guy then show me your trials 🙂 and then we'll work on the errors.

Please have a look at this link:

http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D

You can use the function dbo.DelimitedSplit8K to split your comma-separated lists into rows and then join the resulting table to your #master table on...

Yes it can be done using a Cross Tab Query or the PIVOT operator. What have you tried so far?

Yes please. DDL stands for Data Definition Language. The term refers to any SQL code that constructs schema, e.g. CREATE TABLE, CREATE INDEX and ALTER TABLE...ADD CONSTRAINT, things like that.

I just set up the linked server on my side and found that the LDAP query did not work when providing TOP.

This worked for me:

SELECT *

FROM ...

Please post the DDL for the table in question, including all constraint and index definitions.

It can be done without a WHILE loop and can be done in a set-based manner. How large is the dataset we're talking about plowing through? I ask because there...

Cool article. I'll be interested to see how the new ORDER BY...OFFSET in Denali stacks up against Paul's technique.

http://msdn.microsoft.com/en-us/library/ms188385(v=sql.110).aspx

You're welcome. If you happen to resolve it and have a moment to post the solution for others that would be great.

Please have a look at this MSDN forum post. It references an MSDN article related to SSIS but see the section "Eliminating the "Access Is Denied" Error. The original poster...

If you get this error:

Just delete the "refresh" line (second line) in the script so it looks like this:

Set objSysInfo...