Small Test Of PHIL 1150

we have a requirement to alter one of the current process of data loading suing Linked server to use Merge statements to load data faster and to compare the time to load as well

I need you to develop some software for me. I would like this software to be developed for Windows.

Hello, I'm using SQL Server 2019 in a C# project. I have 2 tables: [Quizzes] ID uniqueidentifier CreationDate datetime Author nvarchar(50) [Questions] ID uniqueidentifier QuizID uniqueidentifier Text nvarchar(MAX) I could make a query like this to get the results (I need to list all quizzes with their questions) in a normal way: SELECT * FROM Quizzes LEFT JOIN Questions ON Quizzes.ID = Questions.QuizID The problem is that I need to convert all questions to json array and return them as…

Create report from sql db - rdl for SSRS

We need person strong experience in SQL,SSIS and SSRS. We are looking for person to work in long term.

Interview call support on Transact SQL, SSIS, SSRS, Power BI

We need help changing and adding code in one of our projects. today we already have a team working, but we need help with some tasks to make sure to be finished on time. The work will mainly be coding Stored Procedures in MSSQL or writing tasks for SSIS steps. The first task will be writing a procedure to verify data integrity using checksum to veryfi that data is the same on both the source and destination. We are only…

Hey, my names hamza I am a language teacher I have the pleasure to share my experience with you, for information I am a teacher of French and Russian language and also Arabic.

we need some help in building SSRS reports and embedded it on .net Application in a week time.

create new report as flat SQL result or in crystal

We are trying to split the comma separated row values into multiple rows in sql server.But we already had a column named 'value' in our datatable.

Looking for an experienced sql developer who can work full time in EST hours

I'm looking for a skilled person who can help rewrite/refactor complex MSSQL queries

We require someone to assist with a large enterprise SQL project. There will be multiple ETL and SQL migrations required to be done over a 3 - 6 month period. You would need to have extensive and solid SQL experience.

I have SQL Table as below CREATE TABLE [dbo].[tempTable1]( [Director] [varchar](100) NULL, [Type] [varchar](100) NULL, [Project] [varchar](100) NULL, [Section] [varchar](100) NULL, [Contractor] [varchar](100) NULL, [Cost Client] [varchar](100) NULL, [ID] [varchar](100) NULL, [PCM] [varchar](100) NULL, [Program] [varchar](100) NULL, [Sr Manager] [varchar](100) NULL, [Name] [varchar](100) NULL ) ON [PRIMARY] GO INSERT [dbo].[tempTable1] ([Director], [Type], [Project], [Section], [Contractor], [Cost Client], [ID], [PCM], [Program], [Sr Manager], [Name]) VALUES (N'ghghjg', N'tyu', N'hkhjk', N'dd', N'gghgh', N'gghhg', N'123', N'gnhghj', N'qew', N'fghfgf', N'abc') GO INSERT [dbo].[tempTable1] ([Director], [Type],…