In Python pandas we can create a list of collected value when using aggregate. Eg. select id, list(names) group by id. <-- this will give names with same id. Is there anything equivalent in tsql?
I am using this code to send data of this form...but the data is not sent to the email,,,,but the code is running successfully but I am not getting data to the email...Need help...
This is one complete file of php..
<html>
<head>
<script src="js/login.js"></script>
<style>
label{display:inline...
I have this code:
DECLARE @MyTable AS TABLE
(
[Month] INT,
Salary INT
);
INSERT INTO @MyTable VALUES (1,2000), (1,3100);
SELECT [Month], Salary FROM @MyTable;
Output:
I want to concat the Salary (grouping by month) so that it will be NVARCHAR like this: '2000,3100'
How would I do t...
I have this code:
DECLARE @MyTable AS TABLE
(
[Month] INT,
Salary INT
);
INSERT INTO @MyTable VALUES (1,2000), (1,3100);
SELECT [Month], Salary FROM @MyTable;
Output:
I want to concat the Salary (grouping by month) so that it will be NVARCHAR like this: '2000,3100'
How would I do t...
