473,466 Members | 1,298 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

New to sql server could someone point out the error in this query

1 New Member
Expand|Select|Wrap|Line Numbers
  1. SELECT TRA.INDACCOUNTNUMBER,I.FIRSTNAME +' '+I.MIDDLENAME +' '+I.LASTNAME FULLNAME ,TEC.ENDDATE,ORG.NAME1,SUM(LSIndiv.COMBINEDGIFT)
  2. FROM Andar.LSIndiv L,
  3. Andar.INDIVIDUALS I,
  4. Andar.TECHNIQUES TEC,
  5. Andar.TRANSACTIONS TRA,
  6. Andar.ORGANIZATIONS ORG
  7. left join Andar.TRANSACTIONS ON
  8.    I.ACCOUNTNUMBER=TRA.INDACCOUNTNUMBER  
  9. left join Andar.TRANSACTIONSON ON
  10. L.INDIVACCOUNT=TRA.INDACCOUNTNUMBER 
  11. left join Andar.TRANSACTIONS ON
  12. TEC.ACCOUNTNUMBER = TRA.INDACCOUNTNUMBER 
  13. left join Andar.TRANSACTIONSON
  14. ORG.ACCOUNTNUMBER=TRA.INDACCOUNTNUMBER 
  15. WHERE
  16. TEC.TECHNIQUETYPE={'AF  WLI'} AND TEC.CAMPAIGNYEAR= 2008 AND TEC.ENDDATE
  17. group by 
  18. TRA.INDACCOUNTNUMBER,FULLNAME ,TEC.ENDDATE,ORG.NAME1
Nov 22 '11 #1
3 1637
ck9663
2,878 Recognized Expert Specialist
Check your syntax. Here, read this...

Happy Coding!!!


~~ CK
Nov 22 '11 #2
Mertins
1 New Member
As far as I know, the symbols '{' and '}' have no meaning in SQL Server; for sure, have no meaning in a WHERE clause.
Nov 22 '11 #3
NeoPa
32,556 Recognized Expert Moderator MVP
Please read [code] Tags Must be Used.
Nov 23 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: jason | last post by:
I am picking up an error message on a straightforward INSERT - do I need an optimistic-type to get this working....here is is the error: Microsoft JET Database Engine error '80004005' Operation...
10
by: Ike | last post by:
For some reason, I have a rather large (to me) query, with numerous inner joins, accessing a remote server, and it is taking about twenty times longer than most queries to the same database. The...
5
by: George Copeland | last post by:
This is a request for help fixing a SQL Server 2000/ADO problem on Windows XP. I would appreciate any useful assistance. PROBLEM: SQL Server access on my machine fails as follows: 1. All of...
1
by: Leonard Danao | last post by:
I get this error when i run my code below "An unhandled exception of type 'System.Net.WebException' occurred in system.dll Additional information: The remote server returned an error: (401)...
2
by: pikapi | last post by:
I have the following table: direction bin net 1 s1 6 2 s2 3 1 s1 2 2 s1 4 1 s2 5 I want to produce a table like this:
2
by: Janna Deegan | last post by:
Hello all, First off, if there is a better place to post for an answer to this question, please feel free to point me there. I have some very strange behavior happening with my System.web.mail...
1
by: George | last post by:
I'm a long time C++/SQL programmer. Know some C# application stuff. Basics of setting up a web server. Basic html and Java. And nothing about ASP.NET
1
by: cindy | last post by:
Get data into datatable, add to dataset dsSearch " Get data into datatable, add to dataset dsSearch Using In-Memory SQL Engine join the tables and select the filenames from the join, add to...
11
by: Tore Halset | last post by:
Hello. I am trying to port an old java application from MS SQL Server to PostgreSQL running on Mac OS X. I have access to the java source code and can make modifications. I have tried with...
2
by: Mike Hofer | last post by:
In my ASP.NET application, *one* page would not render in the application. All others would show up just fine, but when the user clicked the button to browse to this one page, I'd get a nasty error...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.