Questions tagged [pubs]
10 questions
12
votes
4 answers
Error while publishing in R pubs
When I am trying to publish my work in R Pubs I am getting an error:
Error in function (type, msg, asError = TRUE) :
SSL certificate problem, verify that the CA cert is OK. Details:
error:14090086:SSL…
Panchacookie
- 427
- 1
- 6
- 22
2
votes
2 answers
is there a common example SQL schema that shows all the major cardinalities?
I'm writing up documentation for a tool that works with SQL schemas. It would make sense for the documentation to use a common example schema rather than making up a new one. Any recommendations for one that's already defined somewhere?
Ideally it…
Colin Kelley
- 169
- 1
- 6
1
vote
1 answer
SUBJECT: LEAK: ByteBuf.release() was not called before it's garbage-collected
We are running a simple GCP Pubsub publisher that makes use of the Java Spring library (pubSubTemplate):
pubSubTemplate.publish(topic, message);
When sending lots of messages (about a million with a small payload of 6 primitive fields) The following…
artsgard
- 11
- 1
- 4
1
vote
1 answer
SQL query the store that have more than one title on the order for pubs database
In the pubs database I want to find out stores that have orders with more than one title on the order. I have joined the table but the logic to apply to find the order which have more than one title I can't understand
SELECT
title,…
Jennifer
- 9
- 4
1
vote
1 answer
Query to Stored Procedure
I have been trying to learn using the Pubs database. I have been trying to figure out how to create a stored procedure to create a profitability column.
The current code I have is this.
SELECT DISTINCT pub_id, ((price * ytd_sales) - advance / 100 *…
user3908836
- 13
- 3
0
votes
2 answers
sql databases Northwinds , pubs , AdventureWorks or some others?
Technology : Microsoft SQL Server 2008
Aim : Master SQL Server 2008 using Microsoft's databases
I am looking for a tutorial where I get a lot of exercises to do, so that I can master SQL Server 2008. Isn't it a good idea to choose Microsoft's…
Rauf
- 12,326
- 20
- 77
- 126
0
votes
1 answer
Can We Run The Flutter Project offline on server instead of using The Internet connection?
Instead of taking internet connection from the server and run the flutter PROJECT ONLINE ON SERVER which works fine ,INTENTIONALLY I WANT TO RUN MY FLUTTER PROJECT OFFINE ON THE SERVER WHICH IS NOT WORKING .
FOR OFFLINE:
I downloaded the packages…
Tahseen Abass
- 1
- 1
0
votes
1 answer
SQL query for stor_name in pubs database
For pubs I want to add a stor_name from the stores table into a query but its not working.
The query is:
SELECT
title, COALESCE(SUM(S.qty * T.price), 0) totalsale
FROM
titles T
LEFT JOIN
sales S ON (S.title_id = T.title_id)
GROUP BY
…
Jennifer
- 9
- 4
0
votes
2 answers
Sql query the store that has best sell quality in pubs sample database
In pubs database, I want to query the store in which has highest sales quality.
I exec following query,
select stores.stor_id, sum(sales.qty) as sumqty
from stores
join sales on stores.stor_id = sales.stor_id
group by stores.stor_id,…
KyL
- 987
- 12
- 24
-1
votes
1 answer
sql query for pubs database
If I want to get multiple author in single for each title in pubs database. Is it possible using pivot?
the table are joined with this query
SELECT CONCAT(a.au_fname,', ',a.au_lname) AS AUTHOR_NAME,
t.title
FROM titleauthor AS c
join…
Jennifer
- 9
- 4