SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Help Writing a Udf that get Number of "Years in a row"

  Hello. I have a table (say orderlines) with orderrows,    There is a column that holds the "Year"  …

  Pucko

  2 replies

  4 years, 10 months ago

  By: ktflash

• Trying to get a arithmetic operation from an Variable

  Hi, I am not sure if this can be done, but I seem to remember there is some format thing that can b…

  itmasterw 60042

  6 replies

  4 years, 10 months ago

  By: Mr. Brian Gale

• Does T-SQL have a way of truncating real and float values?

  I'm working on a new app and database, which has real data types in some of the tables. Due to some…

  Rod at work

  7 replies

  4 years, 10 months ago

  By: Sergiy

• SQL_variant to varchar error

  DECLARE @Temptable TABLE ( TotalPhysicalMemory varchar(1000), MemoryValueinUse varchar(1000), MaxMe…

  mtz676

  4 replies

  4 years, 10 months ago

  By: ScottPletcher

• The File location can't be opened error occurs when try to open a FileTable path

  Hi Every one, I hope you doing good. I need your help here. I am new to SQL server filestreeam conc…

  manavairajan

  1 replies

  4 years, 10 months ago

  By: Mr. Brian Gale

• Determining whether a parameter has been established.

  I have a ssrs report with 6 parameters 4 or which are cascading and one parameter (pTimeZoneID) tha…

  csalerno

  1 replies

  4 years, 11 months ago

  By: Site Owners

• SQL remove part of String Question

  Hello All, I have a string something like below("inputstring" column) and i want to exclude part of…

  dhanekulakalyan

  2 replies

  4 years, 11 months ago

  By: dhanekulakalyan

• Adding columns in case statements

  SELECT CASE WHEN EXISTS ( SELECT name FROM msdb.dbo.sysjobs WHERE name = 'JobA' ) THEN 'Exists' ELS…

  mtz676

  2 replies

  4 years, 11 months ago

  By: mtz676

• Need help. Find matchng Substring

  Friends Bit confused query for me. Dunno how to ask correctly. I have two tables. One with only one…

  meelan

  4 replies

  4 years, 11 months ago

  By: Jeff Moden

• A real challenge and I need suggestions on efficient ways to solve it

  I have a need to determine the site of cancer given some complexities. Each cancer patient has up t…

  diana.bodell 56517

  11 replies

  4 years, 11 months ago

  By: diana.bodell 56517

• Un-queried tables

  Hi, Is there a way to know which tables from a DB are NOT being queried? Context : We do a lot of r…

  d_martins

  6 replies

  4 years, 11 months ago

  By: ScottPletcher

• Varchar to datetime

  Hi, How can I convert SCHEDSTART varchar(25)  '2020-06-07-12.30.00.00000'   to datetime  '2020-06-0…

  Unniarcha

  21 replies

  4 years, 11 months ago

  By: ZZartin

• SQL Select for 70 Million records

  Hi, We have two servers. Server A is source server which has  a table with 5 columns (2 int, 2varch…

  yuvipoy

  6 replies

  4 years, 11 months ago

  By: Phil Parkin

• Filling Missing Weekend Dates

  Hi and first time poster, so please be gentle! I have a table with the following sample data which …

  SqlRookie

  1 replies

  4 years, 11 months ago

  By: ratbak

• Stuck trying to create a date table that shows week numbers for financial years

  Hello All, Please can you help me with the following challenge: I need to create a date table to jo…

  scienceof8

  4 replies

  4 years, 11 months ago

  By: scienceof8