Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Development |
How to get Two averages when the Number is defined as nvarchar ? - Hi experts, Sorry for not getting you a table or data at this moment but I will if I need to get help tomorrow How do I get Average of Cost 2. Average cost of Home Dept vs Overall Average Cost (Example: Home Department) Average Selling Prices of Each dept against over all selling price […] |
Starting a beginner SQL server job - Need books, resources, ideas to learn - Could someone please give me some advice regarding SQLserver and SQL in general? I have some experience, but it was too long ago and I need to freshen up. Books, links, ideas, concepts that need to be known not to get fired the first day. Thank you. |
SQL Server 2016 - Administration |
SQL Agent Job - Hello, One of the full back up job failed and it was triggered again. The DB's size is big so it takes couple of hrs to complete. My questions is ....if the running job does not finish before the scheduled time when it starts...will it fail or stop current run? Is there a way […] |
Read previous days transaction log .trn - Is there a utility or script that I can see the Transactions that happened in a Trn log backup file (.trn). I would like to see what transactions and tables where updated in the Backup log. Thanks. |
SQL Server 2016 - Development and T-SQL |
units divided by quantity and order by date - Hi Expert, I am facing challanges for logic to apply all previous units sold divided by next or nearest dates quantity here is the query Create table ratio1 (UNIT1 int,CONS integer,SaleDateId date,consumables integer) insert ratio1 values (4444444,222,'20210407',10), (4444444,333,'20210407',15), (4444444,444,'20210407',24), (4444444,555,'20210407',24), (4444444,777,'20210412',10), (4444444,888,'20210414',16), (4444444,999,'20210414',20), (4444444,000,'20210421',10) ========================================= create table main ( oid int, UNIT1 int,SaleDateId date, quantity […] |
Development - SQL Server 2014 |
List Dates between Start and End Date - Hi I have a very simple query as below select Personid, StartDate, endDate from table where startdate >= '01-feb-21' Example Data 223, 01-Feb-22, 04-Feb-22 354, 21,Feb-22, 22-Feb-22 I want to display it now as follows, so listing the days between the startdate and enddate for each personid Data would be as follows 223, 01-Feb-22 223, […] |
SQL Server 2019 - Administration |
Problem with Secure Enclave attestation - Hi all, long time lurker, first time posting. Looking for some help with an error I am seeing with our Always Encrypted with Secure Enclaves setup. In our production environment when our user load increases during the day I am seeing exceptions as follows: Failed to create enclave session as attestation server is busy. We […] |
SQL Server 2019 - Development |
Automatically output Extended Events data to table - Hi there, I was wondering if/how I would be able to output the results of an Extended Events session to a database table, either in real time or on a regular schedule. I have seen it suggested that the ring buffer could be used as a target, then that could be queried regularly and copied […] |
Merge into a subset of the target - I have a table with a column named JDX that I wish to merge into and I want to limit the merge considerations to the set where JDX is 180. I reduced the fields being updated for brevity. It works on the "matched " and "not matched by Source" by adding "and jdx = 180" […] |
Remove values between single quotes. - Hi So Ive got a SQL trace uploaded into a table and I 'm looking at the ad-hoc calls, I want to summarize them and remove any values from the calls e.g instead of select id,jobcode from table where id = '1' and jobcode in ('s','l') I want to be left with select id,jobcode […] |
Extract date from a text field - I'm trying to extract date from a text field. I'm using PADINDEX to do this. My results are very inconsistent. Is there anyway I can do this through SQL. I don't have an application to do this for me. I am trying to get this for a report that is needed. The text field has […] |
Merging sql and excel - I’m trying to merge sql data and excel data to an excel spreadsheet. Is there a way to do this? |
General Cloud Computing Questions |
What exactly is cloud computing? - Is this idea that I have correct: Cloud computing is a place in some company that is offering cloud computing where it has some servers there that are shared among applications that are subscribed to this cloud. For example BAAS, uses cloud computing where the company example google offers some services like push notification/storage/database instead […] |
General |
what is a good web dev project for a beginner? - So my questions is what is a project for a beginner like me who knows python (very well), C and C++ (comfortable with it), algorithms and datastructuresbut knows nothing about JS HTML CSS and databases. I saw that common suggestion is to create a blog but it seems kind of boring (tho I will start […] |
SQLServerCentral.com Website Issues |
Airline posts?!? - What's the deal w/ the sudden spate of airline spam posts? Any way to block these systematically? |