SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Counting values with hysteresis in Report Builder

  Hi, I have a set of data (for instance sine wave) and I need to count, how many times have value re…

  UltraFan47

  2 replies

  6 months, 2 weeks ago

  By: UltraFan47

• Upgrading SSIS and SSRS from SQL Server 2016

  Hi All, I have plan to upgrade SSIS and SSRS from SQL Server 2016, but do not have idea for the tar…

  Deni Kusdeni

  1 replies

  6 months, 2 weeks ago

  By: Deni Kusdeni

• SQL server help (converting rows to columns)

  I am using the following sql to convert rows into columns for each pid, intdate. This works fine wh…

  don075

  3 replies

  6 months, 3 weeks ago

  By: Jeff Moden

• query help

  I need some help to optimize this query as it runs in many threads in an over night, and it pegs CP…

  Bruin

  13 replies

  6 months, 3 weeks ago

  By: Bruin

• How to merge two tables with unlike fields

  How to merge two tables with unlike fields. I have two table with one unlike field that I need to s…

  landonh

  3 replies

  7 months ago

  By: Phil Parkin

• strange selection for update

  Hi, yesterday I had to update several rows of a table. The rows for update where selected by a sele…

  joerg.kannengiesser

  11 replies

  7 months ago

  By: Jeffrey Williams

• Merge rows in SQL

  I have a table like below ID Ident source val opendate closedate IsActive ------------------…

  Neils

  6 replies

  7 months ago

  By: Ed B

• Review what columns are used

  I have a couple of databases   One would be regarded as the source and another as the destinat…

  DamianC

  2 replies

  7 months ago

  By: DamianC

• Nested Multi-Line Comments Q

  Is the below with nested multi-line comments valid T-SQL code? I thought no because it has nested M…

  YSLGuru

  4 replies

  7 months, 1 week ago

  By: JestersGrind

• ? on keeping a continues count grouped by month ???

  Hi All, Not sure why I'm hung up on this, but I am..... I have a table called "ClientCases" This ta…

  jbalbo

  4 replies

  7 months, 2 weeks ago

  By: Jeff Moden

• Getting all ancestral parents of a table

  From this link - https://stackoverflow.com/questions/22005698/how-to-find-all-the-dependencies-of-a…

  jaango123

  2 replies

  7 months, 2 weeks ago

  By: Jeff Moden

• Something Odd About CAST/TRY_CAST

  I've got some code that is supposed to generate a unique key by prefixing an integer with a single …

  Chris Wooding

  3 replies

  7 months, 2 weeks ago

  By: Jeffrey Williams

• how to query that stores mulit select field data

  Hi everyone, I have a table as below, I would like to strip out the commas in the oppo_SCRMcompetit…

  mathewspsimon

  4 replies

  7 months, 2 weeks ago

  By: mathewspsimon

• sqlclient data provider .net provider connection

  I have a task to check the connection managers as part of ssis integration project, now the package…

  jaango123

  5 replies

  7 months, 2 weeks ago

  By: Phil Parkin

• Help with index rebuild

  Hi there!  This should make some eyes roll for some of you DBA's out there.  Disclaimer:  I am not …

  dnison-905607

  3 replies

  7 months, 4 weeks ago

  By: EdVassie