SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• parsing log data

  hi everyone, i have case to parsing the log data like this on sql server { "Name": "David", "Gende…

  David7777

  11 replies

  7 years, 9 months ago

  By: sgmunson

• Trying to find the minimum date for 1st fuel and non fuel transaction

  Hi all, I have been struggling with this query for a while now. I am trying to bring back A.Account…

  sindykp

  7 replies

  7 years, 9 months ago

  By: drew.allen

• SQL Database Documentation

  We have a situation where the Lead SQL Developer is leaving the company and he says there's no docu…

  Charles_P

  8 replies

  7 years, 9 months ago

  By: aaron.reese

• Design the tables to consolidate the kafka messages

  Hi All, I have below scenario: 2 DBs: DB1 and DB2 which will later replace DB1.…

  ankit.satyam

  2 replies

  7 years, 9 months ago

  By: sgmunson

• Joining dates to calculate payment month dates

  Hi I need some help and new to SQL and this forum.Please advise.I have a scenario if an employee jo…

  traj0130

  3 replies

  7 years, 9 months ago

  By: Jeff Moden

• Simple Query?

  I found this in anther forum and thought it would be a simple query, but I'm drawing a complete bla…

  Mike01

  4 replies

  7 years, 9 months ago

  By: Mike01

• Finding levels in a hierarchy

  i have some data which has a variable amount of hiearchy levels to it, DAX has a function called Pa…

  vee van gelder

  20 replies

  7 years, 9 months ago

  By: Jeff Moden

• Assistance with DATETIME calculation when comparing to VARCHAR column (Test code included)

  Hello, so I'm trying to get the difference in MINUTES between two columns.One column is a DATETIME …

  cor_dog2

  12 replies

  7 years, 9 months ago

  By: MMartin1

• OLEDB and Attunity both are slow with CLOB IN SSIS

  Hi Guys I need you help again I am using Auutinit drivers to extract the data from Oracle Table. On…

  learningsqlkid

  3 replies

  7 years, 9 months ago

  By: frederico_fonseca

• Writing a Complex View

  I'm working on combining the latest record from a number of tables to create one view with the most…

  yoyodynedata

  5 replies

  7 years, 9 months ago

  By: yoyodynedata

• Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

  Can this stored procedure be modified to work properly?  When trying to save, SQL Server retur…

  cchapel

  3 replies

  7 years, 9 months ago

  By: sgmunson

• SQL to write a condition to qualify Members with consecutive days of stay in same and different hotels

  I have hotel A and hotel B. A Member should not earn multiple Credits if a reservation is booked a…

  sanket.wagh7689

  6 replies

  7 years, 9 months ago

  By: drew.allen

• Insert in the Insert statement the previous value from the before value

  CREATE TABLE [dbo].[dt](    [dtVal] [datetime] NOT NULL,    [dtV…

  GG_BI_GG

  6 replies

  7 years, 9 months ago

  By: GG_BI_GG

• I need solution for this problem

  Hi All,I need a solution for this problem please help me First Create table like below querycreate …

  tvrarundeepak

  15 replies

  7 years, 9 months ago

  By: tvrarundeepak

• Automate daily table backup

  Hi,i have task is assigned to take the table backup daily wise.below is the formattablename_yymmdd …

  Diyas

  15 replies

  7 years, 10 months ago

  By: Jeff Moden