Viewing 15 posts - 25,021 through 25,035 (of 26,487 total)
Or
SELECT
*
FROM
dbo.tblData
WHERE
MonthID between ((3 * @Quarter) - 2) and (3 * @Quarter)
If MonthID is indexed, you still get the...
March 18, 2008 at 1:24 pm
Roy Ernest (3/18/2008)
Since the topic is already there, has anyone had Bat? You know , the...
March 18, 2008 at 12:26 pm
jfletcher (3/18/2008)
March 18, 2008 at 12:23 pm
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
Viewing 15 posts - 25,021 through 25,035 (of 26,487 total)