Why are you creating constants when you can just use the date functions in the where clause?



SELECT sum(Salesamount)
FROM Table
WHERE salesdate BETWEEN ...

Just replace where I had @userInput with getdate() function


SELECT sum(Salesamount)FROM TableWHERE YEAR(salesdate) = YEAR(getdate())


You can do the same with the date functions example.

There are alot of ways to do this here are a couple examples.

Using Year() function

Select sum(Salesamount)
From Table
where Year(salesdate) = Year(@userInput)

You don't directly use triggers in a C# app. If you have a trigger on update for the Student table it will be triggered when you send an update statement from your code. If you want the db to do jobs...

You can't use the alias in the boolean test plus you should use a having clause to test the count(*) and not the where clause.


Select title, count(*) As Cnt
From poss_titles
Group By title...

Try this


Select a,b,c,d,e,f from
(
(SELECT a, b, c, d, e, f, DATE
FROM table1 WHERE a=10 AND b=1)
UNION
(SELECT a, b, c, d, e, f, DATE
FROM table1 WHERE a=11 AND b=1)

I beleive you need to use a full outer join with a coelesce on the 3 keys to get your desired result.


SELECT coalesce(a.Recordingid,b.recordingid), coalesce(a.Connection,b.Connection),...

Use double ampersands && in your if statement.

When you have a higher reputation you get more greeen squares in your header file (I guess it is supposed to signify how competent the responders are) as well I think it might have a reflection on...

By only doing subqueries you basically created a cartesian join. It displayed a record for every possible permutation of the query.

There is a simple explantion of cartesian (cross joins) here.
...

What rownum = 1 is doing is returning only the top row of employee information for each job_id. without the rownum =1 the query will return all matches which is why you get the error message.
...

I know it is possible as I have done similar queries in the past using subqueries. I provided something I put together quickly, not a very good example but it does accomplish what you were inquiring...

I'm not quite sure what you are trying to achieve.

If you just want the job_id then grab it seperately, if you want to see all the employees associated which each job_id you have to return all...

Try something like this.


SELECT DISTINCT emp.Job_ID, a.Employee_ID, a.Last_Name
FROM Employees emp
Join (Select job_id,employee_id,Lastname
From Employees)a on emp.Job_id = a.Job_id...

Did you try using wild cards.


Select * from Table1
Where Name LIKE ('%' + @Name + '%')

Glad I could help. Can you mark the thread solved if your problem has been fixed.

Thanks.

The first thing you need to do is replace the left join with an Inner join. Right now you are joining all the customers even if they do not have any orders which is a waste of resources when you are...

Have you tried joining the subquery in the from clause instead of using the inline view.

You should use code blocks as it makes it alot easier to read.



[/code}

Did you try an inline view? something like this maybe

[code=sql]
select

At my previous company we also resorted to using dotdefender after we came under a serious sql injection attack. The product worked very well and we were able to get it up and running very fast. It...

Here is a link to an article on creating an event schedule in mysql, unfortunately I don't use mysql so it is the best I can do for you.
...

I don't know mysql very much but if you schedule a job it should not care if a file is open or not.

Schedule a job to run the script at whatever interval you want.

Mamtha,

If this solved your question can you please mark the thread solved.

thanks.

Yes intersects work well and are much more readable.

Try something like this


Select customer from Table
Where purchasedate between trunc(sysdate,'MM') and LAST_DAY (TO_DATE (trunc(sysdate,'MM')))
and product = 'ABC'
INTERSECT
Select customer...

I think we would need a little more details to what you are asking.

Do you want a list of all customers that purchased a specific product in the current month only IF they had purchased the same...

Try this


SELECT MAKE.MAKE, MAKE.count, color.Color, color.count
FROM(
SELECT MAKE, count(*)count
FROM cars
Group by MAKE
)MAKE,
( SELECT MAKE, color,...

Nevermind, I take it the attachment is the table schema.

Is it important to do it all in one query. What are you using the resultset for because if you do it in one query you will most likely get...

I actually remember reading both of these threads and had commented on one of them but I still did not correlate them.

@sknake - thanks, I didn't realize there were multiple threads relating to this db.

I don't see where you are getting the alias 'c'

Besides that i think you are making it more difficult then it has to be.



select *
from dbo.tblLevelOneApprover a,...

Since you didn't give too much information I thought of a few other interpetations of what you asked.

If field1 is a numeric value you might want the sum of the field grouped by field2


Select...

do you mean something like this


Select field2,count(Field1)
From Table
Group by field2

Link82

Group by does exactly that; groups your result set by the fields provided, in the example provided by sknake.


GROUP BY tblManagers.managerID, tblManagers.managerLastName,...

I can't see any easy way to parse this string in a single select statement. I would try each individual piece at a time and then once you can parse each piece put them back together.

You might...

You should be able to create a stored procedure and try to break off a piece at a time.

If you don't need the data live maybe you can make a dts package to run daily to parse these strings and...

I have question.

How were these records imported into the table in the first place?

It would have been easier to parse them correctly when they were initially loaded.

I have never used filemaker but it is a relational db so their is most likely either a sql window or graphic sql designer like in acccess.

If there isn't you will have to find out how to join...

You should have a seperate table which holds your costs and is referenced to the item table.

Items
--------
id ...