Search results for 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...

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

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

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

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

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

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

hi, I am struggling to add a prefix to one of the column value in my table. The scenario goes like this. I have values in a column, which are 4 as well as 5 digits. The values which have 4 digits should be added with '0' as prefix. I already tried out following way, but it turned out be wrong...

hi, I have a table, which contain 8 different columns. I need to figure out the values which are same across selected four columns with in a table. In the same query, i want to see the value in those two columns where values are different. An example would be as follows, Table Name: Table1...

hi, I am trying to load a table in SQL 2008 by using a data present in .csv file by using BCP command. I am unable to do this, as it is throwing following 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 15. Verify that...

Hi, I have a stored procedure in SQL 2008 which does certain calculations based on business rules. In order to do the calculations, we need to supply data in the form of file in .csv format. As of now, the stored procedure is unable to process the data, if the data file has a header. The...

hi, I have a stored procedure in SQL 2008 which does certain calculations based on business rules. In order to do the calculations, we need to supply data in the form of file in .csv format. As of now, the stored procedure is unable to process the data, if the data file has a header. My...

Hi, I am writing a dynamic query where in i need to put data exclusion criteria by using two columns from a table. The two columns which i am using are 'FLOP_PRICE_AMT' and 'REO_PRICE_AMT'. The condition goes like this, if FLOP_PRICE_AMT is less than 90% of REO_PRICE_AMT, then that...

hi, I am a beginner for using Microsoft Access databse which we have for one of our product. The qurying on Access database is quite different than any other traditional databases like SQL ,Sybase, Netizza etc. Sometimes i need to do some kind of testing on Access databse and i face lot...

hi, I need to handle the error message in stored procedure. I am doing following things... 1. First i will be loading data into a table from flat file which is of .CSV format. 2. I am loading the data along with header. 3. I use normal delete statement to delete the row which has...

hi, Is there any query i can use single query to fetch all the table names present in a whole database. This i need to perform on SQL database. I am finding it difficult to copy from the table tree view on the left hand side of the SQL for listing out all the tables avaialable, since it has...

hi, I am facing a difficulty in finding the whether the number is in four decimal accuracy has all the values for all the four decimals instead of zeros in a huge set of data. Example: i have a number, 6.0000 and the other number 16.5600 and the other number 15.6754 I am interested to find...

hi, i am trying to create a SSIS package in SQL 2008. The steps i am following are as follows. a. Open import/export wizard b. Specify data source as SQL Server Native client 10.0 c. Specify server name d. Use SQL server authentication e. Choose database f. In the next page, specify the...

hi, i am facing an issue in converting one of the date format to other. The current date format is 1/1/2010 Required format is Jan-10 I have used the following code to convert it. Its working fine in source table not in the target table. In both tables, i have defined data type in both the...

In this thread, i need to discuss about DML commands usage in SQL 2008.