Recent content by atiqraza

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