SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• SUM and JOIN 2 columns with different tables but it duplicates results

  Good day! Need help re SUM and JOIN 2 columns with different tables but it duplicates results here'…

  glennyboy

  4 replies

  5 years ago

  By: glennyboy

• allocate / deallocate table

  I need to delete a lot of rows from some tables. There are millions of rows and only a few thousand…

  kaj

  10 replies

  5 years ago

  By: Cebisa

• Query to return the number of logical reads

  I have a procedure that is trying to pass in a table name and outputs #rows and #logical reads. cre…

  dbgaragedays

  7 replies

  5 years ago

  By: Jeff Moden

• Remove spaces from an unstructured Text field

  Hi Forumers, I've got a table with several Notes fields and I'm trying to remove ALL spaces from th…

  Oscar_Boots

  6 replies

  5 years ago

  By: Oscar_Boots

• Sum of column from multiplied columns

  I would like to get the sum of "Transaction Cost" as created from the multiplication of TxQty and A…

  nbeason

  8 replies

  5 years ago

  By: Phil Parkin

• LEGACY_CARDINALITY_ESTIMATION = ON and COMPATIBILITY_LEVEL

  Hi everyone, we migrated from sql 2012 to sql 2016 and since then we have been facing some performa…

  rohitkocharda

  3 replies

  5 years ago

  By: rohitkocharda

• Xpath query with cross apply help - almost got it

  The node that is used in the cross apply has multiple instances. The OTimes node has 2 children (OT…

  TangoVictor

  5 replies

  5 years ago

  By: TangoVictor

• need script that returns all the columns in a table that have data in them

  I need a query that will basically generate a select statement that will select all records for onl…

  Snargables

  12 replies

  5 years ago

  By: ScottPletcher

• Matching backslash in a table's column using R language

  Given the following code: CREATE TABLE [dbo].[products] ( [nvarchar](25)) INSERT INTO [dbo].[produc…

  Pete Bishop

  1 replies

  5 years ago

  By: Pete Bishop

• How to collapse data?

  closed This topic was modified 5 years ago by wallywizard.

  wallywizard

  4 replies

  5 years ago

  By: Eirikur Eiriksson

• Msg 319, Level 15, State 1, Line 2152 Incorrect syntax near the keyword 'with'.

  Forum, I'm trying to build a clustered index for the all the heap tables moving to a different FG i…

  JSB_89

  5 replies

  5 years ago

  By: Lynn Pettis

• What am I doing wrong? OR with AND logic

  I need help with my where clause. The criteria below works except source_ID '100' keeps showing up …

  wallywizard

  2 replies

  5 years ago

  By: ScottPletcher

• Create a user and restrict access to only one DB Object

  Hi, I have following requirement. I want to add one user  through Sql Server Logins under Security …

  RCRock

  3 replies

  5 years ago

  By: Grant Fritchey

• sql2016 - if column cell changes, insert value into another column cell

  How can I calculate or insert TrimWgt (17.15 from MasterRolls value =3) and (17.15 from MasterRolls…

  jayM

  11 replies

  5 years, 1 month ago

  By: Jeff Moden

• CONCATE_WS Not Recognizable

  I am trying to use the CONCATE_WS function in SQL Server 2016 but receive the following error.  Her…

  Anonymous

  5 replies

  5 years, 1 month ago

  By: Jeff Moden