Forum Replies Created

Viewing 15 posts - 256 through 270 (of 7,164 total)

  • RE: import data from an excel to sql server

    georgheretis (2/12/2016)

    hi

    i am import an Excel to a SQL Server ( using DB>TASKS>IMPORT DTA ...) and so on

    i am creating an NEW table called 'aaa' from the Excel

    the problem is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 13, 2016 at 7:52 am

    #1858579

  • RE: import data from an excel to sql server

    Brandie Tarvin (2/12/2016)

    Because ... Excel .... SUCKS ... that way. :pinch:

    I would say it as "because integrating with Excel sucks that way." It is not technically Excel that sucks, it...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 13, 2016 at 7:49 am

    #1858577

  • RE: Date difff from two dates divide by count

    can there be different dates on different rows with the same claim number?

    how about some schema and sample data code?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 13, 2016 at 7:39 am

    #1858573

  • RE: bcp_init error

    Note original thread is over 11 years old.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 13, 2016 at 7:29 am

    #1858571

  • RE: Date difff from two dates divide by count

    what happens if john has more claims with andifferent claim number?

    as an aside, it is better to post CREATE TABLE and INSERT statements when asking for help so folks wanting...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 13, 2016 at 7:26 am

    #1858570

  • RE: DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    scotdg (2/12/2016)

    I guess I didn't see how it helped because I had already made sure that the system account login in SQL server has access to the database.

    Just to clarify,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 12, 2016 at 8:51 pm

    #1858554

  • RE: DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    Phil Parkin (2/12/2016)

    As far as I know (despite what you mentioned in an earlier post), those Creator properties are purely informational.

    That is my understanding as well.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 12, 2016 at 8:45 pm

    #1858553

  • RE: How to concatenate / present this data

    You can achieve the same result using FOR XML but I prefer the way you can write the query using the GROUP_CONCAT approach. I am biased though, I wrote the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 12, 2016 at 7:58 am

    #1858360

  • RE: Improving Performance

    Sergiy (2/11/2016)

    Orlando Colamatteo (2/11/2016)

    Sergiy (2/11/2016)

    Hugo Kornelis (2/11/2016)

    A pretty dangerous thing to do, and an incredibly irresponsible advice to put out on forums.

    Believe me, unfortunately - it's not.

    Those who know what...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 11, 2016 at 11:03 pm

    #1858242

  • RE: Landing SQL/database gig

    Welcome, to the site and to the SQL Server community.

    Microsoft SQL Server certifications are a great way to get ramped up as the content covers the entire data platform. Studying...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 11, 2016 at 10:06 pm

    #1858239

  • RE: Stored Procedure Performance

    Number 1, read everything Kevin said. Re-read it and ask questions if needed.

    Now let's break down the next steps:

    1. What program or process is calling this proc? It is important...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 11, 2016 at 9:45 pm

    #1858237

  • RE: Improving Performance

    Sergiy (2/11/2016)

    Hugo Kornelis (2/11/2016)

    A pretty dangerous thing to do, and an incredibly irresponsible advice to put out on forums.

    Believe me, unfortunately - it's not.

    Those who know what their data types...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 11, 2016 at 9:36 pm

    #1858236

  • RE: t-sql 2012 convert and cast issue

    wendy elizabeth (2/11/2016)

    I have the following t-sql 2012, which is the following:

    DECLARE @endYear varchar(04) = 2016

    select convert(smalldatetime, ('07/31/' + convert(char(02), @endYear - 1)))

    select convert(smalldatetime, '08/01/' + @endYear )

    that is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 11, 2016 at 9:12 pm

    #1858235

  • RE: Check if date ranges overlap

    Posting back to a similar problem/topic:

    http://www.sqlservercentral.com/Forums/Topic1760478-3412-1.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 11, 2016 at 8:30 pm

    #1858233

  • RE: DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    I have had that happen a couple times. i think it is a bug in this site.

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

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 11, 2016 at 6:03 pm

    #1858224

Viewing 15 posts - 256 through 270 (of 7,164 total)