sql - Adding table in the stored procedure code -


i new sql. have stored procedure need add 2 columns of table "dbo.additionprojectdetails". here projectid primary key. below code snippet cant add whole here. help?

    select  pbd.proj_id, case when phase =1 'phase i' when phase=2 'phase ii'                     tasktype,area_name,projectname,os_name,ptcdd.remarks                       projectdetails (nolock) pbd                     inner join projecttestprocessdetails (nolock) ptpd on pbd.proj_id =ptpd.proj_id                     inner join projecttestcycledet (nolock) ptcd on ptcd.proj_id=pbd.proj_id                     inner join projecttestcycleduration (nolock) ptcdd on ptcdd.proj_id=pbd.proj_id                     inner join projecttestprocesscostdetails (nolock) ptpcd on ptpcd.proj_test_prepareid=ptpd.proj_test_prepareid                     inner join areamaster on am.area_id =pbd.areaid                     inner join projectmaster pm on pm.projectid =pbd.platformid                     inner join osmaster os on os.os_id =pbd.osid                      status in ('s','r','c') , tasktype,area_name,projectname,os_name,ptcdd.remarks group pbd.proj_id,pbd.created_by,pbd.created_on,status,taskgivendate                     order ptcd.taskenddate desc

check link here explaination of store procedure , details u want

insert results of stored procedure temporary table

t-sql how create tables dynamically in stored procedures?


-

Comments

Post a Comment

Popular posts from this blog

php - Permission denied. Laravel linux server -

when try register , send email user got error. working till yesterday. today gives me , cant figure out why. way on local testing work's. i'm stuck. please errorexception in compiled.php line 7512: file_put_contents(/var/www/html/storage/framework/views/53de219dee4f11a2db4f64a2c574ad02db5613f4.php): failed open stream: permission denied in compiled.php line 7512 @ handleexceptions->handleerror('2', 'file_put_contents(/var/www/html/storage/framework/views/53de219dee4f11a2db4f64a2c574ad02db5613f4.php): failed open stream: permission denied', '/var/www/html/bootstrap/cache/compiled.php', '7512', array('path' => '/var/www/html/storage/framework/views/53de219dee4f11a2db4f64a2c574ad02db5613f4.php', 'contents' => 'please activate account clicking on following link. <a href="<?php echo e(route('auth.activate', $token)); ?>"><?php echo e(route('auth.activate', $token)); ?
Read more

google bigquery - Delta between query execution time and Java query call to finish -

context our container cluster located @ us-east1-c we using following java library: google-cloud-bigquery, 0.9.2-beta our dataset has around 26m rows , represents ~10g all of our queries return less 100 rows grouping on specific column question we analyzed last 100 queries executed in bigquery, these executed in 2-3 seconds (we analyzed calling bq --format=prettyjson show -j jobid , end time - creation time). in our java logs though, of calls bigquery.query blocking 5-6 seconds (and 10 seconds not out of ordinary). explain systematic gap between query finish in bigquery cluster , results being available in java? know 5-6 seconds isn't astronomic, curious see if normal behaviour when using java bigquery cloud library. i didn't dig point analyzed outbound call using wireshark. our tests executed in our container cluster (kubernetes). code queryrequest request = queryrequest.newbuilder(sql) .setmaxwaittime(30000l) .setuselega
Read more

python - Pandas two dataframes multiplication? -

i have 2 data frames (a , b) a: column 1, column 2, column 3 0.1 0.5 0.7 b: row 1 5 row 2 6 row 3 7 how perform multiplication like (0.1)*5, (0.5)* 6, , (0.7)*7? in other words, how multiply value in first row of b value in first column of a, second row of b value in second column of b, , etc? you want multiply values without respect whether rows or columns. pd.series(a.values.ravel() * b.values.ravel()) 0 0.5 1 3.0 2 4.9 dtype: float64
Read more