Viewing 15 posts - 5,011 through 5,025 (of 7,597 total)
I'd stick with a straightforward scalar function for that. For any column that can't have NULL values, naturally you can remove the IS NULL conditions.
CREATE FUNCTION dbo.Compare_User_Settings_To_Profile
(
...
June 16, 2015 at 3:55 pm
I don't like to use WEEKDAY as it has dependencies on @@DATEFIRST. Maybe this setting-independent method instead:
SELECT *
FROM Test
WHERE DATEDIFF(DAY, DischargeDate, ApptDate) <= ( 8 +
...
June 16, 2015 at 3:44 pm
No, an explicit COMMIT will lock in the transactions.
But if an explicit BEGIN TRANS was issued and either:
1) a COMMIT has not yet been issued for that trans
or
2) a ROLLBACK...
June 16, 2015 at 9:10 am
Is there a possibility the transactions for table Purchase Order not have been committed, so when the second procedure is running does not select correctly?
It's certainly possible, particularly if the...
June 15, 2015 at 6:26 pm
Get rid of @TransactionActive. And don't use @@TRANCOUNT either. And since you're not using SAVE TRANSACTION, the names on the TRANSACTION statement are superfluous and can be removed.
The...
June 15, 2015 at 6:23 pm
The syntax is actually perfect.
You might need to use A.User_ID rather than A.EffectedUser_ID in the CASE statement, I'm not sure which one you need based on your description, but other...
June 15, 2015 at 6:13 pm
That's a valid point, but, from what I've seen, it will just not be possible to force all clients to the current version. They delay for all sorts of...
June 15, 2015 at 5:19 pm
Our company has that exact situation. Just accept that you will have different "versions" of the product in effect for different clients at different times. It's just too...
June 15, 2015 at 10:04 am
MAXDOP controls whether a single query plan can be parallelized, and if so, to what extent. Other SQL tasks can, and usually will, still be running across the other...
June 12, 2015 at 1:15 pm
Or use in-line subqueries:
SELECT ID, OrderNumber,
(SELECT MarketCenterCity
FROM MarketCity
WHERE MarketCityId = o.SrceMktId) AS SourceMKT,
...
June 12, 2015 at 12:36 pm
Ed Wagner (6/12/2015)
Lynn Pettis (6/12/2015)
ScottPletcher (6/12/2015)
June 12, 2015 at 12:12 pm
Again, add another log file to the db, and do it quickly. That should allow SQL to complete pending transactions. See my last post for additional details.
June 12, 2015 at 9:54 am
We can't directly do homework or other coursework for you. However, we can give you general pointers.
First you need to design tables to hold data. Each table should...
June 12, 2015 at 9:51 am
Your best chance might be to "unformat" the drive. Some formatting software makes provisions to do that. Of course the more you've overwritten any part of the drive...
June 12, 2015 at 9:44 am
Add another log file to the db. Put it on a drive with plenty of space. Allow SQL time to get caught up on log writes, and the...
June 12, 2015 at 9:41 am
Viewing 15 posts - 5,011 through 5,025 (of 7,597 total)