FR Posts - Answer Overflow

Posts Comments

CC#

•Created by FR on 7/3/2024 in #help

Unit Testing | Unsupported expression: ht => ht.LoadAll<ReasonType>()Non-overridable members

1 replies

CC#

•Created by FR on 7/1/2024 in #help

✅ SSRS | How To Upload Multiple RDL File to Report Server ?

Hello im try to migrate my reports to a new server, Firstly i tried to bulk download the report and it run very well with powershell script bellow

https://microsoft-bitools.blogspot.com/2018/09/ssrs-snack-download-all-ssrs-reports.html

But when i tried to find a powershell script for upload the report, it just really hard to find it i tried several script but all ended up with error, So i need help if somebody know and can tell me how to do it the right way? Ty ~

3 replies

CC#

•Created by FR on 8/23/2023 in #help

❔ Entity Framework, How To Join Second Table To Third Table In The First Table?

17 replies

CC#

•Created by FR on 12/23/2022 in #help

❔ SQL SERVER | SSRS | Dataset Column not Refresh When Using Stored Procedure with Parameter

3 replies

CC#

•Created by FR on 11/25/2022 in #help

❔ SQL Server | Count How Much Installment Paid and Left

12 replies

CC#

•Created by FR on 11/9/2022 in #help

❔ SQL Server | How to format column using BCP?

2 replies

CC#

•Created by FR on 10/21/2022 in #help

❔ SQL Server | Can i use 'Case When' in Where Clause?

i ususally do it by create the query into the string like this

set @sql = 'select * from person p .....'
set @where = ' where xxx = xxx'

IF @role <> 'ALL'
BEGIN
  SET @where= @where + ' AND p.role IN ('''+@ProductId+''')'
END

SET @query = @sql +  @where
EXECUTE(@query)

set @sql = 'select * from person p .....'
set @where = ' where xxx = xxx'

IF @role <> 'ALL'
BEGIN
  SET @where= @where + ' AND p.role IN ('''+@ProductId+''')'
END

SET @query = @sql +  @where
EXECUTE(@query)

but it realyyyy hard to debug if the query is very long, so anyone know the proper way to do it?

11 replies

Gaming

Programming