Thank you. SQL Server purists may howl, but I'm pretty pleased with it. It took a while to get all the string assemblies working correctly (missing commas,...

Absolutely. In fact, I have an app that gets most of its data via such queries. After much experimentation, including a SQL in the City session in London last summer,...

Sean Lange (8/22/2013)

---

Are you always this snarky to people who are honestly trying to help? I tried to explain how TOP works. Maybe TOP is not the most efficient way...

L' Eomot Inversé (8/22/2013)

---

Obviously there's no way to avoid a complete scan when all the values are the same.

It's possible to have something which takes quadratic time when...

Steve Jones - SSC Editor (8/22/2013)

---

Doctor Who 2 (8/22/2013)

---

I like what you wrote here, Steve, but I wonder how practical it is. However, it might just be my work environment....

Sean Lange (8/22/2013)

---

No that is how it works. If you use the TOP predicate you generally should also use an order by clause. Without the order by there is no...

Doctor Who 2 (8/22/2013)

---

I like what you wrote here, Steve, but I wonder how practical it is. However, it might just be my work environment. Having worked in a small...

opc.three (8/21/2013)

---

... consider a Linked Server configured to connect to and issue queries against AD. Getting a user's group memberships, or a group's members list, is trivial using a Linked...

Well, I got it running using exec xp_logininfo 'nmp\paleoces', 'members'and looping to extract all members. That works, although it seems to me it's asking the same question, just in...

I do everything myself, application side and database side. I do not allow (myself) access to tables directly. Views, read-only, even if it's just a "SELECT everything FROM table" statement....

sqlsurfer101 (8/19/2013)

---

When a valid AD account doesn't have access to the instance, I think you get no results, but when the AD account doesn't exist is when you generally get...

sqlsurfer101 (8/19/2013)

---

"I'm using xp_logininfo to find which domain group a user belongs to, and manipulate some controls in the application based on the results." - Why are you using SQL...

Yeah, it's a pretty interesting place. Some of the top management is straight out of a Dilbert cartoon, but the people...

No, actually I'm primarily...

ChrisM@Work (8/9/2013)

---

One of the items (table sources) in your FROM list has two rows per single row in table Podrobnosti. Since there's no aggregation and all of the other tables...