Forum Replies Created

Viewing 15 posts - 631 through 645 (of 761 total)

  • RE: How to create dynamic function

    poornipmca (4/25/2012)

    i have heard using indexes have lot of problems . is it so...........

    Wherever you heard that....but I am not talking about INDEXING.....I'm talking about maintaining a table as an...

    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] 😉

    April 25, 2012 at 3:09 am

    #1478789

  • RE: how to get latest last week dates from the given date

    I thought the OP wants the previous date for the "Latest" test date. The latest test date not only in this case but in all cases will be the top...

    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] 😉

    April 25, 2012 at 3:03 am

    #1478779

  • RE: get local variable value

    The values keep changing because of the JOIN itself. The values must be getting filtered further because of the JOIN with #table4.

    If you want all the data from the result...

    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] 😉

    April 25, 2012 at 2:53 am

    #1478768

  • RE: how to get latest last week dates from the given date

    Would this work?

    SELECT TOP 1 test_date

    FROM (

    SELECT DISTINCT TOP 2 test_date

    FROM datetest

    ORDER BY test_date DESC) a

    ORDER BY test_date

    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] 😉

    April 25, 2012 at 2:40 am

    #1478758

  • RE: Sequence numbering

    Sure does Dwain....:-)

    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] 😉

    April 25, 2012 at 2:21 am

    #1478749

  • RE: Sequence numbering

    +1 Dwayne....that sure is worth the +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] 😉

    April 25, 2012 at 1:31 am

    #1478729

  • RE: How to create dynamic function

    Why don't you keep an Index Table where you can store all the Customers and the names of the Databases of the respective Customers?

    Then you can create a Stored Procedure...

    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] 😉

    April 25, 2012 at 12:17 am

    #1478701

  • RE: stored procedure help

    These are the things I wanted it to do

    1. I wanted the old record in SMARTAdmissions table to be deleted as the upload process start

    2. then as data are added...

    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] 😉

    April 24, 2012 at 11:16 pm

    #1478691

  • RE: copying data one table to another table in sql

    vicdileo (4/24/2012)

    Hi asranantha,

    1) please supply the full CREATE TABLE sql (including table name) of both tables.

    2) how is the data being copied? Using SQL? Using a tool? Please...

    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] 😉

    April 24, 2012 at 10:58 pm

    #1478687

  • RE: What's a Reasonable Timeframe for a Cursor To Remain Open On SQL Server?

    Yes...thats right.

    No loops! No CURSORs! No RBAR! Hoo-uh! 😀

    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] 😉

    April 24, 2012 at 10:55 pm

    #1478686

  • RE: please give the solution for this

    MAAAAN!!!!...He really knows it all....lol 😀

    +1 SQLKnowItAll....I agree.

    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] 😉

    April 24, 2012 at 10:36 pm

    #1478683

  • RE: create defferent table for login

    Eugene Elutin (4/24/2012)

    vahid.arr (4/24/2012)

    i have userid pk and i want also make username and password field uniqe.how can i do that?

    You can create unique index (or unique constraint) on username....

    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] 😉

    April 24, 2012 at 10:35 pm

    #1478682

  • RE: txt import

    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] 😉

    April 24, 2012 at 10:26 pm

    #1478679

  • RE: Column = anything

    Yes. Seems like the only way to do "WHERE column = anything" is using a temporary variable ie: "WHERE column = @anything".

    Can't think of anything else until the OP clarifies...

    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] 😉

    April 24, 2012 at 10:18 pm

    #1478678

  • RE: Filtering rows from one table.

    Excellent Allen....it was as simple as that :laugh:

    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] 😉

    April 24, 2012 at 9:59 pm

    #1478676

Viewing 15 posts - 631 through 645 (of 761 total)