Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Looking for resource to help with composing complex SQL st..

 
   Database Help (Home) -> Full Text RSS
Next:  Change SQL Server 2005 Express's default port pro..  
Author Message
J.

External


Since: Oct 13, 2008
Posts: 2



(Msg. 1) Posted: Mon Oct 13, 2008 11:18 pm
Post subject: Looking for resource to help with composing complex SQL statements
Archived from groups: microsoft>public>sqlserver>programming, others (more info?)

Hi,

I am looking for websites and newsgroups that focus on helping with
composing complex SQL statements. In others words, I need help
somewhere with writing some though SQL.

Please help.

Thanks in advance.

John

 >> Stay informed about: Looking for resource to help with composing complex SQL st.. 
Back to top
Login to vote
"Roy Harvey

External


Since: Jan 12, 2008
Posts: 593



(Msg. 2) Posted: Tue Oct 14, 2008 7:31 am
Post subject: Re: Looking for resource to help with composing complex SQL statements [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Mon, 13 Oct 2008 23:18:05 -0400, "J."
wrote:

>I am looking for websites and newsgroups that focus on helping with
>composing complex SQL statements. In others words, I need help
>somewhere with writing some though SQL.

If you are using Microsoft SQL Server, then I don't think there is a
better place than microsoft.public.sqlserver.programming. Keep in
mind however that there are limits to what sorts of questions can be
dealt with in a newsgroup, and it is up to you to be clear about the
requirements. Part of that is to post DDL (create table) for all the
tables, including their indexes and keys. Table definitions can
usually have columns removed to simplify them if they are not involved
in the query and are not used in indexes. Also required is sample
data for the tables, just the few rows needed to demonstrate the
problem. These should be provided as INSERT commands. Finally, you
need to include the expected output based on that sample data.

Good luck!

Roy Harvey
Beacon Falls, CT

 >> Stay informed about: Looking for resource to help with composing complex SQL st.. 
Back to top
Login to vote
--CELKO--

External


Since: Jan 11, 2008
Posts: 1089



(Msg. 3) Posted: Tue Oct 14, 2008 10:24 am
Post subject: Re: Looking for resource to help with composing complex SQL [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

SQL FOR SMARTIES is still the best advanced SQL in print after all
these decades.
 >> Stay informed about: Looking for resource to help with composing complex SQL st.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
funny search results with 'contains' clause - hi, it is really funny how ft search works: it seems to depend highly on what could be indexed, but it still doesn't follow a determined order. consider the following queries: select name from person where contains(name, 'hammer') select name from..

Insert Into Without Log - Hi, Can I create an Insert Into Query without sql server registration log? Thx.

SQL 2K : custom word breaker ? - Hi, Is it possible to create a custom word breaker for SQLServer fulltext.... I use french word breaker, but for some specific tables, it's not exactly what I want... Seems such a dream will be feasible in SQL 2K5. Please anyone who knows, tell me the....

restore to another server of db with FT catalogs - If we restore a backup copy of a production db having FT catalogs onto a laptop running SQL Server Developer version, the restored db will contain references to FT catalogs whose underlying system files are not yet present on the laptop (because backup..

fulltext search not working - HI!, Fulltext search is not working, i have two databases, fulltext search functionality was working fine on both of them till now. but suddenly fulltext search on one of the databases started giving out errors. when i try to populate, rebuild was..
   Database Help (Home) -> Full Text All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]