SQLQueriesNoCode : Messages : 4198-4227 of 4227

Yahoo! Groups Tips

Did you know...

Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

Messages Help

Advanced

Messages 4198 - 4227 of 4227 Oldest | < Older | Newer > | Newest

Messages: Simplify \| Expand (Group by Topic)		Author	Sort by Date

4198	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...	Rob Richardson interrobang	Jul 1, 2009 12:32 pm
4200	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...	Paul Livengood p_livengood	Jul 1, 2009 12:34 pm
4202	@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...	Aa a� avi87_desai	Jul 1, 2009 12:40 pm
4203	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...	☺Aνιηα�... avi87_desai	Jul 1, 2009 12:48 pm
4205	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...	☺Aνιηα�... avi87_desai	Jul 1, 2009 12:56 pm
4207	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 ...	☺Aνιηα�... avi87_desai	Jul 1, 2009 1:03 pm
4209	Hello All: I have a database with three tables: Terminal Acquirer Issuer Unfortunately: they are not normalized or follow standard database practices, but I...	Mills, Andy historyandph...	Jul 1, 2009 3:15 pm
4210	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...	Paul Livengood p_livengood	Jul 1, 2009 4:35 pm
4212	If you are using SQL SERVER then use FULL TEXT INDEX. [Non-text portions of this message have been removed]...	drury lumenta drury_yl	Jul 7, 2009 12:19 am
4213	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,...	Dermot dermotduke	Jul 7, 2009 9:26 am
4214	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 =...	Paul Livengood p_livengood	Jul 7, 2009 12:14 pm
4215	Thank you all very much for your replies: I managed to golf it down to: SELECT asset_id, user_id, count(user_id) from tbl1 group by user_id HAVING...	Dermot dermotduke	Jul 7, 2009 2:27 pm
4216	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...	selva kumar selvakumar.k...	Jul 7, 2009 3:03 pm
4217	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,...	Arnie Rowland arnie1568	Jul 8, 2009 2:09 pm
4219	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...	ravi santlani ravisrich	Jul 11, 2009 3:06 pm
4221	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...	Hans Raj Sharma hansrajsharma	Jul 12, 2009 3:16 pm
4223	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...	Tim Mitchell tdmitch	Jul 16, 2009 7:39 pm
4226	Thanks! John Warner...	John Warner john@...	Jul 16, 2009 7:51 pm
4227	... 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...	peternilsson42	2:04 am

Messages 4198 - 4227 of 4227 Oldest | < Older | Newer > | Newest

Advanced

What's This?

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages