I've never tried to do this, but I would make sure that SQL Server can find the file and has permission to open the file in that folder. John Warner ... ...
John Warner
john@...
Jul 1, 2009 12:32 pm
4199
Avinash, Good grief! You have no design whatever in your database! I think you have to go back to the beginning, scrap everything you've got, and really...
Then I am surprised it only takes 5 minutes, I would have expected longer. John Warner ... any ... 1km ... *and ... a ... could ... where ... query ... can ......
John Warner
john@...
Jul 1, 2009 12:33 pm
4201
Avinash; What you are talking about is called Full Text Indexing. It is a feature in MS SQL that will index all the text of a column, not just the starting...
@Rob Yea It has to search in only 3 Columns i.e., Hnote , Notes,Description . Hey sorry i think in a hurry i mentioned all columns [?]. only i need from those...
You still have an issue, the 'Laser Light' text in a properly designed application would only appear in one column, not three. Rob is correct you have some...
John Warner
john@...
Jul 1, 2009 12:46 pm
4204
Hey John check this link http://www.aspsnippets.com/post/2009/06/06/Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASPNet.aspx ... -- Thanks & Regards...
Does SQL Server and it would appear IIS have permission to the folder? Is Jet installed on the server? John Warner ... about ... sunlight." ... printing ... ...
John Warner
john@...
Jul 1, 2009 12:54 pm
4206
yes Installed... ... -- Thanks & Regards Avinash Desai *SAVE Nature SAVE Tree SAVE* Think Before you print: Please consider our environment before printing...
Permissions? John Warner ... Is ... can ... Source=' ... Properties=''''Excel ... server ... before ... printing ... ...
John Warner
john@...
Jul 1, 2009 12:59 pm
4208
Hey john i got it done the code works fine and there was one error while executing the Procedure Exec spx_ImportFromExcel03 'Sheet1*$*','C:\Documents and ...
Hello All: I have a database with three tables: Terminal Acquirer Issuer Unfortunately: they are not normalized or follow standard database practices, but I...
When confronted with a non-normalized database I tend to resort to a procedural language like C# or VB.NET and normalize the data within my code and well ... ...
John Warner
john@...
Jul 1, 2009 4:15 pm
4211
I agree with John in that you will need to normalize the data in the Terminal table to get you somehting you can work with, but there is no need to use...
Hi, I am sure this will be easy for most on this list but I appear to be missing a trick. I have a table with the following columns: asset_id, PK, INT user_id,...
SELECT a.user_id, a.asset_id FROM TABLE a JOIN (SELECT user_id, count(user_id) FROM TABLE GROUP BY user_id HAVING count(user_id) > 99)) b on a.user_id =...
Hi, Use the following query select user_id ,count(user_id) from table group by user_id having count(user_id) > 99 Regards Selvakumar.K ... From: Dermot...
Paul, thanks again for the help here. One more question that does not seem clear from my reading on the web. When using sp_addlinkedserver is the...
John Warner
john@...
Jul 8, 2009 1:49 pm
4218
Hi John, Using sp_addlinedserver places the remote server connection details into the system view (table) sys.servers, that is persisted in master. Using SSMS,...
Thanks. Long time no see your posts. Hope you are well and enjoying the summer. John Warner ... the ... seem ... the ... away ... database, ... under ... name ...
John Warner
john@...
Jul 8, 2009 2:38 pm
4220
One of the columns is moved from one table to some other table in the same database. How can one find the name of the new table where the column has been...
Ask and threaten death if they ever do this again without making the entire department aware of the plan. This can break more than just a single query and...
John Warner
john@...
Jul 11, 2009 4:11 pm
4222
in oracle you can use *all_updatable_columns* table to see all the columns and their tables. On Fri, Jul 10, 2009 at 9:08 PM, ravi...
So Oracle is not SQL-92 complaint yet with Information_Schema support ? John Warner ... columns ... same ... is...
John Warner
john@...
Jul 12, 2009 4:20 pm
4224
I may be erroring on something else, but my question is does the UPDATE statement allow table aliasing? UPDATE myDataBase.dbo.myTable m INNER JOIN...
John Warner
john@...
Jul 16, 2009 7:36 pm
4225
John, try this instead: UPDATE m SET m.cust = y.cust FROM myDataBase.dbo.myTable m INNER JOIN YourDatabase.dbo.yourTable y ON m.field = y.field WHERE m.cust IS...
... update mydatabase.dbo.mytable m set m.cust = (select y.cust from yourdatabase.dbo.yourtable y where y.field = m.field) where m.cust is null; This can fail...