Forum Replies Created

Viewing 15 posts - 481 through 495 (of 567 total)

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/23/2012)

    L' Eomot Inversé (12/23/2012)

    Lynn Pettis (12/22/2012)

    Constantly amazed by the number of people who think that full backups truncate the transaction log. Where do they get such ideas?

    That's a...

    December 27, 2012 at 8:41 am

    #1571888

  • RE: Staging Deployments

    Eric M Russell (11/30/2012)

    If an application is loosely coupled (if the term is appropriate here) with the database using stored procedures, web services, and meta-data configuration, then even significant changes...

    November 30, 2012 at 9:22 am

    #1564460

  • RE: Exercises in t-SQL

    Eugene Elutin (11/29/2012)

    Sorry for my a bit unorthodox view on " FizzBuzz" problem in T-SQL, but couldn't keep myself quiet :hehe:

    I don't think it's a good T-SQL question at...

    November 29, 2012 at 8:28 am

    #1563827

  • RE: Exercises in t-SQL

    Jeff Moden (11/28/2012)

    wolfkillj (11/28/2012)

    Jeff Moden (11/27/2012)

    CELKO (11/27/2012)

    Create a million row FizzBuzz table. FizzBuzz isn't a comment. It's the name of a very common problem based on a...

    November 28, 2012 at 9:41 pm

    #1563554

  • RE: Exercises in t-SQL

    Jeff Moden (11/27/2012)

    CELKO (11/27/2012)

    Create a million row FizzBuzz table. FizzBuzz isn't a comment. It's the name of a very common problem based on a child's game, is...

    November 28, 2012 at 1:40 pm

    #1563430

  • RE: Amount of data

    sqldummy79 (11/25/2012)

    I was wondering if there is a way to "trap" or track the amount of data (in bytes) that a select statement pulls when querying a table or tables....

    November 26, 2012 at 3:13 pm

    #1562442

  • RE: Days Difference Between 2 Dates

    archie flockhart (10/2/2012)

    "Interesting" behaviour:

    DECLARE @date datetime

    SET @date='2012-10-01 13:21:00'

    SELECT CAST(@date AS int)

    result: 41182

    SELECT CAST(CAST(@date AS float) AS int)

    result: 41181

    This occurs because casting DATETIME to INT rounds times...

    October 2, 2012 at 10:40 am

    #1544487

  • RE: Odd SQL conversion error "August 2012"

    Andrew-495157 (9/10/2012)

    Lynn wrote "You really don't get it, do you"

    In the UK this would be considered a provocative and rude statement. I will assume cultural differences apply here.

    Having used RBDMS...

    September 10, 2012 at 3:18 pm

    #1535937

  • RE: Odd behaviour from computed columns in a left outer join

    Kevin Dahl (8/29/2012)

    I have the following query:

    SELECT CE.ID ,

    CA.CustomerID,

    CA.PostalCode

    FROM DBXN.CommunicationEntry CE

    ...

    August 31, 2012 at 3:18 pm

    #1532649

  • RE: Create view with no outer joins

    patrickmcginnis59 (8/29/2012)

    The common situation seems to be that in this case, you don't surround the TABLE COLUMN NAME with date functions.

    ^^^ This is right.

    Comparing a column value to the...

    August 29, 2012 at 12:01 pm

    #1531548

  • RE: ##table question?

    SQL_path (8/24/2012)

    hello.

    here is the scenario:

    sp 1 inserts data in #table, #table is in sp2 and sp3

    sp 2 and sp3 are datasources for 2 report dataregions.

    sp 1-> sp2

    Sp 1->sp3

    both sp2...

    August 28, 2012 at 1:56 pm

    #1531062

  • RE: Create view with no outer joins

    Sean Lange (8/27/2012)

    Luis Cazares (8/27/2012)

    jdbrown239 (8/26/2012)

    Need to create view with no outer joins so I can index the view.

    I can't find a restriction for indexed views that involves outer...

    August 28, 2012 at 1:47 pm

    #1531056

  • RE: Landing The First SQL Job....

    I made a fairly radical career change at age 38, so I've been where you are now, OP. I knew I was seeking some kind of IT employment, but I...

    August 20, 2012 at 10:19 am

    #1527720

  • RE: Error Handling: TRY...CATCH

    5280_Lifestyle (8/13/2012)

    I'm trying to write an error handling query using the TRY...CATCH construct as a homework problem. I want to compare today's day to a variable @CurrentDay equal to a...

    August 20, 2012 at 9:40 am

    #1527696

  • RE: XML File Load via OpenRowSet

    IIRC, the SINGLE_BLOB option returns the data as single-row, single-column value of type varbinary(max), and when using OPENROWSET to import LOB data that exceeds 8,000 bytes in length, you have...

    August 20, 2012 at 9:17 am

    #1527683

Viewing 15 posts - 481 through 495 (of 567 total)