Forum Replies Created

Viewing 15 posts - 466 through 480 (of 761 total)

  • RE: TYpes of formatting and conversion functions

    Divine Flame (5/9/2012)

    ramrajan (5/8/2012)

    asa

    I think he wanted to write asap, but before writing "p" he got something even more important to do 😀

    :-D:hehe:

    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 3:58 am

    #1484951

  • RE: Replace the Linked server

    Divine Flame (5/9/2012)

    Sony Francis @EY (5/9/2012)

    Our company has used Linked server to get the other db server data . Now we are trying to replace the linked server with SSIS...

    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 3:54 am

    #1484949

  • RE: TYpes of formatting and conversion functions

    ramrajan (5/8/2012)

    asa

    ASA :-P:-D

    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 3:27 am

    #1484946

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

    Jeff Moden (5/8/2012)

    Do you really mean that all you want to see is things that have other than 0-9 or A-Z or embedded spaces in them?

    If so, you can use...

    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 3:15 am

    #1484940

  • RE: Updating multiple values from 1 table to another

    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 2:56 am

    #1484936

  • RE: avg max salary

    Please provide DDL of the table and some readily consumable Sample Data to go with it so that people can understand your requirement a little better.

    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 1:08 am

    #1484901

  • RE: Is the following possible

    kirkm 55368 (5/8/2012)

    Hi Vinu

    I will certainly do so, and update with better if I can.

    Try it and you'll see that the people on this Forum are so freakin' smart that...

    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 1:03 am

    #1484898

  • RE: connect two different tables

    I haven't worked with SAP enough to tell you about Joining tables from SQL server with SAP tables. But you can import data from SAP into SQL Server USING SSMS...

    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 12:58 am

    #1484897

  • RE: How to delete temp log information

    Suresh B. (5/8/2012)

    What is "temporary log information"?

    Never heard of it.

    Please use universal Names. Search Google what you are looking for, find what it is Universally called and then post.

    Otherwise,...

    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 12:07 am

    #1484879

  • RE: Difference between seek and scan?

    Suresh B. (5/8/2012)

    differences between seek and scan in sql server

    Thanks for the link Suresh. It was very INFORMATIVE. :-D:hehe::-D:hehe:

    Btw Sudha,

    Index Scan: Index scan scans all rows of the table...

    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 12:05 am

    #1484878

  • RE: What is the use of 'internal' in SSRS

    sudha.kotapati (5/8/2012)

    Hi,

    When ever we are using report parameters(SSRS),we find the 3 options

    1.visible parameter

    ...

    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 8, 2012 at 11:58 pm

    #1484874

  • RE: case statement

    thinesh.mscss (5/8/2012)

    SELECE FIELD1,FIELD2

    FROM TABLENAME

    GROUP BY FIELD1,FIELD2;

    THIS MIGHT WORK

    Have you tried this??

    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 8, 2012 at 11:37 pm

    #1484871

  • RE: Is the following possible

    kirkm 55368 (5/8/2012)

    But for the next part, tblAAA, tblBBB, tblCCC all have a Prefix field (which is contained in qryUC.Serial)

    I want to include data from some fields in those into...

    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 8, 2012 at 11:23 pm

    #1484869

  • RE: Conditional select with function

    toddasd (5/8/2012)

    Your table DDL and insert statements columns don't match, but it looks like you simply need something like this in the WHERE clause:

    WHERE (origin_code = @origin_code OR origin_code =...

    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 8, 2012 at 10:58 pm

    #1484861

  • RE: Conditional select with function

    drew.allen (5/8/2012)

    If you have enough units of measure, you'll probably want to create a conversion table instead of using the CASE Statement.

    Drew

    I agree with Drew.

    Since you have got some time...

    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 8, 2012 at 10:44 pm

    #1484858

Viewing 15 posts - 466 through 480 (of 761 total)