Search results for query: *

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

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...

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.

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

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

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...

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.

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...

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...

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...

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.

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...

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...

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...

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...

Hi, I am facing following issue, when i tried to transfer large volume of data into a SQL(2008) table by using BCP utility. The file format is .CSV and the amount data in it is 180 megs. Msg 4863, Level 16, State 1, Line 1 Bulk load data conversion error (truncation) for row 2081, column 18...

Great! Thank You Thank You Thank You....Thanks a ton. This solution worked for me!

hi, i am unable to convert Varchar to Decimal. I am getting error as follows. Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to numeric. SQL query used: select * from RT_STATE_MASTER where Convert(Decimal(10,4),CAP_RATE_MEAN)<0 i would like to mention here that, when...

Also, at the same time i would like understand how the Cast function works here. Here the Code right('00000' + ... ,5) how exactly it works and what is the main purpose of using the CAST function here? Please throw some light on this, if possible.

Thank you Thank you Thank you...... This is working..Great! You guys made my day.