Viewing 15 posts - 16 through 30 (of 2,611 total)
Jeff - I think you have an error in your outer REPLACE - it should be a / rather than a *.
You are going to have trouble if someone actually...
February 23, 2009 at 7:03 am
Unfortunately, your expression does not evaluate to -2875 in T-SQL. (1-(982/33))*100 is going to evaluate to -2800 because the 982/33 division is going to be integer division and drops...
February 23, 2009 at 4:52 am
You need to look at the execution plans.
February 23, 2009 at 4:47 am
Can you make the Excel template use a second worksheet as it's data source? If you have a heavily formatted table in your workbook, use another worksheet with an...
February 23, 2009 at 4:45 am
[font="Courier New"]BEGIN TRAN
UPDATE
C
SET
C.DateInactivated = D.DATE_TERM
, C.UserChanged = 'Auto Close Out'
, C.DateChanged = getdate()
from
Child C
inner join DEMO D on C.CL_ID = D.CL_ID and C.Ofc_Code = D.FROMOFFICE
where
C.DateInactivated is null
and D.DATE_TERM is not...
February 20, 2009 at 8:57 am
Right Gail - you can download any of the editions and install them with some of the MSDN licenses. I never really did think about the licensing this way,...
February 20, 2009 at 8:33 am
Your MSDN license give you access to the Developer Edition of SQL Server. To install this, you either need to use the media MSDN sent you (assuming you opted...
February 20, 2009 at 8:20 am
There is an undocumented procedure:
sp_MSforeachtable
Search for it on google for more information.
February 20, 2009 at 8:16 am
So [BENCH].[RATE] is a hierarchy. You cannot use a hierarchy in a mathematical calculation like this, you need to use a member. You may have to do some...
February 20, 2009 at 7:42 am
As far as the IF:
[font="Courier New"]CASE
WHEN ISEMPTY([Measures].[Projected]) THEN NULL
ELSE ([Measures].[Projected]/[Measures].[Principal Amt])-[BENCH].[RATE]
END[/font]
or, you could use the NON-EMPTY behavior if [Measures].[Projected] is not a calculated measure. Using the NON-EMPTY...
February 20, 2009 at 6:20 am
If it can connect to the access database, it is using the 32 bit driver - there is no 64 bit Jet driver.
February 18, 2009 at 12:03 pm
A default is only going to apply when you insert a record - not when you update a record. So, do you regularly insert inactive records?
I think you may...
February 18, 2009 at 10:49 am
To use the 32 bit driver, you must run the SSIS package via the 32 bit DTExec. On SQL 2005, this means you have to use a command line...
February 18, 2009 at 8:40 am
I am going to assume you have a recordset on the SQL server already and this is the 100,000 rows you are talking about. I don't think you have...
February 17, 2009 at 10:45 am
February 17, 2009 at 10:18 am
Viewing 15 posts - 16 through 30 (of 2,611 total)