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!

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

Recent content by VIJSQL01

  1. VIJSQL01

    Need help in writing Concatenation query

    Awesome! it worked. Thanks a ton for rocket speed response.
  2. VIJSQL01

    Need help in writing Concatenation query

    Hi, I am trying to execute a select query, that will have concatenation of four columns. I am not just interested in concatenating, but also interested in inserting a constant values between these concatenations. Also i want to have a word in between, which is again concatenated. [highlight...
  3. VIJSQL01

    Need to test table partitioning & index creation

    Thank you very much for the reply. Here i need to perform feasibility testing to verify that, whether the expected partitioning and indexing of the tables are done properly or not.
  4. VIJSQL01

    Need to test table partitioning & index creation

    Hello, I have been assigned to test partitioning and index creation for tables created in SQL Server environment. I do not know the approach. If possible i would like to automate this process. Can anybody throw some light on this? Thanks, VIJSQL
  5. VIJSQL01

    Unable to find exact length of the number in Sybase IQ, when the data type is CHAR- Need workaround

    Thank you very much for all your suggestions. The RTRIM function has sufficed my requirement. i am using below query for checking the exact length of the string, select zip_code, len(rtrim(zip_code)) from test
  6. VIJSQL01

    Unable to find exact length of the number in Sybase IQ, when the data type is CHAR- Need workaround

    hi, i have a table in Sybase IQ and one of the column data type is defined as CHAR(5). The column has numbers which have 5 digits as well as 4. When i query the length of each row from that column, the length is returned as 5, even for the numbers which are actually 4 digits. But this is not...
  7. VIJSQL01

    Help required for Operating system error code 1311

    Thanks for the reply. Could you please let me know, what should be the syntax of cmdshell command to list a particular file? and on which platform i can execute..etc etc Sorry for asking more, as i am newbie to this.
  8. VIJSQL01

    Help required for Operating system error code 1311

    Thank you very much for meaningful information on the issue faced. In fact, its a lot more information than expected. Thanks a bunch. I would like to take this discussion little forward to know more about how to deal during these type of situations. per one of our friend's suggestion, i have...
  9. VIJSQL01

    Help required for Operating system error code 1311

    This is a great explaination. Thank you very much. i learnt something new today. if i circle back to my issue which i was facing, i would like to give a brief background on how the SQL server is being used for my purpose. 1) Like you mentioned, YES! we have a domain and we work on SQL server via...
  10. VIJSQL01

    Help required for Operating system error code 1311

    It seems like the issue was with the file locked by anouther program or process and that others also have network rights to open it. Because, after sometime i didnt face this issue. But curous to know something about "issue with Domain Controllers. It could be they were down or there is a...
  11. VIJSQL01

    Help required for Operating system error code 1311

    you mean to say, the file should be in .txt format, instead of .csv? And another thing is that, this issue is intermittent. DOes this got something to do with allocated memory..not sure..please help.
  12. VIJSQL01

    Help required for Operating system error code 1311

    Hi, When i am trying to load a SQL table by using BCP command, i am getting below error. Msg 4861, Level 16, State 1, Line 1 Cannot bulk load because the file "\\10.48.164.48\Datamove1\REAS_QA_DATA\REAS1407\HPI_Bulk_Export_by_STATE_201407.csv" could not be opened. Operating system error code...
  13. VIJSQL01

    Unable to Load the CSV file, using BCP command in SQL 2008

    Great! thanks a ton for providing the solution. This works for me. I tried to use the same BCP command again today(having \n as row terminator), I was able to load the data without any issues. This actually surprised me and wondering why it wasn't happening yesterday and why is it today...
  14. VIJSQL01

    Unable to Load the CSV file, using BCP command in SQL 2008

    Hi, I am trying to load large data which is available in .CSV file format. I am getting below error, Msg 4866, Level 16, State 1, Line 1 The bulk load failed. The column is too long in the data file for row 1, column 20. Verify that the field terminator and row terminator are specified...
  15. VIJSQL01

    BCP(Bulk Copy Program) is failing for a large file

    Agreed! BCP is quite old methodology and it doesn't work all the time. Also, thanks very much for providing all these suggestions. In fact, like one of our friend has suggested I figured out the maximum length of the string and accordingly adjusted the data size and it worked fine. But, I have...

Part and Inventory Search

Back
Top