|
|
|
July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Maximum Length Issue Posted by Travis at 7/31/2005 9:18:02 PM Hi ,
I perform the query show below to find the duplicate records within the
table itself
"SELECT f_table.flt_Id, f_table.Psg_Id, f_table.Flt_dt_Id
FROM
[SELECT
Count(F_Sgmt_History.flt_Id),
Count(F_Sgmt_History.Psg_Id),
Count(F_Sgmt_History.Flt_dt_Id),
F_Sgmt_History.flt_Id, F_Sgmt...more >>
Query Help Posted by Steve1445 at 7/31/2005 6:21:02 PM Here is what I am trying to do.
I need to query a table like this:
SELECT PROPERTYTYPE, INDUSTRY, ORGNAME
FROM ORGANIZATION
WHERE (INDUSTRY LIKE '51%')
ORDER BY INDUSTRY
I provide the variable, in this case a range of numbers from the Industry
column starting with 51. ...more >>
Starting SQL Posted by TYE at 7/30/2005 4:24:01 AM HI,
How do you start in SQL What do u type in first at the top of the SQL Query
analyzer
Thanks
tye...more >>
Execute StoreProcedue in SQL2000 every time i received a replay me Posted by Renato Ribeiro at 7/26/2005 7:54:03 AM Hi,
how can i execute a StoreProcedue in SQL2000 every time i received a replay
message with a specific subject, and pass some arguments like the subject.
thank in advanced,
Renato Ribeiro
...more >>
Exist Return Values Posted by Travis at 7/24/2005 10:00:01 PM Hi ,
I like to use a variable to store the return values (True / False) of the
exists statement. How can I do that ? I unable to do that from my query show
below
declare @bln
set @bnl = Select Distinct Cust_Id,Cust_Name From Temp_Customer
Where Not Exists
(Select Cust_Id,Cust_Name...more >>
Using variables in Select Statements Posted by Dunner at 7/21/2005 6:36:04 AM Hi guys,
I was wondering if it is possible to use a variable in the from part of a
select statement as in...
select *
from @myVariable
Basically I am writing stored procedure that the user passes a table name to
and then it goes off and grabs info from this table and does some funky
...more >>
N prefex in a non-unicode database Posted by kiran_yalla at 7/15/2005 7:09:03 AM This problem is about N prefex in a non-unicode database.
Collation name of the database is "SQL_Latin1_General_CP1_CL_AS".
Though the database is a non-unicode database, our application generates
N prefexed (before the string constants) queries. This is because, our
assumption is that non-un...more >>
sql server 2000 Posted by Wendy Elizabeth at 7/14/2005 8:46:13 AM I just started to work with sql server 2000. I want to write a query
against "datetime" columns in the sql server 2000 database. I am to be
able to do the following with the sql server 2000 "datetime" columns:
1. Be able to access the date portion only.
2. Be able to access the time po...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Comparing a pair Posted by Gaz uk at 7/14/2005 6:40:02 AM Hi
I would like to have a subquery where I'm comparing 2 values from the
subquery to the main query and unsure on the syntax. I know in Oracle sql
it's something like
WHERE (manager_id , dept_id) IN (SELECT manager_id, dept_id FROM table ...
etc)
Thanks in advance for your help
G...more >>
filtering data Posted by Malgorzata Ndreu at 7/8/2005 12:22:45 PM Hi, all
I have one big table with 190 columns (!), there are user's data stored in
that table.
Now, there is a form on which i can select criteria (around 30) for
filtering users, not all criteria must be selected, so never know how many
and what criterions are chosen.
What would be the best ...more >>
service Posted by shif at 7/6/2005 7:34:01 AM Hi
I have started a server in sql2002 named SERVER1.How can i start
another one new service in same enterprice manager SERVER2.
I tried new sql server registration but its asking for the existing server
name.
ANd second thing is i have to servers serv1,serv2.serv1 is having a table
tab1.
ho...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |