Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Kurniadi
  • Order by date
  1. Kurniadi

    Merging records with the same company name

    Hi Fred.. I think you can do it with the processing of record one by one from two tables. You can use @@FETCH_STATUS. Thank's Kurniadi
  2. Kurniadi

    SQL Server Problems with connecting

    Hi svagelis... Please you try, 1. Check it your Local Server Name. It have to same with your Computer Name (Lower and Upper Letter). 2. Check it too, connection, username, psw, protocol(named pipes, tcp/ip, multiprotocol) 3. If this solution still problem, disable (not active) all off sql...
  3. Kurniadi

    Hello, I need help with a SELECT

    Hi Lftsk, Your output may be like this : RecType col1 col2 col3 ------- ------- -------- -------- A 100 200 400 B 100 200 500 C 100 200 600 D 100 200 700 You can try to...
  4. Kurniadi

    Hello, I need help with a SELECT

    Hi Lftsk... I don't understand your means. Can you tell me with output that you want ? Thank's Kurniadi
  5. Kurniadi

    select last 20 records

    Hi brownfox... Try... SELECT TOP 20 * FROM tblWhatever ORDER BY field DESC
  6. Kurniadi

    joining tables, then joining to another database

    Hi boopers... To do the crossing database, it's no problem. Don't forget, you must write database name. Like this : SELECT database1.table.* from database1.table INNER JOIN database2.table ON database1.table.field = database2.table.field Thank's. Kurniadi
  7. Kurniadi

    Add data from a database to other

    Hi marcial4... You can use SQL Server Enterprise Manager - Tools - DTS - Import or Export Data. Thank's. Kurniadi
  8. Kurniadi

    joining tables, then joining to another database

    Hi boopers... I don't know, your mean "Combining". But I think, you can to joining for All Tables (visit,visitapptlist,casemain) with JOIN on one SQL query syntaxt. Thank's. Kurniadi
  9. Kurniadi

    Converting int to hh:mm:ss format

    Hi... Or may be you can try like this... Select TimeValue = Substring(str(IntColumn,6),1,2)+ Substring(stuff(str(IntColumn,6),1,2,':'),1,3)+ Substring(stuff(str(IntColumn,6),1,4,':'),1,3) don't forget to use STR(IntColumn, 6) ! -> hh:mm:ss
  10. Kurniadi

    service pack

    Hi element19... You can browse : http://www.microsoft.com/downloads/results.aspx?productID=261BA873-F3AB-420E-96D6-E3004596A551&freetext=SP&DisplayLang=en Kurniadi, Indonesia
  11. Kurniadi

    Converting int to hh:mm:ss format

    Hi, juniordba... The important, please use STUFF Function.
  12. Kurniadi

    Insert Current Date into SQL

    Hi Pamy... Sorry, please use 101 or 102.
  13. Kurniadi

    Insert Current Date into SQL

    Hi... Shouldn't use DATETIME, but please use VARCHAR(10), in SQL Server is no problem. And the important, please look at Regional Setting, change the SHORT DATE STYLE to dd/mm/yyyy or mm/dd/yyyy and please use 101 or 103 for anticipate SHORT DATE STYLE. For the current date, please use...
  14. Kurniadi

    Insert Current Date into SQL

    You can use the logical like this... DateSubmitted = CONVERT(varchar(10),Current_Timestamp, 103) or you can use CAST. Please open "SQL Server Books Online" with the topic "CONVERT" Kurniadi, Indonesia

Part and Inventory Search

Back
Top