Forum Replies Created

Viewing 15 posts - 391 through 405 (of 1,228 total)

  • RE: Get last row based on duplicate column

    This has already been answered but it's interesting that the logical requirement exactly matches an existing function which isn't used in any of the solutions offered. What you're looking for...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 28, 2012 at 2:57 am

    #1553525

  • RE: Split without delimiter based on position

    yuvipoy (10/22/2012)

    Ok, thanks. Can you give an example of how the data from this output table would be used please?

    ChrisM as i have said i am having some business logic's...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 22, 2012 at 7:04 am

    #1551356

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (10/22/2012)

    ChrisM@home (10/22/2012)

    L' Eomot Inversé (10/22/2012)

    Stefan Krzywicki (10/22/2012)

    Brandie Tarvin (10/22/2012)

    [font="Comic Sans MS"]The PI! It needs more slices![/font]

    You know what I hate about pie charts?

    You can never tell what...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 22, 2012 at 6:46 am

    #1551351

  • RE: Split without delimiter based on position

    yuvipoy (10/22/2012)

    Ok, after you have done 2) insert into a table, what uses the table? A report, perhaps?

    NO This is not a report one i need to join some tables...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 22, 2012 at 6:39 am

    #1551345

  • RE: How to convert the integer value to datetime

    sanjay.dakolia (10/22/2012)

    this value was suppose to be datetime but by mistake the column datatype was given integer so now i want to convert it back to datetime

    What date does 1157068800...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 22, 2012 at 6:30 am

    #1551338

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (10/22/2012)

    Stefan Krzywicki (10/22/2012)

    Brandie Tarvin (10/22/2012)

    [font="Comic Sans MS"]The PI! It needs more slices![/font]

    You know what I hate about pie charts?

    You can never tell what filling they're using....

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 22, 2012 at 6:28 am

    #1551337

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/22/2012)

    Brandie Tarvin (10/22/2012)

    [font="Comic Sans MS"]The PI! It needs more slices![/font]

    You know what I hate about pie charts?

    You can never tell what filling they're using. And it's awfully...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 22, 2012 at 6:25 am

    #1551336

  • RE: Split without delimiter based on position

    yuvipoy (10/22/2012)

    The string splitting would ideally be in the stored procedure, so you would have parameters @str and @pos for the stored procedure.

    Where do @str and @pos come from?

    What will...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 22, 2012 at 6:23 am

    #1551333

  • RE: here i just want update the indexnumber of a question table after deleting some question from that table ?

    -- sample data setup

    DECLARE @question table

    (

    questionid int identity(1,1),

    questionbank uniqueidentifier,

    indexnumber int,

    question varchar(20),

    crdate datetime

    )

    insert into @question

    select 'B7152F93-45CE-4485-9672-7E0E5F62F775',1,'q1',GETDATE() union all

    select 'B7152F93-45CE-4485-9672-7E0E5F62F775',2,'q2',GETDATE() union all

    select 'B7152F93-45CE-4485-9672-7E0E5F62F775',3,'q3',GETDATE() union...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 22, 2012 at 6:21 am

    #1551330

  • RE: Split without delimiter based on position

    yuvipoy (10/22/2012)

    create procedure @str varchar(1000),@param int

    as

    begin

    .

    .

    i am having values in splitter table so there is no need of @pos here we can directly take the value from...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 22, 2012 at 6:10 am

    #1551324

  • RE: Split without delimiter based on position

    yuvipoy (10/22/2012)

    We know all of this already. What can you tell us about

    1. The process which generates these two strings - where do they come from?

    2. How the data is...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 22, 2012 at 5:08 am

    #1551305

  • RE: Split without delimiter based on position

    yuvipoy (10/22/2012)

    Starting from my first post i will cont.. here...

    We know all of this already. What can you tell us about

    1. The process which generates these two strings - where...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 22, 2012 at 4:33 am

    #1551293

  • RE: Split without delimiter based on position

    yuvipoy (10/22/2012)

    @pos may increase or decrease if it increase i need to create my testtable accordingly ,here it is 6 splits so i am having 6 columns later i may...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 22, 2012 at 3:20 am

    #1551280

  • RE: Split without delimiter based on position

    yuvipoy (10/18/2012)

    hey it has worked thanks

    now the thing is i need to insert this data into a table

    my table is

    create testtable (Rid int identity(1,1),col1 int,col2 int,col3 int,col4 int,col5 int,col6 int)

    i...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 22, 2012 at 3:18 am

    #1551279

  • RE: Are the posted questions getting worse?

    dwain.c (10/19/2012)

    Soon I shall be logging out of SSC for a week of much needed R&R. I know you'll miss me. 😀

    Have a splendid holiday Mr C - you've...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    October 19, 2012 at 6:31 am

    #1550832

Viewing 15 posts - 391 through 405 (of 1,228 total)