Viewing 15 posts - 391 through 405 (of 5,502 total)
What exactly aore you trying to do?
The first query you posted limits the number of rows since you perform an inner join on CRS, HIS, and STU and use this...
October 13, 2013 at 6:04 am
What's the reason for matching two user to the same group?
If you want to make sure both groups will use the same permissions, add a separate database.
Example:
CREATE ROLE [App_Agents]...
October 13, 2013 at 5:02 am
The table script provided even more indicate an Oracle DB. So I'm out.
October 9, 2013 at 12:12 pm
I'd question the initial query.
It seems like it's Oracle syntax. AFAIK, SQL Server doesn't support "Select Min(U2.Id) Keep (...)" syntax. For sure not SS2K8 (as indicated by the forum...
October 9, 2013 at 12:10 pm
J Livingston SQL (10/9/2013)
LutzM (10/9/2013)
Why did you open another thread?What about the answers already provided here?
that post was to split into columns.....now it seems into rows.....
Yep, you're right.
I must have...
October 9, 2013 at 12:04 pm
Why did you open another thread?
What about the answers already provided here?
October 9, 2013 at 11:50 am
This is usually a SQL Server site.
If you get lucky, there'll be a person lurking around having the ORACLE knowledge required. But that would be random.
For Oracle, asktom.oracle.com is a...
October 8, 2013 at 5:59 pm
You wouldn't need a c.u.r.s.o.r *cough*. It'll be dynamic SQL anyway (at least from my perspective...).
The question is:
How do you know, that the search conditions are combined using AND instead...
October 8, 2013 at 5:50 pm
You might want to look into sql-multi-script (www.red-gate.com/products/dba/sql-multi-script), a tool by RedGate.
October 8, 2013 at 5:20 pm
GilaMonster (10/8/2013)
LutzM (10/8/2013)
if we update a "left" table in a 1 ..n relationship, will sql server perform n updates or will it just do a single update?Single.
I know. But...
October 8, 2013 at 4:59 pm
The classic answer would be: it depends. It's impossible to "clarify". But it's always good to know what vulnerabilities have been detected and fixed...
Once you know, you'll need to verify...
October 8, 2013 at 4:51 pm
If you insist doing it "in single statement", how about this:
EXEC (...).
If we'd agree this would qualify as a single statement, we're all set. Right? 😀
To "support my argument": BOL...
October 8, 2013 at 4:16 pm
@mickyT: I just referred to the very first question of the OP:
We want to be able to use t-sql to create a simple bar graph image file, to be inserted...
October 7, 2013 at 4:56 pm
I really do like mickyT's approach!!!
It's definitely not "out-of-the-box".
The question is: How can the "graph format" be used together with sp_send_dbmail. Any thoughts?
October 7, 2013 at 3:56 pm
as long as it is guaranteed there'll always be a single node for each and every node block referenced in the code, I agree that your code is more efficient.
But...
October 7, 2013 at 3:21 pm
Viewing 15 posts - 391 through 405 (of 5,502 total)