SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Graph DB edge tables

  I'm one of those people who insist on an INSERT statement showing an explicit list of column names …

  Jan Van der Eecken

  9 replies

  7 years ago

  By: Jan Van der Eecken

• Help with aggregate function

  have table:col1 col2 col3A       B    10B       A…

  ger_serrano

  19 replies

  7 years ago

  By: Jeff Moden

• INDEX MATCH IN SQL.... IS IT POSSIBLE??

  Mail – craig.jenkins@monmotors.com          &nb…

  craig.jenkins

  22 replies

  7 years ago

  By: drew.allen

• "CASE" function on t sql

  Hi ! I'm still here asking for your helpI need to create a stored procedure that takes for imput an…

  smokynightshadefrancesca

  3 replies

  7 years ago

  By: Ramesh Saive

• COUNT CASE WHEN

  Hi Guys, Can someone please help me get the results from query 1 into query 2 (IE a count case when…

  craig.jenkins

  5 replies

  7 years ago

  By: craig.jenkins

• INNER JOINs - Old vs New Style

  Can someone tell me if the DBMS treats old- and new-style INNER JOINs differently? I learnt the old…

  cthendy

  4 replies

  7 years ago

  By: DesNorton

• Calling stored procedures from within other stored procedures

  Hi folks, I heard something today that has me wondering:  Is it is a good idea to write a long…

  kevaburg

  6 replies

  7 years ago

  By: x

• DISTINCT FOR ONE COLUMN ONLY

  Guys,  how do i make the following only bring back one value for each REGNO? As you can see so…

  craig.jenkins

  10 replies

  7 years ago

  By: sgmunson

• FAST_FORWARD cursor slow for simple SELECT COUNT(*) because sp_cursorfetch() re-scans all index

  Hi all, We are using MS ODBC 13 (on Linux) to execute a simple SELECT COUNT(*) FROM table query...T…

  sf 49675

  7 replies

  7 years ago

  By: sf 49675

• Querry with results only from specific subnets?

  How can i do a querry that only shows results with a speciffic caller or callee subnet?This is from…

  alexander.holmeset

  1 replies

  7 years ago

  By: Steve Jones - SSC Editor

• update with random values

  Hi ! i'm new in this forum so i say you hello asking help with a function ahahI have to update my t…

  smokynightshadefrancesca

  1 replies

  7 years ago

  By: pietlinden

• View retructuring

  Hi experts, I would like to restructure this query in a different way to use OPENQUERY instead but …

  Feivel

  2 replies

  7 years ago

  By: Lynn Pettis

• Trggier not working with insert

  Hi,I have an insert command saved to a table in a database "after insert" the trigger take the inse…

  issam mansour

  1 replies

  7 years ago

  By: xDJR1875

• Query help

  Lets say I have a database of an hospital.so..  i got a table with 2 columns: patients_ID ,tr…

  ygrno93

  9 replies

  7 years ago

  By: Sergiy

• Join Help

  I would like to get below 3 raw as result. 12    67    6010…

  patla4u

  5 replies

  7 years ago

  By: Lynn Pettis