How to use values from one table as column names in a new Table in SQL SERVER? Problem Description: I have a table that looks like this: EmployeeName City Maria Chicago John Chicago Anna LA Peter LA Carrie NYC And I need to create a table that will look like this: Chicago LA NYC Maria … Read more
Can I use a combination of SUBSTR() and CHARINDEX() to return a particular line in a body of text? Problem Description: I am writing a T-SQL function that returns an account number from a block of text. The text is generated by the system, and has 3 colons so I need to try to find … Read more
Can I use a combination of SUBSTR() and CHARINDEX() to return a particular line in a body of text? Problem Description: I am writing a T-SQL function that returns an account number from a block of text. The text is generated by the system, and has 3 colons so I need to try to find … Read more
Can I use a combination of SUBSTR() and CHARINDEX() to return a particular line in a body of text? Problem Description: I am writing a T-SQL function that returns an account number from a block of text. The text is generated by the system, and has 3 colons so I need to try to find … Read more
Can I use a combination of SUBSTR() and CHARINDEX() to return a particular line in a body of text? Problem Description: I am writing a T-SQL function that returns an account number from a block of text. The text is generated by the system, and has 3 colons so I need to try to find … Read more
Insert into temporary table from select returns blank table Problem Description: I’m trying to fill two temporary tables with ids coming from outside as a single string that I split and save to a third temporary table: CREATE TABLE #TempProdotti (Id int NULL); CREATE TABLE #TempProdottiAggregati (Id int NULL); CREATE TABLE #TempCorsiSingoli (Id int NULL); … Read more
How to STRING_SPLIT where there are too many commagules? Problem Description: I have a question about the STRING_SPLIT. I need to separate phrases inside a String, separated by comma. The problem is that some of these phrases have around them, more commas. This is an example: Archiviazione, 2. Conservazione in archivi**,** ad accesso selezionato, 3. … Read more
MERGE statement to update or insert rows into a table Problem Description: My task is to insert or update rows in a table2. Table1 contains id’s of all employees. That id matches the ID in the table2. Some of the employees in table2 already have the rows I need but some don’t. Table2 doesn’t contain … Read more
MERGE statement to update or insert rows into a table Problem Description: My task is to insert or update rows in a table2. Table1 contains id’s of all employees. That id matches the ID in the table2. Some of the employees in table2 already have the rows I need but some don’t. Table2 doesn’t contain … Read more
MERGE statement to update or insert rows into a table Problem Description: My task is to insert or update rows in a table2. Table1 contains id’s of all employees. That id matches the ID in the table2. Some of the employees in table2 already have the rows I need but some don’t. Table2 doesn’t contain … Read more