SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Extract/export embedded files from binary in SQL 2017 Standard

  Hi Everyone ! If I run SELECT * FROM [QPulse5Training].[dbo].[RevisionAttachmentItem] I get a gener…

  Xunil

  10 replies

  3 years, 3 months ago

  By: mjhytre

• Best practice to store - How many days, minute and second ?

  Hi, I plan to create HelpDesk Database. One of the table will store - Response Time & Resolutio…

  Adelia

  21 replies

  3 years, 3 months ago

  By: kuopaz

• Truncate vs Delete for Bulk Removal of (some not all ) records

  EDIT : the table is not 1gb its 1tb 🙁   Hi I have a table with 351,495,000 records (about 1…

  simon_s

  11 replies

  3 years, 3 months ago

  By: Jeff Moden

• how to solve parse error?

  here is my code for parse data but here I have error like this 'StoreSurvey' has fewer columns than…

  saskee

  1 replies

  3 years, 3 months ago

  By: Site Owners

• Calculate HR

  Please assist me? I would like to calculate:my code: SELECT * from [dbo]. where LeaveTypeName Not …

  yrstruly

  3 replies

  3 years, 3 months ago

  By: aaron.reese

• Distinct Count

  I am using the following code for distinct count, seem to give me the same number for count and dis…

  yrstruly

  3 replies

  3 years, 3 months ago

  By: ktflash

• How is TableAlias in the MergeSpecification class in ScriptDom to be understood?

  Hello, everyone am currently learning Microsoft.SqlServer.TransactSql.ScriptDom. Have already imple…

  frank.kress

  2 replies

  3 years, 4 months ago

  By: topsmartservices

• arabic digits stored in varchar column with Arabic_* collation

  Hello, FYI Database collation is Arabic_100_CS_AS Why do Arabic characters in a varchar column (c…

  Mark T.

  3 replies

  3 years, 4 months ago

  By: stevenb 14609

• Creating appropriate data type from varchar(max)

  This is something I am thinking someone may have done already. Basically we have data loader which …

  dva2007

  4 replies

  3 years, 4 months ago

  By: MMartin1

• Need help on T-SQL

  I've table and data as script below, CREATE TABLE [dbo].[ClientProjects]( [Id] [int] IDENTITY(1,1) …

  Adelia

  2 replies

  3 years, 4 months ago

  By: Adelia

• replace chain of function calls with better code

  We have a scalar function that is used to add a specific number of business days to a date however …

  david_h_edmonds

  14 replies

  3 years, 4 months ago

  By: ScottPletcher

• Inline Table

  Please assist creating an inline Table Valued Function. Output  https://drive.google.com/file/d/1…

  yrstruly

  2 replies

  3 years, 5 months ago

  By: frederico_fonseca

• Inline Table

  Please assist creating an inline Table Valued Function. Output should look like this: https://drive…

  yrstruly

  18 replies

  3 years, 5 months ago

  By: Jonathan AC Roberts

• Insert missing records for each month/year with the previous month's value

  I have a sample data, see below. Sample data The base rules are If the same CustomerID and Account…

  sxzhu

  5 replies

  3 years, 5 months ago

  By: koko365

• Reading data with MSDASQL/OPENROWSET - periods in the filename

  Hi all, I ran into an issue this morning to read the data using OPENROWSET I was able to read the f…

  murthyvs

  1 replies

  3 years, 5 months ago

  By: murthyvs