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

Thnx guys... damn you guys are good

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

What i am trying to do is insert the filename as a colum. I am using the 'Derived Colum' in the Data flow to Add another colum to my table. However i need to use a variable which would contain the filename. I can not hardcode the filename because i am using a for loop to pick up a bundle of...

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

Is it possible to Group by on the whole UNION ?

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

Hey thnx it worked!! I knew i was doing something stupid....

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

Can we use if statements to create new colums in sql, suppose i want to copy a whole table, and insert a new colums which says if country = Canada insert 'CA' anybody know the syntax for that ?

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

Hey George, Thnx for the reply but i am not using a table i am using a querry's return to create the new table, for some reason this syntax does not support it...OR does it ?

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