Here are two potential solutions, but as you haven't answered any questions, no idea which one may be the one you want or if it is something completely different.

SELECT

...

Really don't have enough information to help you at this point. I am really more visually oriented, in that if I can see what needs to be done, I...

Bouke Bruinsma (7/23/2012)

---

We have encountered a strange behavior in performance. A query seems to perform worse when the default language of a user is German.

User A has sysadmin rights, user...

Sean Lange (7/23/2012)

---

Not sure about Lynn but my crystal ball is still broken. We can't see your screen, we have no idea how you want to map these columns, we...

Here is my guess, you are constrained by the amount of memory the OS can use. If SQL Server could use 64GB, but the OS can only use 32GB,...

Or, you can go here: http://msdn.microsoft.com/en-us/library/dd631853(v=sql.10).

Ian.Donaldson (7/23/2012)

---

Hello All, A little stuck I am trying to get a table to show some information but also need to count against values which may not be there example...

More so as SHOW USER returns an error in SQLCMD.

So yes, check the Oracle documentation, it may provide better answers than we can give you.

Possibly. Is there a way to modify the prompt in SQLCMD?

Scott D. Jacobson (7/23/2012)

---

Hey,...

GSquared (7/23/2012)

---

You'll need to look at the Oracle documentation for that. This...

SQLRNNR (7/23/2012)

---

Just grant them access to the Dev instance on the server rather than RDP. Then install management tools on their desktops and allow them to use SSMS to...

Matthew Cushing (7/23/2012)

---

That's what I was thinking, but I felt like I was just making a random guess. I'm mostly looking for advice for which direction to head rather...

The first SET DATEFORMAT is what started to throw me, then I realized that it wouldn't lay a part in the conversion of the date literals when the view was...

Without DDL, sample data, and expected results based on the sample data it's a little hard to provide specifics. What you may want to look at as part of...