Viewing 15 posts - 9,916 through 9,930 (of 13,469 total)
skumar.klm (3/2/2010)
my question is how to avoid first top 10 in second selection.
this 2...
March 2, 2010 at 6:00 am
Roust i'm still trying to get a working example going, it's early and pre-cafienne for me.
perforance like this will be slow because you are using a scalar function 15K times;...
March 1, 2010 at 11:37 pm
if column 1 was was an identity(), or column 4 is a calculated column, your original statement would have worked with no errors...maybe you left something out? identities and calculated...
March 1, 2010 at 10:17 pm
ZeeAtl you need to find the traceid by select * from sys.traces
then:
...
March 1, 2010 at 3:08 pm
i used Lynns approach and stuck the results in a temp table;
no -4 offsets at all when i did that:
--create the tmp table
select getdate() As dt, getutcdate() as utcdt, datediff(hh,...
March 1, 2010 at 11:09 am
Al I'm seeing the same thing; i even changed it so that the calculation was in the loop, instead of as a function; i still got -4 offsets sometimes, but...
March 1, 2010 at 10:58 am
Ryan i think you'll want to left join the whole sub query and use a calculated column to return whether there was a complaint or not; i did not see...
March 1, 2010 at 8:46 am
i think that by using the REPLACE function for every space, and then adding one to it, you can get thecount of the words, because they are seperated by spaces;
example:
select...
March 1, 2010 at 7:09 am
harshalnag did this help you or did you do something different?
March 1, 2010 at 6:31 am
just a couple of basics; if the job starts but takes longer than 3 minutes to complete,the next scheduled job will not run, and the schedule will not resume until/...
March 1, 2010 at 6:24 am
awesome language skills, Aeterna; looks like it is Turkish.
My Google-fu was weak;
using google translator gave me this:
An Error in SQL Server when you come to Topic Promotion Karsilasiyoruz
i think we'd...
March 1, 2010 at 6:02 am
here's my best guess;
if you are going to update the main table, you need to update it from the virtual table INSERTED, which might be joined to other tables...
February 28, 2010 at 11:55 pm
easy...you just have to explicitly use the EXEC or EXECUTE command:
CREATE PROCEDURE MyProc (@tblname sysname)
AS
BEGIN
SET NOCOUNT ON
--ack! someone used this proc! send an email
--current incarnation of EmailEventSend has no parameters
EXEC...
February 26, 2010 at 9:07 am
yeah, pre-caffeine coding messes me up almost every day; I know how the little things can getcha.
glad you got it now!
February 26, 2010 at 8:56 am
at a minimum, you are missing the AS keyword:
CREATE MyProc
AS--buncha code
CREATE PROCEDURE [dbo].[EmailEventSend]
--Send Email Notification
AS
BEGIN
EXEC msdb.dbo.sp_send_dbmail
@profile_name='Basic',
@recipients='mike@somewhere.com',
...
February 26, 2010 at 8:45 am
Viewing 15 posts - 9,916 through 9,930 (of 13,469 total)