Kirat

[Solved] Creating stored procedure getting Incorrect syntax near the keyword ‘Declare’

by

The @search should be an input parameter of the stored proc, (no Declare required), and you need an As between the signature block for the stored proc and the body of the proc. Create PROCEDURE [dbo].[usp_cloud_ClientAllSearch] @Search NVARCHAR(30) As SELECT client_Name, client_Surname, client_CompanyName, clientContact_TelephoneNo, clientContact_MobileNo, clientAddress_PostalCode FROM cloud_Client c Join dbo.cloud_ClientAddresses a ON a.client_ID = … Read more

[Solved] R subset based on range of dates [closed]

by

Are you asking something like the following? Let’s say your initial dataframe is df, which is the following: df A B C 1 2016-02-16 2016-03-21 2016-01-01 2 2016-07-07 2016-06-17 2016-01-31 3 2016-05-19 2016-09-10 2016-03-01 4 2016-01-14 2016-08-21 2016-04-01 5 2016-09-02 2016-06-15 2016-05-01 6 2016-05-09 2016-07-17 2016-05-31 7 2016-06-13 2016-06-23 2016-07-01 8 2016-09-17 2016-03-11 2016-07-31 9 … Read more

[Solved] How to display data in JOIN, and return null value? [closed]

by

Use LEFT JOIN: SELECT VA.COL_PERSONNEL_NUMBER, VA.COL_CLOCK_DATE, VA.P10, VA.P20, VR.NAME, VR.UNIT FROM VIEW_ABSEN VA LEFT JOIN VIEW_REPORT VR ON VA.COL_PERSONNEL_NUMBER=VR.ID AND VR.DATE=VA.COL_CLOCK_DATE WHERE VA.COL_PERSONNEL_NUMBER LIKE ‘%521663%’ AND VA.COL_CLOCK_DATE BETWEEN ‘2016-08-01’ AND ‘2016-08-05’ 1 solved How to display data in JOIN, and return null value? [closed]

[Solved] Variables and Assignment statements [closed]

by

Outside of the fact that you should probably be using an IDE to easily identify your mistakes…. Semi colon on main method, missing brackets, invalid variable types, etc. All you have is two arrays with one string value each. char stndCst[] = {“(sqftbrm + sqftdrm +sqfthal + sqftgrm + sqftstr)”/5}; char wtAvg[] = {“sqftbrm*bf” + … Read more

[Solved] Linear Probing. What is wrong with this program?

by

If you actually debug your code, you’d see that your loop exits prematurely, because 13 iterations won’t do it. Actually, your code cannot give the output you request, as written, no matter how you modify the loop condition. In order for your result to contain 73, this statement must execute, where j references the last … Read more

[Solved] calculating multi squares in one textbox in C# [closed]

by

Pass the Textbox Text into the function and It will Print all the SqureRoot of the Numbers private void squreRootFinder(string textBox) { string[] numbers = textBox.Split(‘\n’); string data = “”; for (int i = 0; i < numbers.Length; i++) { data += Math.Sqrt(Convert.ToInt32(numbers[i])) + ” “; } MessageBox.Show(data); } 2 solved calculating multi squares in … Read more

[Solved] BOT Framework Advantages of V4 over V3

by

From Amy’s link: Introduction of a bot adapter. The adapter is part of the activity processing stack. Refactored state management. A new Dialogs library. Support for ASP.NET Core. The central idea here is that v4 gives you more flexibility as a developer. The new state management system allows you to choose whether the dialog stack … Read more

[Solved] How to read, edit, merge and save all csv files from one folder?

by

This should be fairly easy with something like the csv library, if you don’t want to get into learning dataframes. import os import csv new_data = [] for filename in os.listdir(‘./csv_dir’): if filename.endswith(‘.csv’): with open(‘./csv_dir/’ + filename, mode=”r”) as curr_file: reader = csv.reader(curr_file, delimiter=”,”) for row in reader: new_data.append(row[2]) # Or whichever column you need … Read more

[Solved] Cannot implicitly convert type ‘object’ to ‘int’. An explicit conversion error exists

by

The first error is because of this: Array myPort;. That’s not how you declare an array, Array is an abstract class that provides methods to operate on arrays. SerialPort.GetPortNames() returns a string array so you can either declare a string array or just remove the Array myPort; declaration and replace the other line with var … Read more

[Solved] How to split int each two digits and insert into an array

by

const num = 112233445566; const numString = num.toString(); let numberArr = []; let tempArr = []; for (let i = 0; i < numString.length; i++) { tempArr.push(numString[i]); if (tempArr.length == 2) { numberArr.push(tempArr); tempArr = []; } } const numbers = numberArr.map(number => { return parseInt(number.join(“”)); }); solved How to split int each two digits … Read more

[Solved] About using namespace std in C++ [closed]

by

The definition of the namespace is imported when you write: #include <iostream> or #include <stdio.h> by writing using namespace std you don’t import the namespace, you allow using its entities without std prefix, like cout instead of std::cout solved About using namespace std in C++ [closed]