Forum Replies Created

Viewing 15 posts - 47,596 through 47,610 (of 59,064 total)

  • RE: Wierd Counter!

    JohnDBA (10/24/2008)

    Jeff and Graber

    Thank you so much, and thank you for the explanation. It helps a lot to understand where my problem was. I really appreciate your help.

    You're...

    October 24, 2008 at 1:41 pm

    #889451

  • RE: Wierd Counter!

    ggraber (10/24/2008)

    Jeff Moden (10/24/2008)

    ggraber (10/24/2008)

    P.S. You may want to read Jeff's cool article on Running Totals which explains how this approach works http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

    Heh... that's where I was going with this......

    October 24, 2008 at 8:43 am

    #889271

  • RE: Wierd Counter!

    JohnDBA (10/23/2008)

    Please help me!

    I have this values that I need to count based on condition.

    - If the value is between 10 and 15 and the code is = a...

    October 24, 2008 at 8:39 am

    #889267

  • RE: Wierd Counter!

    ggraber (10/24/2008)

    P.S. You may want to read Jeff's cool article on Running Totals which explains how this approach works http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

    Heh... that's where I was going with this... I just wanted...

    October 24, 2008 at 7:31 am

    #889204

  • RE: Wierd Counter!

    AnzioBake (10/24/2008)

    The solution to this is very much like a solution I posted earlier, but not without a row identifier as mentioned before.

    So, you shouldn't have a problem posting the...

    October 24, 2008 at 7:29 am

    #889203

  • RE: How to cast bad data

    Sorry... didn't mean to do a stab'n'run...

    Madhivanan's method works for checking for integers or, if you will, is an "IsAllDigits" check. Adding the .d0 to an integer still produces...

    October 24, 2008 at 7:26 am

    #889198

  • RE: Using xp_cmdshell

    Dang... I forgot all about that. Thanks for the reminder.

    October 23, 2008 at 10:02 pm

    #889017

  • RE: Dangers of using MYSQL...What are they?

    BWAHA!... and they say it's "free". 😉

    October 23, 2008 at 9:39 pm

    #889012

  • RE: trigger question

    Lynn Pettis (10/23/2008)

    The BEGIN and END may not be necessary, but I find it makes it easier to see what code makes up a trigger, stored procedure etc. Especially...

    October 23, 2008 at 9:34 pm

    #889011

  • RE: Using xp_cmdshell

    What does Ctrl-C do for this here?

    October 23, 2008 at 9:16 pm

    #889010

  • RE: OSQL

    I don't know if the Express edition has OSQL... but if it does, it falls under the same rules... you must install the entire product... not just OSQL.exe.

    October 23, 2008 at 9:15 pm

    #889009

  • RE: SQL DB Performance

    The_SQL_DBA (10/23/2008)

    Do not run DBCC SHRINKDATABASE on a PRODUCTION database :w00t:, especially when it is ONLINE.

    Heh... wanna tell us why not? 🙂

    October 23, 2008 at 9:09 pm

    #889008

  • RE: 70-445 Questions and answers

    Heh... no... if I posted the questions here, they'd be no better than certification exams. Sorry.

    October 23, 2008 at 8:56 pm

    #889006

  • RE: t-sql using either table-a ot table-b

    balv (10/23/2008)

    Thanks Seth & Jerry,

    The second option works better for me.

    Balv

    How does it work better for you? Why?

    October 23, 2008 at 8:53 pm

    #889004

  • RE: Open Source Software

    Thank Goodness, NO! CLR's are bad enough! 😛

    October 23, 2008 at 8:44 pm

    #889003

Viewing 15 posts - 47,596 through 47,610 (of 59,064 total)