Forum Replies Created

Viewing 15 posts - 1,066 through 1,080 (of 8,731 total)

  • RE: Changing type from INT to BIGINT why so slow?

    leehbi - Monday, July 31, 2017 8:17 AM

    I was hoping SQL Server 2016 could handle change in types.
    With this table of numbers...

    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 31, 2017 at 8:53 am

    #1953396

  • RE: Numbering a group

    This option might help avoid a triangular join.

    WITH CTE AS(
      Select *,
       ROW_NUMBER() OVER( ORDER BY MonthStart) -
       ROW_NUMBER() OVER( PARTITION...

    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 31, 2017 at 8:48 am

    #1953391

  • RE: The Floor

    Or we could simply just use ROUND() to get the correct result.

    WITH mycte (a, n)
    AS (SELECT a, n
      FROM ( VALUES
          ('Coffee', 2.38),

    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 31, 2017 at 6:12 am

    #1953355

  • RE: store procedure running problem

    polo.csit - Thursday, July 27, 2017 7:40 AM

    Hi All,

                 when we insert some data into table then...

    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 27, 2017 at 8:08 am

    #1953028

  • RE: Image string select in sql server table

    polo.csit - Thursday, July 27, 2017 7:31 AM

    create table data(id int,name nvarchar(max))

    declare @id int,@name nvarchar(max)

    set @id =1
    set @name='abcd'(some images)

    insert into data(id,name)
    values(@id,@name)

    here insert 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

    July 27, 2017 at 7:43 am

    #1953021

  • RE: Accidentally updated all records

    newdba2017 - Thursday, July 27, 2017 7:28 AM

    I have a small table in Dev (contains 38 rows) and I ran an update...

    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 27, 2017 at 7:37 am

    #1953019

  • RE: Image string select in sql server table

    Luis Cazares - Thursday, July 27, 2017 5:40 AM

    Can you post your sample data as insert statements?

    Well, you haven't posted...

    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 27, 2017 at 6:28 am

    #1952997

  • RE: Who's Smarter? Humans or AI Systems?

    I just hope that Artificial Intelligence used in driving cars keeps moving forward fast enough to remove all the Natural Non-intelligent beings from controlling their cars on the road.

    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 27, 2017 at 6:24 am

    #1952995

  • RE: Image string select in sql server table

    polo.csit - Thursday, July 27, 2017 4:36 AM

    Hi All,

              my tbale have a 150000 records i this records...

    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 27, 2017 at 5:40 am

    #1952986

  • RE: Dynamic SQL Query Not Fetching Records based on where Not In condition

    And I forgot, be sure to test for NULLs functionality
    EXEC [dbo].[UDPR_employeeview] '1,NULL'

    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 26, 2017 at 12:50 pm

    #1952887

  • RE: Dynamic SQL Query Not Fetching Records based on where Not In condition

    sunilchand1234 - Wednesday, July 26, 2017 6:40 AM

    How ?? can you tell us more about SQL Injection in more details using...

    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 26, 2017 at 12:45 pm

    #1952885

  • RE: Syntax errors

    Sree Divya - Tuesday, July 25, 2017 1:03 PM

    Hi,

    i am trying to execute below command but output is not getting .In my...

    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 25, 2017 at 1:07 pm

    #1952664

  • RE: two decimal points issue

    joanna.seldon - Tuesday, July 25, 2017 2:12 AM

    Hi

    I keep having error about does not support data type DT_R8

    I have tried to go...

    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 25, 2017 at 5:33 am

    #1952527

  • RE: Save default values for textbox

    TexasJohn - Monday, July 24, 2017 9:22 AM

    Is it possible in MS Visual Studio to change and save the default values for...

    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 24, 2017 at 12:06 pm

    #1952440

  • RE: Change Null value to 0 in Dynamic pivoted query

    mjohnson 71479 - Monday, July 24, 2017 10:15 AM

    Thank You!!

    You're welcome.
    Do you understand how this works?

    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 24, 2017 at 11:56 am

    #1952438

Viewing 15 posts - 1,066 through 1,080 (of 8,731 total)