SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Cross-Tab & Concatenate Rows with a join : Help with a Query

  Hi, Can someone please help me with a query? I have two tables and I want the concatenate rows as a…

  sqlguru1day

  2 replies

  4 years ago

  By: sqlguru1day

• SQL Subqueries

  Hi ! i got a task where i am to post only the Reshnum of the Department with the highest count of a…

  beefycarrot

  5 replies

  4 years ago

  By: ScottPletcher

• Snowflake ODBC to SQL Ole Destination ERROR

  Hi there, everyone. We've create and SSIS package that gets data from a Snowflake database via an O…

  darkangelBDF

  3 replies

  4 years ago

  By: jeremy.davis

• Printing the Highest count

  i have a Problem in my code, the case is this. I need to count the amount of employees in all the d…

  beefycarrot

  4 replies

  4 years ago

  By: ScottPletcher

• table-valued functions, temp tables etc - when to use each one?

  Sorry for the dumb question, but given all the "things" that return tables... temp tables, table-va…

  pietlinden

  4 replies

  4 years ago

  By: pietlinden

• Set Cache Size of Sequence

  Hi, I've got the following version of SQL Server installed. Microsoft SQL Server 2016 (SP2-CU16) - …

  robh0502

  5 replies

  4 years ago

  By: frederico_fonseca

• xp_subdirs cannot access LAN location

  Hello, I have a problem with "xp_subdirs" inside a stored procedure that always has worked in the p…

  cpd_318

  2 replies

  4 years ago

  By: WHug

• Recursive CTE

  Hi everyone, I am working with a recursive CTE that loops through records. I have lead and lag vari…

  Scott745618

  8 replies

  4 years ago

  By: Jeff Moden

• SELECT DISTINCT but only on two columns...

  Hello: I have the following query... SELECT JobOperations.jmoJobID AS JobNo, JobAssemblies.jmaPartI…

  stephen.aa

  5 replies

  4 years ago

  By: stephen.aa

• VARBINARY

  create table test ( sort_path varbinary(4096), ); insert into test (sort_path) values (0x00000…

  djvn1

  2 replies

  4 years ago

  By: djvn1

• Geocoding in SQL Server - do I need C# for it?

  I've been digging around playing with spatial maps in SQL Server.  I've read a few articles on geoc…

  pietlinden

  5 replies

  4 years ago

  By: izhar-azati

• UDF could not be bound

  Hi everyone, I have created a sum UDF and I cannot call  it. The variable being called cannot be bo…

  Scott745618

  6 replies

  4 years ago

  By: Scott745618

• SQL Server on Linux over Docker connecting through MS ODBC

  I'm trying to connect SQL Server installed on a Linux server through Docker from a C++ application …

  N_Muller

  1 replies

  4 years ago

  By: Steve Jones - SSC Editor

• Wildcard and dealing with spaces

  Hello All, I am new to the SQL realm and at work I use SQL Studio. I have a question in regards to …

  Ctalley13

  4 replies

  4 years, 1 month ago

  By: ScottPletcher

• Incorrect syntax near the keyword 'AS'

  Hi Everyone. I'm hoping someone can take a look at my code here to see what I am missing. I'm tryin…

  basmster

  2 replies

  4 years, 1 month ago

  By: basmster