Viewing 15 posts - 1,351 through 1,365 (of 3,957 total)
Sean Pearce (10/4/2013)
Dwain, that constraint won't allow you to disable editing.
UPDATE #usTab1SET Col2 = 1
WHERE Col1 = 1;
GO
Actually Sean, I never said it would. The OP wanted to disable...
October 6, 2013 at 6:01 pm
The magnitude of the difference in your profiler trace does suggest that mTVFs could be in the same range as SFs.
Thanks for taking the time on it.
October 3, 2013 at 10:12 pm
mister.magoo (10/3/2013)
That is to prevent errors in compilation if a table does not exist.
If the code is in an SP, deferred resolution may save the day.
October 3, 2013 at 6:43 pm
Sean Lange (10/3/2013)
How can you write a constraint that won't allow an update to Col3 when the value of Col2 = 0?
I am not sure if this is what you...
October 3, 2013 at 6:36 pm
aaa121 (10/3/2013)
I need to extract data incrementally from this...
October 3, 2013 at 6:17 pm
Jeff Moden (10/3/2013)
Rather, it's an mTFV (Multiline Table Valued Function) and those can be as bad or worse than a Scalar Function.
They can?
Not that I'm a...
October 3, 2013 at 6:12 pm
My suggestion is to show us the code that's giving the error. If possible the simplest case that reproduces the error.
October 3, 2013 at 6:09 pm
Jeff Moden (10/3/2013)
WayneS (10/3/2013)
Who is going to the Summit this year? (I need to figure out who to meet up with...)
Not going. Prepping for the "great migration" from 2005...
October 3, 2013 at 6:04 pm
If I'm reading this right, you're not trying to CONVERT a DATETIME to a dd/mm/yyyy format, rather you're trying to go the other way.
Try this:
WITH SampleData (d) AS
(
...
October 2, 2013 at 10:29 pm
Which code?
Guessing here but I see that both your tables (from output results) have missing months. You'll need to fill in those missing months with a Calendar or Tally...
October 2, 2013 at 9:47 pm
CAST before you divide:
SELECT CAST(c1 AS DECIMAL(8,6)) / CAST(c2 AS DECIMAL(8,6))
FROM #t;
Or not:
SELECT 1.*c1 / c2
FROM #t;
October 2, 2013 at 9:09 pm
ken_gardiner (10/2/2013)
October 2, 2013 at 9:05 pm
Cadavre (10/2/2013)
--SAMPLE DATA--NOTE: IF YOU LAY OUT YOUR SAMPLE DATA LIKE THIS, PEOPLE ARE MORE LIKELY TO HELP YOU!
+1
Cadavre (10/2/2013)
--OPTION 1
...
--OPTION 2
I choose option 1!
October 2, 2013 at 4:21 am
Something like this?
WITH SampleData (subjectid, subjectname, parentid, organizationid) AS
(
SELECT 4058,'x', -1, 576
UNION ALL SELECT 4059,'x1',4058, 576
UNION ALL SELECT...
October 2, 2013 at 3:48 am
Jeff - Methinks you had way, way too much time on your hands this evening!
Seriously, I think you've added some truly thoughtful and insightful suggestions to this thread.
If nothing else,...
October 2, 2013 at 12:23 am
Viewing 15 posts - 1,351 through 1,365 (of 3,957 total)