Forum Replies Created

Viewing 15 posts - 10,471 through 10,485 (of 15,381 total)

  • RE: update table with next value

    ronan.healy (10/5/2012)

    thanks very much for help will try that

    and also will try improve my [post in future

    again thanks

    No problem. Happy to help. The best thing you can do is to...

    October 5, 2012 at 9:48 am

    #1546181

  • RE: update table with next value

    Just to help you with future posts, if you post your data in a nice and clean consumable format it will go a long way.

    CREATE TABLE dbo.IRBT

    (

    MOODYSRATE CHAR(10) NOT...

    October 5, 2012 at 9:41 am

    #1546177

  • RE: Connect 64bit To 32bit Through ODBC, SQL Server 2008

    54.69.6d.20 (10/5/2012)

    Sean Lange (10/5/2012)

    Since you mentioned this is a webserver, did you add an exception to this machine for the ports that sql is using (default 1433)? I am guessing...

    October 5, 2012 at 9:24 am

    #1546168

  • RE: update table with next value

    ronan.healy (10/5/2012)

    hi

    i think i just put them in to quick to get a reply.

    they are odrered on the number from the irbt table.

    so 2- 25 in that oder

    2

    3

    4

    5 etc

    So you...

    October 5, 2012 at 9:16 am

    #1546163

  • RE: Connect 64bit To 32bit Through ODBC, SQL Server 2008

    Since you mentioned this is a webserver, did you add an exception to this machine for the ports that sql is using (default 1433)? I am guessing that your new...

    October 5, 2012 at 9:14 am

    #1546161

  • RE: update table with next value

    ronan.healy (10/5/2012)

    well there will be alot more rows in my table some will have negwatch some wont so what i need to do is update the MIDIRB rows in the...

    October 5, 2012 at 9:07 am

    #1546157

  • RE: Connect 64bit To 32bit Through ODBC, SQL Server 2008

    54.69.6d.20 (10/5/2012)

    Sean Lange (10/5/2012)

    54.69.6d.20 (10/5/2012)

    I'm trying to connect my new Windows 2011 SBS 64 bit server to my Windows 2008 SBS 32 bit server, through an ODBC connection

    I kind of...

    October 5, 2012 at 9:04 am

    #1546154

  • RE: update table with next value

    No problem.

    So the ddl for ACRT should look like this?

    CREATE TABLE ACRT

    (

    CNO CHAR(100) NOT NULL,

    OPICSCNO CHAR(100) NULL,

    MOODYSRATE CHAR(10) NOT NULL,

    SNPRATE CHAR(10) NOT NULL,

    FITCHRATE CHAR(10) NOT NULL,

    MOODYSIRB NUMERIC(4) NULL,

    SPIRB NUMERIC(4)...

    October 5, 2012 at 8:59 am

    #1546149

  • RE: Merging rows

    prady_1988 (10/5/2012)

    Sean Lange (10/5/2012)

    Still nothing to test with but I think this might be close to what you want...

    select A, b, MAX(C), MAX(D), MAX(E), MAX(F), g

    from

    (

    SELECT distinct

    BASE1.AssetID AS a

    ,BASE1.Name As...

    October 5, 2012 at 8:56 am

    #1546145

  • RE: update table with next value

    ronan.healy (10/5/2012)

    sorry put in the older version of table

    CNO ...

    October 5, 2012 at 8:51 am

    #1546140

  • RE: Connect 64bit To 32bit Through ODBC, SQL Server 2008

    54.69.6d.20 (10/5/2012)

    I'm trying to connect my new Windows 2011 SBS 64 bit server to my Windows 2008 SBS 32 bit server, through an ODBC connection

    I kind of figured that...what is...

    October 5, 2012 at 8:49 am

    #1546138

  • RE: update table with next value

    Well the inserts have incorrect string delimiters for sql. When I changed the " to ' I can't insert to ACRT, the insert doesn't match the table definition.

    so what im...

    October 5, 2012 at 8:46 am

    #1546137

  • RE: Database to hold/keep scripts.

    ben.brugman (10/5/2012)

    bitbucket-25253 (10/5/2012)

    I have what I call a sandbox DB to hold scripts, some T-SQL and have it set up so as to be able to search by key words,...

    October 5, 2012 at 8:16 am

    #1546116

  • RE: update table with next value

    ronan.healy (10/5/2012)

    hi i have 2 tables

    in 1 i have the following

    rateN1 rateN2 rateN3 rate

    a aa aaa 1

    b bb bbb 2

    c cc ccc 4

    d dd ddd 6

    table 2 has the...

    October 5, 2012 at 8:13 am

    #1546113

  • RE: Connect 64bit To 32bit Through ODBC, SQL Server 2008

    54.69.6d.20 (10/5/2012)

    Sean Lange (10/5/2012)

    54.69.6d.20 (10/5/2012)

    I just setup a new Win2011 64bit SBS server which is now hosting our website (Was on an old 2003 server, where 2008 SQL was hosted...

    October 5, 2012 at 8:09 am

    #1546107

Viewing 15 posts - 10,471 through 10,485 (of 15,381 total)