Forum Replies Created

Viewing 15 posts - 451 through 465 (of 761 total)

  • RE: Run Procedure with breaks in between

    vinu512 (5/10/2012)

    Thank you very much.

    Seems like "WaitForDelay" was what I was looking for.

    Uhhm....guys...this may be asking for too much..... :crazy:

    But, can send "some kind of a response" to the client...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 11, 2012 at 5:15 am

    #1486198

  • RE: Updating multiple values from 1 table to another

    dwain.c (5/11/2012)

    Vinus - I think there's a simpler solution with no need for dynamic SQL in the trigger.

    --drop table temptable

    Create Table temptable (id int not null primary key, val1...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 11, 2012 at 2:58 am

    #1486164

  • RE: need help with duplicate records in a table

    These are the queries based on your requirements:

    --Creating Table

    Create Table Ex

    (RecNum Int,

    Patient_ID int,

    Patient_FirstName varchar(10),

    Emp_ID int,

    Emp_FirstName varchar(10),

    App_Datetime DateTime )

    --Inserting Sample Data

    Insert Into Ex

    Select 1, 1234,...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 11, 2012 at 1:56 am

    #1486142

  • RE: query

    anthony.green (5/11/2012)

    this will do the job with the sample data provided, but if you dont know the logic then we can only guess at what you want and how it...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 11, 2012 at 1:31 am

    #1486128

  • RE: query

    sachince61 (5/11/2012)

    I have a table with two column

    out put date is like this...

    mnemonicId customerID

    1402 140201

    1402 ...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 11, 2012 at 1:18 am

    #1486122

  • RE: TYpes of formatting and conversion functions

    ACinKC (5/10/2012)

    Mebbe he was sitting in an interview for a DBA position and had to post to SSC quickly to get the answer...someone walked in just as he was about...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 11, 2012 at 12:37 am

    #1486111

  • RE: Finding rows with wildcards in the string and rows with spaces in front or at the end of the string.

    Jeff Moden (5/10/2012)

    You're welcome. Take a look at one of the many uses for it in the following article...

    http://www.sqlservercentral.com/articles/IsNumeric/71512/

    Thanx Jeff. The link was very useful.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 11, 2012 at 12:35 am

    #1486109

  • RE: Updating multiple values from 1 table to another

    Is this better Swan?

    --Creating Tables

    Create Table Ex

    (id int not null primary key Identity(1,1), -----=====Identity Column is required for...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 11, 2012 at 12:08 am

    #1486104

  • RE: Need help to write query for the mentioned scenario in SQL Server 2008

    This will do it:

    --Creating Table

    Create Table Ex

    (IDint,

    FileCount int,

    FileSize int,

    Country char(1) )

    --Inserting Sample Data

    Insert Into Ex

    Select 1,2,150,'X'

    Union ALL

    Select 2,9,500,'A'

    Union ALL

    Select 2,2,100,'B'

    Union ALL

    Select 2,3,200,'C'

    Union ALL

    Select 2,1,50,'D'

    Union ALL

    Select 3,10,800,'P'

    Union...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 10, 2012 at 6:50 am

    #1485662

  • RE: case statement

    This might work:

    select

    Count(case when void = 0 then count(ID) Else NULL end) as Countofsuccess,

    Count(case when void = 1 then count (ID) Else NULL end) as countoffailure

    from test

    If you are...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 10, 2012 at 5:41 am

    #1485623

  • RE: Run Procedure with breaks in between

    Thank you very much.

    Seems like "WaitForDelay" was what I was looking for.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 10, 2012 at 3:48 am

    #1485561

  • RE: Difference between seek and scan?

    sudha.kotapati (5/9/2012)

    Thank you very much

    You're welcome. 🙂

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 9, 2012 at 11:17 pm

    #1485456

  • RE: Updating multiple values from 1 table to another

    Sean Lange (5/9/2012)

    vinu512 (5/9/2012)

    Are you implying that you need a Trigger?

    here is something that I worked up. Hope it helps:

    --Creating Tables

    Create Table Ex

    (id int not null primary key Identity(1,1), ...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 9, 2012 at 11:15 pm

    #1485454

  • RE: Conditional select with function

    drew.allen (5/9/2012)

    vinu512 (5/8/2012)

    Todd's Logic is very nice. Didn't hit me when I was trying it.

    But it was just lacking something.

    I tweaked it a little and got it working. 😀 Here's...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 9, 2012 at 10:41 pm

    #1485449

  • RE: Finding rows with wildcards in the string and rows with spaces in front or at the end of the string.

    OK Jeff.

    I was expecting it to work the other way round. It can be really useful. 😛

    Thanks 😎

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    May 9, 2012 at 10:10 pm

    #1485445

Viewing 15 posts - 451 through 465 (of 761 total)