Viewing 15 posts - 25,021 through 25,035 (of 26,484 total)
Okay, I am confused, but I would have sworn you asked for help in locking out the DBA at client sites from your application database and from outside your application....
March 18, 2008 at 11:32 am
CTE's are not for every situation. Since you are already creating and populating one or more temp tables, using CTE's in those sprocs may not be appropriate. You...
March 18, 2008 at 10:14 am
You aren't going to be able to lock out an individual with system adaministration privledges in SQL Server. This privledge grants access to all databases and their objects. ...
March 18, 2008 at 10:06 am
You can't index a CTE, just like you can't index a derived table. It should, however, use the appropriate index(es) of the table(s) referenced in the CTE.
😎
March 18, 2008 at 10:00 am
I have to agree with GSquared and Jeff. I like CTE's as well. when you have a complex query that uses a derived table, it makes the code...
March 18, 2008 at 9:21 am
Here is what i have found. You have a couple of columns that have a different collation from both the database as well as other columns in the table...
March 18, 2008 at 9:01 am
Yes: Tools, Options, scripting. There is an option under Table and View options to include collation. That should be set to true.
I tested it on one of...
March 18, 2008 at 8:43 am
From the select statement, can't really help. I need two things: the DDL for the table (or tables) including collation for character based fields (need to know what collation...
March 18, 2008 at 8:10 am
I have to agree. Just handing someone the answer to a homework problem isn't really helping them. While attending UCCS in the early 80's I worked as a...
March 18, 2008 at 6:59 am
That is interesting, but I'm not going to guess at the table structer or generate test data based on the excel spreadsheet. Please take the time to read the...
March 17, 2008 at 4:17 pm
Jeff Moden (3/17/2008)
kaiitong (3/17/2008)
I'm really appreciate your concern about me. Not to make an excuse. I've really tried on many way. I looked up in the books, searched on...
March 17, 2008 at 4:10 pm
Since all that was involved was division, addition, and multiplication; I was able to identify the correct answer without testing or reading, the order of precedence for /,*.+,- is a...
March 17, 2008 at 4:04 pm
The table DDL, some sample data (in the form of UNIONed INSERT statements), and expected output based on the sample data will help us help you figure out what you...
March 17, 2008 at 3:49 pm
In my query, I assumed that those are variables, so I replaced them with proper variable names even though I left out the declarations for them.
😎
March 17, 2008 at 2:46 pm
Viewing 15 posts - 25,021 through 25,035 (of 26,484 total)