Selecting based off of 2 dates in two separate column on another SQL Server database -


i'm having issues subquery giving me issue

msg 4104, level 16, state 1, line 3
multi-part identifier "reference..shift_begin_datetime" not bound.

msg 4104, level 16, state 1, line 3
multi-part identifier "reference..shift_end_datetime" not bound.

msg 4104, level 16, state 1, line 3
multi-part identifier "reference..mfg_ww_no" not bound.

the table i'm trying pull mfg_ww_no on table on database. way have pull matching tracked_out_datetime falls between shift_begin_datetime , shift_end_datetime.

any ideas on i'm doing wrong.

this portion subquery that's giving me problems.

(select [reference]..[mfg_ww_no]  reference.dbo.ww_shift        [tracked_out_datetime] between [reference]..[shift_begin_datetime] ,         [reference]..[shift_end_datetime]) ww

here's complete query reference.

select distinct top 1000  --*     [lot_id]      ,[tracked_out_datetime]     ,convert (varchar(20), s.facility_step_seq_no) + ' ' + convert(varchar(50),      step.step_name) step_name     ,datediff(mi, flh.staged_datetime, flh.tracked_out_datetime) - flh.time_at_hold_seconds_value /60 truecycletime     ,(select          [reference]..[mfg_ww_no]       reference.dbo.ww_shift       [tracked_out_datetime] between [reference]..[shift_begin_datetime] , [reference]..[shift_end_datetime]) ww fab_lot_extraction..fab_lot_hist flh inner join      traveler..trav_step ts on flh.trav_step_oid = ts.trav_step_oid inner join      traveler..traveler trav on ts.trav_oid = trav.trav_oid inner join      traveler..step step on ts.step_oid = step.step_oid inner join      traveler..step_data_for_fab sdfab on ts.step_oid = sdfab.step_oid inner join      reference..mfg_area area on sdfab.mfg_area_oid = area.mfg_area_oid inner join      reference..fp_step s on step.step_oid = s.step_oid left outer join      reference..fp_part_in_part_group part on flh.part_type_code =  part.part_code left outer join      reference..fp_part_group pg on part.part_group_oid =  pg.part_group_oid , pg.mfg_facility_oid = 0x990fee36400a9854      flh.[tracked_out_datetime] >= '20140405 19:000:0' , flh.[tracked_out_datetime] < '20140406 19:000:0'      , flh.target_lot_sw = 'y'     , flh.step_deleted_sw <> 'y'     , step_name '%photo eng dispo%' order     3

according comments, answered question, looks had bad reference in between clause:

where [tracked_out_datetime] between [reference]..[shift_begin_datetime] , [reference]..[shift_end_datetime]

specifically this:

[reference]..[shift_begin_datetime]

the convention referring column looks this:

[database].[schema].[table].[column]

and can shorten default schema:

[database]..[table].[column]

so, believe query thought referencing tables , not actual column. answer mentioned in comments aliases table , have correct column references.

,(select a.[mfg_ww_no] reference.dbo.ww_shift [tracked_out_datetime] between a.[shift_begin_datetime] , a.[shift_end_datetime]) ww

Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more