Viewing 15 posts - 31 through 45 (of 97 total)
Do you truly have a table like the following?
Store Cust_Count Cash Check VISA MasterCard Discover GiftCard
001 210 ...
May 14, 2008 at 2:44 pm
Are Tickers dependent on Firms?
As I look at the original presentation, it seems to me that part of the definition of the Ticker is the Firm that it belongs to....
May 14, 2008 at 2:33 pm
If this was my project, I don't think that I would try to implement these rules in the DBMS. While it's possible to do so, the question is do...
May 14, 2008 at 11:58 am
Todd --
The short answer is that %3653 will produce 10 years of days. That's 365*10 + 2 for leap years.
The thing to remember is that the modulo returns...
May 14, 2008 at 10:28 am
Unfortunately, I have seen it "break" queries as well. In addition, I have seen many instances where it cannot display the query correctly due to some usage of functions...
May 13, 2008 at 2:56 pm
Keep in mind, the Query Designer needs to keep the textual and graphical representations of the query consistent. It then becomes logical that it will keep as specific a...
May 13, 2008 at 2:11 pm
Andrew -- the Try...Catch construct does not catch statement-level recompilation errors, such as errors in deferred name resolution.
Take a look at this BOL link for more info: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/248df62a-7334-4bca-8262-235a28f4b07f.htm
Look for...
May 12, 2008 at 3:06 pm
Ritesh, to get more help on this we are going to need more/accurate information.
I have been unable to reproduce the problem you are having, regardless of my configuration. So...
May 8, 2008 at 4:55 pm
I have done this in a SQL 2005 to SQL 2005 configuration and it worked as expected, using READ UNCOMMITTED. There are some restrictions with other isolation levels, so...
April 24, 2008 at 5:12 pm
To paraphrase what has been said before me, there are definitely some index adjustments needed. Orders could use an index on PunchDate. CustomerOrderStatus could use an index with...
April 24, 2008 at 11:58 am
Peso (4/16/2008)
It depends on which line of CASE statement get evaluated first.
Since the two lines returns different datatypes (line 1 varchar, line 2 int) the first...
April 16, 2008 at 2:10 pm
Peso (4/16/2008)
SELECT CONVERT(CHAR(2), GETDATE(), 103)
Format 103 has the Day first. You need to use formats 1, 101, 10 or 110 to get a 2 digit month as the first...
April 16, 2008 at 2:02 pm
Check out BOL for CASE and notice the following:
ELSE else_result_expression
Is the expression returned if no comparison operation evaluates to TRUE. If this argument is omitted and no comparison operation evaluates...
April 16, 2008 at 1:47 pm
Any chance you have any trace output from the deadlock? If you enable trace flag 1222 and post the info from the logs here it would be very helpful.
April 11, 2008 at 5:11 pm
Take a look at sp_sproc_columns and sp_sproc_columns_90 (Assuming SQL 2K5).
GL!
April 11, 2008 at 11:08 am
Viewing 15 posts - 31 through 45 (of 97 total)