This problem is related to a question that was successfully answered a couple of days ago. Unfortunately the report requirements have since changed so I'm going to need a little more help.
Th...
I am working on an upcoming birthdays list for my coworker using a datagrid. It shows the upcoming birthdays based on what is chosen in the drop down menu (next 30 days, next 3 days, next 5 da...
The following sample shows a way in which I am returning exactly what I want to see, and is pretty fast to fun, but it just seems like a pain in the butt. I am not just doing totals A, B, C b...
I need a sql statement to be able to pick up whether there's more than one instance of a certain word in a sentence. Such as "A dog ran across the street to meet another dog." I need a sql sta...
Hello,
I have a list of articles that I want to group by alphabet letters (but in groups like a-f!g-k!l-p!
Say if the sql for related articles gives me about 70 articles in return.
I ...
I have created a SQL query to output written text which may be multi-lined and contain carriage returns, numbers and/or other characters. When this .csv is exported into Excel, the text which ...
I want to create a table that consists of one column (integer) with 500 rows, starting from 1 to 500. See below.
Is there an insert into statement which can insert all of these values autom...
My understanding of subqueries is that I can only match on one field from my main query. For the project I have now, I want to group one way so that I get the earliest timestamp for a particu...
I need to select and display using SQL duplicate records from the following table
bomparent bompos
12 1
12 2
13 1
13 2...
Hi all
im not to sure how to do this so hope somone can help
i have a query SELECT id, parentID, etc FROM table WHERE parentID = value
but what im trying to do is also find out if a...
I have a column of ids (not auto increment)
I want to write a function to add zeros to the beginning of the field until I have 6 characters.
Ex. pass 82 to the function return 000082
...
What I have to do is split apart the name field in my query. What I am doing is creating a text file with individuals w-2 information and it has to be a certian way in the file. The user just...
Hi Experts
I'm having some trouble getting a recordcount and moving to the first record on the following code. Can anyone see the error to help me get
a/ the record count .
b/ move to ...
Hi,
I have a query which is filtering on quite a bit. I need it however to filter on a little more. I need it to filter now on the Sponsor field. I need to say once all filters have taken p...
I have some VBA code which I use to requery a listbox. The query for the listbox is a simple "SELECT * FROM Table" query.
Below is my code:
'Check to see if control has changed
If Contr...
I'm not sure how to ignore a parameter if it's null in a WHERE clause. For instance:
CREATE PROCEDURES GetBookList
@BegDate smalldatetime,
@EndDate smalldatetime
AS
SELECT *
FR...
I want to insert data from table1 into table2, where both contain the same fields, and table1 contains many duplicates. (This table is cleared and re-populated daily). I want to insert recor...
Let's say I have a table with company, contact, and zip code fields containing the following information:
Smith Marketing, Lisa Smith, 90210
Smith Marketing, Bob Smith, 90210
Smith Marke...
I am trying to UPDATE a table trow using data from other record from the same table. Is it possible in VBA in the UPDATE statment to use SELECT statement as seen in the attached code. I get 3...
Hi,
I'm writing a golf app for a local club. I need to keep track of handicaps (they do it, fortunately) in quite a simple way.
Here is the pseudo code
Sproc 1 If NumRounds played from...
Division in Relation Algebra displays a set of tuples in R that match every tuple in S (over some attributes) but how do write that in SQL? (T-SQL please)
Lets say :
R / S
Relation R
...
The following is my sql query that is pulled in by a datagrid. The problem with the query is that a person can have multiple attendacne dates and I need to combine all those dates to show in ...
Hello experts,
When executing the attached code (trigger created via stored procedure) like so EXECUTE GenerateAudittrail 'Records_Retention' , I get error;-
Msg 102, Level 15, State 1, Pr...
Hello.
SQL Server 2000
Table - tblDateTimes
Columns: ClassID, Date/Time (other columns, but irrelevant)
Table - tblClasses
Columns: ClassID (same as tblDateTimes), ClassName, e...
On my insert into my database i need to convert 2 dates to a string format to store in the DB. Curretnly they look like so 8/1/2008 I need this date to look like 01AUG2008. The firelds I n...
