Forum Replies Created

Viewing 15 posts - 4,621 through 4,635 (of 8,731 total)

  • RE: Running Sum with Reset Option & SQL BULK update

    I'm seriously impressed.

    Not only you managed to get things done by reading the article, understanding it and adapt it to your needs, you also took the time to read...

    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

    July 23, 2015 at 7:32 am

    #1814362

  • RE: Select queries with a join sometimes fail on some remote PC's

    Brandie Tarvin (7/23/2015)

    Luis Cazares (7/22/2015)

    Have you read this?

    https://support.microsoft.com/en-us/kb/942861

    Luis, I keep forgetting about that damn chimney. It can cause issues, can't it?

    I haven't encountered this problem, but it came out from...

    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

    July 23, 2015 at 7:22 am

    #1814359

  • RE: SQL to determine if a non-attendance is a “DROPOUT”

    j-1064772 (7/22/2015)

    Was this really in the books on line ?

    There's not much detail on this in BOL. There's a paragraph with an example in the Limitations and Restrictions...

    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

    July 22, 2015 at 2:20 pm

    #1814226

  • RE: Is there a way to find out what data was changed by a stored proc after it was executed?

    If absolutely necessary, I'm not sure if a point in time restore could help to get the data before the execution of the stored procedure.

    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

    July 22, 2015 at 1:40 pm

    #1814213

  • RE: ??? on Pivot

    You could use cross tabs to create by creating a row number for each team.

    WITH CTE AS(

    SELECT Client_Teams.Parent, Teams.Name,

    ...

    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

    July 22, 2015 at 1:38 pm

    #1814211

  • RE: Why does SQL Server consider a value to be a column name??

    Because it needs single quotes to identify strings. Most (or all) languages need quotes to identify strings, so there shouldn't be a big surprise. Without quotes, there would be no...

    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

    July 22, 2015 at 1:19 pm

    #1814203

  • RE: Query Execution plan too long

    Have you tried a 3rd party tool like SQL Sentry?

    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

    July 22, 2015 at 12:46 pm

    #1814191

  • RE: SQL to determine if a non-attendance is a “DROPOUT”

    That's one of the great things of CTEs. When you update a CTE, you're actually updating the underlying tables. This is not restricted to updates, you can insert and delete...

    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

    July 22, 2015 at 12:26 pm

    #1814184

  • RE: How to split data from two columns in one table into multiple columns of a result table

    ameen.yousuf88 (7/22/2015)

    hmm tried this approach but kept on getting an error.....

    I however was able to solve the problem. I used Left Outer Join instead of Inner Join and moved the...

    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

    July 22, 2015 at 11:12 am

    #1814167

  • RE: Increase ecessivo tempdb

    rmedeiros (7/22/2015)

    Luiz thanks for the return, I'm looking for help on the forums, I'm not picking up random script, I have many databases with a total data 7TB can not...

    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

    July 22, 2015 at 9:43 am

    #1814150

  • RE: Why don't these two queries return the same number of records?

    To find duplicates use this code.

    SELECT phd_user_id

    FROM PHD_USER

    GROUP BY phd_user_id

    HAVING COUNT(*) > 1

    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

    July 22, 2015 at 9:03 am

    #1814134

  • RE: Query with three tables

    Something like this?

    SELECT [Group],

    MAX( Info1) AS Info1,

    MAX( Info2) AS Info2,

    MAX( Info3) AS Info3

    FROM(

    ...

    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

    July 22, 2015 at 8:36 am

    #1814128

  • RE: How to split data from two columns in one table into multiple columns of a result table

    You should not store your values as shown on the result of the query. That goes against normalization and will give you problems when you need to add a different...

    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

    July 22, 2015 at 8:28 am

    #1814127

  • RE: How to split data from two columns in one table into multiple columns of a result table

    Why do you have repeated values on Table_Two? That would only create a great amount of rows when creating the queries.

    A better way to do this is by using a...

    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

    July 22, 2015 at 8:24 am

    #1814125

  • RE: export data from sql server to excel

    If you have a .bak file, you need to restore the file into a database, as you only have a backup file.

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

    After restoring your database, you need to define what...

    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

    July 22, 2015 at 7:57 am

    #1814117

Viewing 15 posts - 4,621 through 4,635 (of 8,731 total)