Search results for query: *

I am still new to sql server so i apologize if this sounds like a trivial question. I want to query a odbc connection using a query in sql server. the connection string for the DSN naturally looks like "DSN=xxxx;UID=xxxx;PWD=xxx" Could someone tell me how i can use this is a query to query the...

hello everybody I have a table with one colum in which i need to get rid of the leading 0's. It would have been easier to just change the datatype to int. However i can not since some columns have some characters in them. LTRIM() only seems to get rid of leading blanks..Anybody know a...

Would anyone happen to know how to create a variable that would contain the filename as an exprssion in SSIS???

Would anyone happen to know how to create a variable that would contain the filename as an exprssion in SSIS???

Hello, I am using Integration services to upload a bunch of files. In my 'Data Flow Task' I have a 'For loop' which picks up every single file in the folder. Does anybody know if it is possible to insert the Filename as a column so that i can differentiate the rows in my destination table...

Could somebody comment on a better way of doing this. I have three tables...all three close to 2 Gigabytes each. and all three have the same structure. It is taking alot of time to finish the query. Infact still not done at two hours. I am selecting data from these three tables and doing a...

Does anybody know how to include the Filename as a Column in integration Services of SQL server 2005. It does not seem to have that option in the 'Flat file Connection Manager'. Anybody got a clue ?

Does anybody happen to have links to any tutorials about Indexing tables in sql. I seem to be working with huge tables greater then 1GB in size and have a couple of joins to do, and they seem to be taking quite a lot of time. I need to speed things up. Thnx

I am trying to create a unique index and i want the index to include only distinct values. Here is my query create unique index POS on POSDAT ([Chain id],Store,Date) with IGNORE_DUP_KEY I am setting the IGNORE_DUP_KEY to on and it still terminates while creating the index as if it is set to...

I have created a stored Procedure which performs a couple of updates on a table, deletes some data and selects some colums from the updated column. Now that i have created this procedure, I need to use it to join with another table. How do i specify so that i can later query the result of the...

Could anyone tell me what i am doing wrong here, I want to do join three tables together, I have one master table and i am performing a left outer join on it with two tables. select * from custmast a left outer join chainmlrc b, chainbanner c on a.country = b.country and...

I was wondering if anyone could tell me how to perform sequential queries on a table. For example I want to first sort the table using a certain column, and then with the sorted result i want to do a number of calculations and updates. I have the sql written down and i can perform it...

I am developing a database for a company and am relatively new at making something from nothign. The question that i have is that i have a "CustomerMaster" file which i upload to my database, then i have to join it with about 7-8 different files. The way i am doing this is I am joining it one by...

Any Reason why the Query "CREATE TABLE AS" is not working in sql server 2005. I am trying to create a table from the result return of a query. I am using the simple format CREATE TABLE TABLE_NAME AS select * from table1 it keeps giving me this error Msg 156, Level 15, State 1, Line 1...

I have a tricky question, I have two tables, I want to join the two tables on CustomerNO,I only want to retain all the values of Table1. SO i will use an outer join. But During the join i only want to retrieve the last purchaseID, which will be the greater one. If there a way i can do this. in...

Could someone please tell me how i can compare a field with the proceeding record field within the same table, I have a table in which i want to compare the field Cusomter# with the customer # in the next record of the same table. Can anybody please help me with this. Thanks for example NAme...