Forum Replies Created

Viewing 15 posts - 451 through 465 (of 626 total)

  • RE: More wildcard searches

    Oh well, guess I'll just take my point for posting here instead. 😉

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 28, 2015 at 7:38 am

    #1836043

  • RE: Summarising transaction data removing nulls

    Luis Cazares (10/27/2015)

    yb751 (10/27/2015)

    Awesome solution Luis, I'm going to keep this one for a rainy day. Just curious why you created a @date_serial variable. Is it needed?

    Yes, it's...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 27, 2015 at 2:17 pm

    #1835898

  • RE: Summarising transaction data removing nulls

    Luis Cazares (10/27/2015)

    This looks very similar to a running total problem (except that there's no total). This can be managed by the quirky update, a cursor or a triangular join....

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 27, 2015 at 1:47 pm

    #1835890

  • RE: beginner row to column ?

    Your question isn't very clear. I'll take a stab at it but I can't be sure its what you are looking for. At the very least maybe I...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 27, 2015 at 8:13 am

    #1835798

  • RE: Merging Data from two source into one destination table

    Just though I should add that you can also use INTO in a UNION statement to load the data into a new table. Just be aware that only the...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 7, 2015 at 8:24 am

    #1832015

  • RE: IDENT_SEED to Find the Seed?

    Well wasn't the original seed value 1?

    IDENT_SEED

    https://msdn.microsoft.com/en-CA/library/ms189834.aspx

    Returns the original seed value (returned as numeric(@@MAXPRECISION,0)) that was specified when an identity column in a table or a view was created.

    DBCC CHECKIDENT

    https://msdn.microsoft.com/en-us/library/ms176057.aspx

    Checks...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 5, 2015 at 12:31 pm

    #1831502

  • RE: Partitioning Table Strategie

    GilaMonster (10/5/2015)

    yb751 (10/5/2015)

    The upcoming 'Stretch Database' feature in SQL 2016 may be exactly what you are looking for.

    With poor queries, that'll just make matters worse. If the queries can't...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 5, 2015 at 9:57 am

    #1831447

  • RE: Partitioning Table Strategie

    The upcoming 'Stretch Database' feature in SQL 2016 may be exactly what you are looking for. I know this doesn't help you at the moment but it might be...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 5, 2015 at 8:55 am

    #1831417

  • RE: Spam Spam Bacon and Spam

    Lowell (10/5/2015)

    agreed. they added code that insta-deletes anything Celko posts(thank you for that!), so they can reuse that same code, and just add something that detects the new user spamming...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 5, 2015 at 8:40 am

    #1831409

  • RE: Distinct Statement

    No problem, I also noticed a potential problem with your string concatenation.

    CA.house_num + ' ' + CA.street_name + ' ' + CA.apt_num AS [MailingStreet]

    If there is any chance that...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 1, 2015 at 11:56 am

    #1830863

  • RE: Distinct Statement

    DISTINCT applies to the whole result set not just for that one column. Just remove 'application_id' from the select statement and see what you get. That being said...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 1, 2015 at 11:36 am

    #1830854

  • RE: Pivot, NestedPivot, unPivot?

    Absolutely, there is a great write up here: http://www.sqlservercentral.com/articles/Best+Practices/61537/

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 24, 2015 at 9:26 am

    #1829184

  • RE: Pivot, NestedPivot, unPivot?

    You should try to provide a test table which will help you get help much faster.

    Like this:

    DECLARE @Milestonetable TABLE (JobNo INT, MileStoneName CHAR(1), ForecastDate DATE, ActualDate DATE, StatusFlag CHAR(1))

    INSERT INTO...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 24, 2015 at 8:58 am

    #1829167

  • RE: Dynamic SQL Question

    This remind me of the old saying.

    "If Your Only Tool Is a Hammer Then Every Problem Looks Like a Nail".

    Always use the right tool for the job and...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 18, 2015 at 7:41 am

    #1827737

  • RE: SQL help please

    A simple CASE statement can 'beautify' the Data Type but just be mindful you'd have to account for quite a few different types.

    Here is an example of a few:

    USE AdventureWorks2012

    SELECT...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    September 14, 2015 at 2:17 pm

    #1826549

Viewing 15 posts - 451 through 465 (of 626 total)