Viewing 15 posts - 26,626 through 26,640 (of 59,102 total)
ben.brugman (6/14/2013)
g_demetriou (6/14/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 15, 2013 at 9:33 am
To add to Luis' good posts, the Tally Table does have the limit of whatever it contains. Most people make a Tally Table to contain 11,000 or fewer rows....
--Jeff Moden
Change is inevitable... Change for the better is not.
June 15, 2013 at 8:23 am
Are you getting an error or just looking for a "peer review"?
--Jeff Moden
Change is inevitable... Change for the better is not.
June 14, 2013 at 6:11 pm
Ed Wagner (6/13/2013)
Jeff Moden (6/13/2013)
mahavidhya24 (6/12/2013)
Thats not possible to call store procedure inside the function,we can call function with in the store procedure
Oddly enough, they just proved that it was...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2013 at 10:55 pm
rayoftennessee (6/13/2013)
Disregard. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2013 at 10:21 pm
I agree with almost everything you said except the last part. I don't consider using SSIS (for example) to be a "more robust" way of doing things. More...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2013 at 7:02 am
mahavidhya24 (6/12/2013)
Thats not possible to call store procedure inside the function,we can call function with in the store procedure
Oddly enough, they just proved that it was possible if you use...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2013 at 6:41 am
Sean Pearce (6/13/2013)
Sean Pearce (6/13/2013)
masterjd (6/12/2013)
Here is an example of one of them.That is not a user defined system proc.
You really should not change system stored procs at all. For...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2013 at 6:36 am
Kinston beat me to it but, to add a little more checking, here's what I came up with.
--=============================================================================
-- Create and populate a test table. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2013 at 6:32 am
Matt Miller (#4) (6/12/2013)
GilaMonster (6/12/2013)
Ed Wagner (6/12/2013)
Just because we can do something doesn't mean we should. The technical workaround does work, but I don't think it's a good idea.
It's...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 10:00 pm
Ed Wagner (6/12/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 9:50 pm
System stored procedures typically are NOT located in the MSDB database... not even the home grown ones. See if you can find it in the Master database. If...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 9:38 pm
SriSudha (6/12/2013)
Please help me,
In my table have a one date column. It contains data in different formats .I want to set all these...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 9:33 pm
Kingston Dhasian (6/4/2013)
SELECT*,
CASE WHEN SUBSTRING(rate, 1, 1) = '*' THEN '10' ELSE SUBSTRING(rate, 1, 1) END AS game1,
CASE WHEN SUBSTRING(rate, 2, 1) = '*' THEN '10' ELSE SUBSTRING(rate,...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 9:28 pm
Ah, crud. As soon as I find a method to prevent usage of cmd.exe, I find someone with easy methods to blow through the prevention. I've updated the...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2013 at 9:03 pm
Viewing 15 posts - 26,626 through 26,640 (of 59,102 total)