I am kind of new at it. Only been working with SQl for couple of month. and I have a weired questions! I have a results view such as below type Qty...
1863
BESHOUY GERGES
be_slave4u
Jan 16, 2006 12:57 pm
use group by pengbsam <pengbsam@...> wrote: I am kind of new at it. Only been working with SQl for couple of month. and I have a weired questions! I...
1864
filzah hanani
unidha
Jan 16, 2006 12:57 pm
try select type,qty,station,expense from tablename group by type pengbsam <pengbsam@...> wrote: I am kind of new at it. Only been working with SQl for...
1865
pengbsam
pengbsam@...
Jan 16, 2006 4:00 pm
view 1 is the result of a group by! Because the first part and the second part of the view set in different level! even a group by will still make it look...
1866
pengbsam
pengbsam@...
Jan 16, 2006 4:00 pm
... Yes. but that will still have qty duplicated. System recognize that it's repeat# in a relational point. But if this view is extracted to excel and a pivot...
1867
peternilsson42
peternilsson42@...
Jan 17, 2006 2:46 am
... Before the select, do... break on "type" skip page on "Qty" -- Peter...
1868
Noman Aftab
noman17pk
Jan 20, 2006 3:00 pm
hi all, I am using Sql Server 2000, data transformation services. I have made a package and scheduled it on a certain time..lets say 4:00 PM, daily. Is it...
1869
paul a
itsavm_paul_...
Jan 22, 2006 3:46 pm
Hi, What is the advantage of using oracle instead of xml to store data for applciation development. Currently i am doing a project to implement the ERP, but i...
1870
John Warner
john@...
Jan 22, 2006 7:16 pm
Oracle scales better is faster and reduces if you do your design work properly the likelihood of data anomalies. I suspect there are lots of other reasons to...
1871
Narendra okte
meet_narendr...
Jan 26, 2006 11:38 am
Dear all, I just started to learn sql. I don't know how can I become a good database handler. Can anyone help me. Thanks and regards, Narendra Send instant...
1872
John Warner
john@...
Jan 26, 2006 2:02 pm
What is it you want here? Your question is a bit broad, is there something specific you need help with? John Warner ... From: SQLQueriesNoCode@yahoogroups.com ...
1873
Ruffin Bailey
rufwork2
Jan 26, 2006 3:35 pm
On 1/23/06 9:57 AM, "SQLQueriesNoCode@yahoogroups.com" ... Sounds like you're using .NET. You can certainly use XML as a datastore of sorts, serializing your...
1874
a a
babycatapple
Jan 27, 2006 1:42 pm
I have a table with the following three columns. TransID Amount DateTime 1000s of Entries are coming per minute. now i need to query Data according to...
1875
James Poulose
James.Poulose@...
Jan 27, 2006 2:53 pm
Hi, Add a DateTime column to the table (if it does not exist) which can hold time with seconds and milliseconds. In the query use this information to filter...
1876
John Warner
john@...
Jan 27, 2006 3:06 pm
ANSI SQL may not be capable of this as is, could you tell us the RDBMS you are using (SQL Server, Oracle, MySQL, DB2 etc)? John Warner ... From:...
1877
Michael Weiss
mweiss@...
Jan 27, 2006 6:17 pm
See this link ... http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12481: 064 Also, search on Google for "t-sql group by time interval". You...
1878
John Warner
john@...
Jan 27, 2006 6:22 pm
You assume SQL Server, what if Oracle or DB2, thus my question. John Warner ... From: SQLQueriesNoCode@yahoogroups.com ...
1879
Michael Weiss
mweiss@...
Jan 27, 2006 8:54 pm
I wasn't assuming anything, John, and my reply was not directed at your question regarding the RDBMS. I was simply sending him in the direction of examples of...
1880
Damhuis Anton
tyrebender
Jan 30, 2006 5:22 am
Hi A A Questions:
How will you execute this query every 15 minutes?
If you can have the external App execute the query reliable every 15
minutes, then it would...
1881
Balaji Sreenivasan
balaji_dravid@...
Jan 30, 2006 1:11 pm
How to merge these 2 into a single: query 1: UPDATE I_LIMIT SET [cycle no] = "US0010001" WHERE USERNAME LIKE '*1' or USERNAME LIKE '*2'; query 2: UPDATE...
1882
A.J. Morales
ajmorales.rm
Jan 30, 2006 1:23 pm
I believe a 'union' query would do the trick! Just add the word UNION between both queries as 1 query. AJ Balaji Sreenivasan <balaji_dravid@...> wrote: ...
1883
John Warner
john@...
Jan 30, 2006 1:58 pm
I don't think UNION works the way you want with UPDATEs. Union is when you want to merge the result set from two seemingly unrelated tables/queries. What RDBMS...
1884
a a
babycatapple
Jan 30, 2006 3:04 pm
Dear, i dont want single row, i want rows grouped by 15 min interval. Damhuis Anton <DamhuisA@...> wrote: Hi A A Questions: How will you execute...
1885
a a
babycatapple
Jan 30, 2006 3:42 pm
SQL Server 2000 John Warner <john@...> wrote: ANSI SQL may not be capable of this as is, could you tell us the RDBMS you are using (SQL Server,...
1886
Dave May
dave.may@...
Jan 30, 2006 3:44 pm
I can't take credit for the solution, but the post by FrankKalis at the bottom of this forum thread over at sql-server-performance.com should take care of your...
1887
John Warner
john@...
Jan 30, 2006 3:57 pm
I don't think there is anyway to do this outside of looping through the records (SELECT col1, col2, ... FROM table WHERE your qualification). In SQL Server...
1888
John Warner
john@...
Jan 30, 2006 4:00 pm
Well thank you for a real lesson in SQL. I was unaware (as my previous post indicates) that you could do this in a GROUP BY clause. I always learn things from...
1889
Virtual Fission
vfission
Jan 31, 2006 1:15 am
Hi I am given a date and maturity as in 01-27-2006 and 05/15/2030 I must compute the number of days between 11-15-2005 and 05-15-2006 and the number of days...
1890
ajay_vetal29
Jan 31, 2006 1:47 am
... wrote: What is it you want here? Your question is a bit broad, is there something specific you need help with? John Warner ... From:...
1891
Dave May
dave.may@...
Jan 31, 2006 1:47 am
You didn't specify which RDBMS you are using, but if using SQLServer the solution is very straightforward. Lookup datediff in BOL for more information. select...
