Forum Replies Created

Viewing 15 posts - 5,371 through 5,385 (of 8,731 total)

  • RE: Indexes evaluation

    Thanks to all of you.

    I just re-read all of the posts and Jack's comment puzzles me. I'll try to find out and if I do, I'll come back.

    This table is...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 2, 2015 at 6:08 pm

    #1767511

  • RE: Executing a SQL Server Stored Procedure in PHP

    I'm confused.

    Were you able to call your GetMonthDays procedure but you want to use procedures to call data from SQL? If that's the case, it would be the same...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 2, 2015 at 4:01 pm

    #1767499

  • RE: Tally-OH! Help

    If I understood correctly, this should help you:

    CREATE TABLE #Source(

    SomeString varchar(8000))

    CREATE TABLE #Test(

    [STD_SiteName] [varchar](20) NULL,

    [STD_Parameter] [varchar](16) NULL,

    [STD_Qualifier] [varchar](6) NULL,

    [STD_PQ] AS (([STD_Parameter]+'_')+[STD_Qualifier])...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 2, 2015 at 3:25 pm

    #1767494

  • RE: Comparing Bits and Ints

    This is what I get in the Predicate for each SELECT statement.

    SELECT *

    FROM bitTest

    WHERE somebit = 1

    --[Test].[dbo].[bitTest].[somebit]=[@1]

    SELECT *

    FROM bitTest

    WHERE somebit = 'True'

    --[Test].[dbo].[bitTest].[somebit]=CONVERT_IMPLICIT(bit,[@1],0)

    SELECT *

    FROM bitTest

    WHERE somebit = 112

    --[Test].[dbo].[bitTest].[somebit]=[@1]

    --No results

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 2, 2015 at 10:07 am

    #1767441

  • RE: Are the posted questions getting worse?

    I'm working here as most of the people in my office. Except for my boss who said he was sick and now I have to fix all the problems he...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 2, 2015 at 9:57 am

    #1767437

  • RE: Comparing Bits and Ints

    I just made a test and it doesn't seem to be an implicit conversion when using 1 or 0. It's different when you use 'true'.

    CREATE TABLE bitTest(

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 2, 2015 at 8:42 am

    #1767407

  • RE: The End

    Nice question, I checked the answer just to be sure and realized that a nice wrong answer would have been June 6, 2079 which is the limit for smalldatetime. Mostly...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 31, 2014 at 10:09 am

    #1767231

  • RE: Go Pats

    No, way!

    Go Ravens!

    Ravens Nation 😀

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 30, 2014 at 11:59 am

    #1767058

  • RE: Wow!!! I didn't know that could be done - Datetime Calculations

    Yes, it's possible, but I wouldn't advice on using decimals on calculations as it's easy to get it wrong.

    For example, .01 translates into 864 seconds instead of 900 seconds. To...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 30, 2014 at 9:17 am

    #1767025

  • RE: Row-level security

    Could you create filtered views and give permissions over those views?

    I'm not sure how you're handling your security.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 26, 2014 at 11:03 am

    #1766494

  • RE: The Rich Rewards of Tuning SQL

    Of course, buying new hardware can get you some time. But how much time would you get if your app is full of crappy code? There's no piece of hardware...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 26, 2014 at 10:02 am

    #1766491

  • RE: Are the posted questions getting worse?

    Happy Holidays to everyone!

    I wish that you can enjoy quality time with your families and beloved ones and may the new year bring you happiness and growth (hopefully not in...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 26, 2014 at 9:01 am

    #1766479

  • RE: Why can't we use variables in DDL?

    You can't use variables to replace object names. That goes for DDL, DML, DCL or anything in T-SQL.

    You could use dynamic SQL for this.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 24, 2014 at 8:59 am

    #1766349

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (12/23/2014)

    Lynn Pettis (12/23/2014)

    Eirikur Eiriksson (12/23/2014)

    Lynn Pettis (12/23/2014)

    Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS 2015 now....

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 23, 2014 at 4:06 pm

    #1766283

  • RE: Are the posted questions getting worse?

    GilaMonster (12/23/2014)

    http://www.sqlservercentral.com/Forums/Topic1646163-391-1.aspx

    I'll just be in the corner sobbing softly...

    Smile, you're on Candid Camera. 😀

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    December 23, 2014 at 2:13 pm

    #1766266

Viewing 15 posts - 5,371 through 5,385 (of 8,731 total)