Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Administration |
| Cannot connect to SSRS from SSMS - Hello, I just install SSRS 2017 Reporting Service and have configure Report Server from Report Server Configuration Manager. Report Server Status is Started, mode is Native. I have setup all necessary setting like Service account, Web Service URL, Database, and Web Portal URL. I can access Web portal URL from my browser, but […] |
| SQL Server 2017 - Development |
| Convert Access IIF with Switch in MSACCESS to SQL Server - I am in the process of converting an access query to T-SQL. There is an IIf statement which I am having trouble translating. SUM (LOTOSMIS_ACC_TYPE.sing_ind * LOTOSMIS_RET_DAILY.grs_amn * iif( gm_cd in (1105, 2123, 2124, 2150, 2152, 2191, 2192, 5143, 5145, 5146, 5245, 5253 ), switch(LOTOSMIS_RET_DAILY.gm_var=1, 0, TRUE, 1), 0)) AS RegSales What I gave tried […] |
| How to calculate future CostPrice value based on two other columns please... - Hello All Good Evening, Can you please help with this Issue --- Sample Data Begins Create Table #SampleData (DriverMon DATE, CostPrice Numeric, CurrentPercentage int, MonthtobeConsider Date,expensetype varchar2(20), LessorID int) Insert Into #SampleData Values(TO_DATE('01/01/2021', 'DD/MM/YYYY'),150,4,TO_DATE('19/10/2017', 'DD/MM/YYYY'), 'Lease', '4343') Insert Into #SampleData Values(TO_DATE('01/02/2021', 'DD/MM/YYYY'),120,4,TO_DATE('19/10/2017', 'DD/MM/YYYY'), 'Lease', '4343') Insert Into #SampleData Values(TO_DATE('01/03/2021', 'DD/MM/YYYY'),110,4,TO_DATE('19/10/2017', 'DD/MM/YYYY'), 'Lease', '4343') Insert Into […] |
| smtp in store procedure - vDear Team, it is regarding store procedure query for sending an email. i am unable to find the smtp codes like we used to do earlier. could you someone assist me how to smtp confuguration in it ac USE [msdb] GO /****** Object: StoredProcedure [dbo].[sp_send_dbmail] Script Date: 19/08/2020 12:33:29 ******/ SET ANSI_NULLS ON GO SET […] |
| SQL Server 2016 - Administration |
| CDC Setup wrapper functions - missing column __$command_id - Running SQL 2016 Standard SP2 CU14 (the most recent version) I see a lot about this issue and best i can tell its just a bug that Microsoft isn't going to fix. It seems there are different opinions of what to do. The wrapper function creates scripts for other functions that will return change data […] |
| SQL Server 2016 - Development and T-SQL |
| What am I doing wrong? OR with AND logic - I need help with my where clause. The criteria below works except source_ID '100' keeps showing up in my data. Basically I have 2 OR's and 1 AND. What is the best way to use these together? Im sure I must be doing this incorrectly. FROM table1 WHERE (APPLE_IND = 1 OR GRAPES_IND = 1) […] |
| Administration - SQL Server 2014 |
| AG recovery following disaster - Hi All. I'm looking for suggestions on the best way to recover from a disaster. Setup is an AG (asynchronous commit) on a two node cluster (one production, one DR). Forced failover with data loss following abrupt unplanned outage at production data centre. Have been in DR with production unavailable for a week. Lots of […] |
| SQL Server 2019 - Administration |
| Explanation of SQL Code - hi, can someone help me what does this code mean/do step by step. thank you so much, i understand the basics but what are the two dotes and the first line select distinct left(a.unq_id_src_stm,13) partija_13,a.unq_id_src_stm, b.cl_val_id into #t1 from tez_bdw_tut..sor_pd_ar a join TEZ_BDW_TUT..sor_ar_x_cl b on a.PD_AR_ID = b.AR_ID where b.cl_scm_id = 63 and 20200806 between […] |
| Error 1105 filegroup full - Hello community, I currently emptying ndf file to other ndf files (with SSMS) and I get the error 1105 filegroup full for that particular database I am working on. But if I check the filegroup and the other ndf/mdf files there's plenty of enough space left. So I can't figure out which filegroup is full. […] |
| Data transfer from sqlserver to Oracle - Hi , Source : SQL Server Table ; Destination : Oracle Table What is the best way to schedule the data transfer when new record inserted in source(sql server table). Thank you for your suggestions. Thanks. |
| SQL Server 2019 - Development |
| In Both Tables, In Table #1 But Not Table #2, In Table #2 But Not Table#1 - I've two tables and each has a key set. Each table has a user first name and a user last name and a 'key' which is lastname + firstname. I know that isn't ideal, but given the underlying data, that is the best that can be done. I'd like to show a report that shows […] |
| SQL Azure - Administration |
| Azure Loadbalancers - This is more of a quick question. So Setting up Availability groups cross region in Azure. all of the networking is in place, the VNET Peers, etc. My question is about the load balancers. In the past, I have only ever provisioned 1 ag group cross-region and therefore 1 x Standard Azure Load balancer […] |
| Reporting Services |
| lookup do not bring both amount from one account - 0 Votes"0 Ysa8989-0610 asked · 0 secs agoActions Lookup do not bring amount Hello There I have to datasets one for expenses and one for revenues, it is partially working because the lookup is bringing one amount only it should be bring all amount sitting there. Therefore I am out balance. The money is sitting there but my […] |
| SSRS 2014 |
| Setting Start Date - I have a parameter in my report to put the sunday date in of the current week =DATEADD("d" ,7-DATEPART(DateInterval.WeekDay,Today(),FirstDayOfWeek.Monday),Today()) so for this week would put the date as 23/08/2020 I need to set a start date that puts in the Monday Date from 11 weeks ago based on the end of week date above so […] |
| SSDT |
| redirect row on truncation - I kind of have this working, but for my test row, it did not output to the file. It is at least creating the files. So employeenumber is nvarchar(15) example data is 123456@mysub.ourdomain.us what gets inserted is the first 15 123456@mysub.ou I have this set for the table: I do have a couple of […] |
