I need to pick up transactions which occurred from the start of 'yesterday' to the end of 'yesterday' I am doing it this way: TRN_TRANSACTION.BUSINESS_DATE...
I have a row that contains MONEY values. Somehow during, the import, there is a letter in the money field "N" I tried to update all "N" values to ZERO Update...
1. I am new to SQL programming. However, I have a good knowledge of C, C++, shell programming, Foxpro,etc. 2. I have made a functional program in Foxpro to...
HI, I am new to this group, thanks for helping out. I am looking for a query which will give me top 3 records based on the a particular field. If there less...
Good Afternoon, I have a query that counts certain "action codes" grouped by action code, month and year. Some months, certain action codes may not be used....
I am running a Google Wave that is public that will answer questions just like this group to see how GW handles huge threaded discussions (it handles small and...
Hello all: I am an Oracle SQL neophyte and need to be able to dothe following: My customer used to send in a location code of up to 4 characters with leading...
Dear all I am really new to complex sql query I need help to find another possibilities for this query there's so many subquery to skala_rental table Ho to...
Hello, I have a table with item and description like below Item Description 1234a Tool A 1234b Null 1234c Null 2345a Item B 2345b Null 2345c Null How...
Hi Group, I am trying to answer this question: Get the aids and anames of agents with maximum percent who place orders for all products ordered by customer...
Hi sqlqueriesnocode@yahoogroups.com, I set up a Facebook profile where I can post my pictures, videos and events and I want to add you as a friend so you can...
I am one of the member of this group. I would like to know some info about SQL Server ,iam planning to learn SQLSERVER DBA 2008 .I need to know how far its...
Our school uses a mySQL database (called Basmati) to post grades to the internet. We want to use the grades recorded there to determine eligibility for...
how can I add to my sql result an consecutive nomber and display description but not in the group instruction ?? select consecutive, item, description,...
Hi there I need some help with a problem generating a view within MS-SQL 2005. The basic problem is this : I have a table containing "events" (like an audit)...
Hi All i have application in VB.Net and where user Back up the database with his own name and when he restores the database. I want to get the Database name of...
Hey i installed what you told here the link goes http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48A40&displaylang=en ...
Hi, This question is probably OT for this list so if anyone knows a list where my question might be better placed, please tell me. I'll post in here in the...
Hi All I have a table where it has 45000 Rows of data and a Column Named Description will be used to search Just if user enters the Text like this *"Bailed out...
Hello All, I have a database of format Product| Offc | Sale | Spares | Service | Rental -------+--------+------+--------+---------+--------- Prod_A ... Offc_3...
HI , can i download SQL 2008 FREE from net ? if yes can u provide me the link ? Thanks See the Web's breaking stories, chosen by people like you. Check...
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...
Hi I am uploading the Excel sheet to Database through Vb.net .. and I have Written Stored Procedure in SQL SErver and i have written it with te help of this...
Hello All: I am trying to find a function or some way to get only the filename in this data: D:\PROGRAM FILES\BIN\SOFTWARE\DCC SOFTWARE\!T7PPP_.03D So I only...
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,...
hi I am using SQL Express and i have about 70000 Rows data and when i load them it takes 5 mins to load or display can any one tell me or give me the Fast...