Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The <code>:as_studid</code> and <code>:as_period</code> things are most likely parameters of this query as used by some client software. Before the query is actually executed, the <code>:<i>name</i></code> bits are replaced (typically by some middle-tier software) with something like <code>@P1</code> or, maybe, <code>@as_studid</code>, so the server never sees the colons there (and never complains).</p> <p>If you are not a client software developer and have simply been assigned the task of doing something with the query, then you need to apply the above mentioned transformations manually. I'd suggest you declared variables <code>@as_studid</code> and <code>@as_period</code> and use them instead of <code>:as_studid</code> and <code>:as_period</code> respectively. Also you'd probably need to assign them some values, so you could see some results when running the query. Here's an example of how the modified script might look like:</p> <pre><code>DECLARE @as_studid int, @as_period int; /* those are just my guesses, the actual types might need to be something other than int */ SET @as_studid = 10; SET @as_period = 20; /* again, those are arbitrary values off the top of my head but you might have to discover some real ones before going on */ SELECT dcm.code DCM_No, dcm.datetime_created DCM_Date, lne.seq_number, par.code, par.description particular, ft.description fee_type, lne.amount, case when lne.drcr =1 then 'Debit' else 'Credit' end DrCr, case when isnull(dcm.is_sd,'N') = 'Y' then 'Salary Deduction' else null end is_sd, org.description Company, org.postal_address company_addr, 'S.Y. ' + substring(sy.school_year,1,4)+'-'+substring(sy.school_year,5,4) +' '+sem.description SY, entity_a.code + ' - ' + coalesce(entity_a.stud_lname,'') +', '+coalesce(entity_a.stud_fname,'') +' '+coalesce(entity_a.stud_mname,'') Student, case when isnull(dm.description2,'') = '' then crs.course_short_name + '-'+convert(char(1),entity_a.stud_grade) else crs2.course_short_name + '-'+convert(char(1),reg.stud_grade) end as Course, isnull(dm.description2,'Not Enrolled') FROM es.lib_rgn_students entity_a left join ars.ars_dcm dcm on dcm.entity_id = entity_a.id LEFT JOIN afs.entity entity_b ON dcm.prepared_by_id = entity_b.id LEFT JOIN ua.user_account ON dcm.prepared_by_id = ua.user_account.id left join ars.ars_dcm_line lne on lne.ars_dcm_id = dcm.id left join es.lib_fin_fees_master par on par.id = lne.ars_particular_id left join es.lib_fin_feetype ft on ft.code = lne.fee_code left join es.stp_sysem sy on sy.id = dcm.period_id inner join es.stp_semesterms sem on sem.code = sy.semester and sem.trimester = 0 inner join afs.organization org on org.id = sy.company_id inner join es.lib_crs crs on crs.id = entity_a.course_id left join es.trn_rgn_reg_hdr reg on reg.period = sy.id and reg.stud_id = :as_studid left join document_status_map dm on dm.code = reg.document_status left join es.lib_crs crs2 on crs2.id = reg.course_id WHERE (dcm.entity_id = @as_studid ) AND -- the vars declared above are used ( dcm.period_id = @as_period ) AND -- here instead of the ':'-bits ( dcm.document_status_code not in(2,3) ) </code></pre> <p>Alternatively you could do without variables, just replace <code>:as_studid</code> and <code>:as_period</code> with some (real) values. But that way you'd have to remember what exactly was parametrised in the original query, for, in any event, if your task was to modify the query itself, you might have to submit it back with the <code>:</code>-names, just like you received it.</p>
    singulars
    1. This table or related slice is empty.
    1. POSQL Server 2008 R2 query error: Incorrect syntax near ':'
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USAndriy M
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POSQL Server 2008 R2 query error: Incorrect syntax near ':'
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThank you very much!! iv'e been looking answers about this for about 2 days now.. i really don't know what to do with the error i have occurred.. i don't have much idea about this.. i was just assigned to do this.. you save my life thank you very much :D
      singulars
      1. PO
      1. USravenxi
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload