|
|
|
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 |
Need help with Simple script Posted by bluesrock12000 at 1/30/2006 9:00:37 AM Example data:
column1 column2
abcs12 123456
asdf-af 1234
asrlkk' 123456789
What I need to do is capture the data that does not have exactly 6 numeric
numbers in column2. So the desired result would display rows 2 & 3.
Any help would be appreciated,
Thanks in adv...more >>
Compare row data and input data into a new field Posted by Newman Emanouel at 1/26/2006 7:45:02 PM Dear All
I have a simple query which I cannot seem to work out and would like some
help.
I have a small table with data like such
ID Week_as_Int WeekEnding Check
ASome 523 5/06/2005
ASome 531 31/07/2005
ASome 548 27/11/2005
ASome 549 4/12/2005
ASome 604 22/01/2...more >>
Saving Datetime to variable Posted by pietro at 1/22/2006 6:14:02 AM Hi im working on a simple function. I have a table with two columns
(datetime) and I need to extract date rom one of them and time from another
one - and then to join it and save it in the variable (which is declered as a
datetime). Please, can somebody help me or advice another waz how to get...more >>
Promt user for criteria ? Posted by Xavier at 1/20/2006 7:36:05 AM I know it can be done with a SP but is there a way to prompt a user for
specific criteria like date range (between ? and ?) in a view.
I have a query in a view but I need to prompt the user for a date range, my
front end is access 2002 I can do it as a passthrough but it takes to long to
run ...more >>
backup table to another table in database Posted by Danne at 1/17/2006 8:04:03 AM I need to create a new table with the same columns using a select from
another table. I cannot find the syntax. Does anyone know if this can be
done in SQL 2k?
--
Danne...more >>
Is there any way to make this query faster? Posted by g5g at 1/10/2006 6:36:02 PM Is there any way to make this query faster?
select
sum(p.QTY * p.PricePromotion) as ttl_trans_amt,
sum(p.QTY * p.PriceSold) as ttl_trans_amt,
(sum(p.QTY * p.PricePromotion) - sum(p.QTY * p.PriceSold)) / sum(p.QTY *
p.PricePromotion) * 100 as disc_given
from Price p
...more >>
SQL Query Posted by Mukesh Garg at 1/9/2006 12:40:02 AM Hi all, i am not able to make up a query according to my need. can anyone
help. Following is my simple query.
select udf_name [Severity],st_name [Status], count(2) [count]
from bugs, statuses, user_defined_attribute
where udf_id = bg_user_defined_attribute
and bg_status = st_id
group by...more >>
Conditional 'Order By' statement Posted by Wez at 1/7/2006 6:51:02 PM I have a table that stores three columns of data, namely
1. Order_ID
2. Exam_Start_Date
3. Order_Received_Date
I want to order the records as follows:
If the Exam_Start_Date is within the next 10 days or past, then order by the
exam_start_date. Otherwise order by the order_Received_Date. ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to select all top 1s from different group in a view Posted by adam at 1/4/2006 2:23:05 PM Hi SQL Query Guru,
I have a view like this:
Contract_KEY Step
1 1
1 3
2 1
2 5
2 4
How do I write a query to retrieve the following result:
1 3
2 ...more >>
Update 'Date': Set Day(Date) to a Certain Number Posted by PML at 1/4/2006 5:31:07 AM Hi,
I am trying to use an update command to set the day of a date to a certain
number. For example, if the date is 1/4/06, I might want to set day(date) to
'7'. So it turns into 1/7/06. I wasn't sure if there was a way to do this
and I keep getting errors when I try it.
Thanks,...more >>
SQL Query Help Please....(you guru's should know it). Posted by Erin at 1/3/2006 12:06:07 PM 1. I have a table of Service Request Status Changes.
2. Each time the Service Request is updated, a new RevisionID is generated
which shows what the revision was.
3. The Service Request can be updated several times in a month.
4. I need to report on how many distinct Service Requests were updat...more >>
Microsoft SQL Server Management Studio Express Posted by Nick K at 1/2/2006 8:21:52 AM I am attempting to connect to a SQL Server 2005 database using a Visual
Studio.Net 2003 application.
When I use this connection string, I get a Keyword not supported: 'user
instance'. error.
<add key="SiteSqlServer" value="Data Source=.\SQLExpress;uid=sa;pwd=;User
Instance=True;AttachDBFilena...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |