SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• trigger blues no primary key

  I'm converting a database to sql server from sql anywhere.   The tables use a trigger to …

  fizzleme

  5 replies

  5 years, 4 months ago

  By: Jeff Moden

• SQL Query to Calculate Monthly Budget

  CREATE TABLE [dbo].[EmployeeMonthlyBudget]([Name] [nvarchar](50) NULL,[Budget_Day] [money] NULL,[Da…

  madanvenkat535 3293

  7 replies

  5 years, 4 months ago

  By: madanvenkat535 3293

• Parent/Child - where I am standing

  In parent child, I want to pass EmployeeId and get the list of all parents from tree till given Emp…

  shamshad.ali

  19 replies

  5 years, 4 months ago

  By: Lynn Pettis

• How to Use group By to calculate totals

  Please, I need your kind help. I have the below three tables, and I want to calculate the total amo…

  sami Jafaar

  13 replies

  5 years, 4 months ago

  By: pietlinden

• Validate date stored as a string as a complete, valid date

  I have an upstream table where birth_date is stored as a string, YYYYMMMDD.  The data is very …

  Scott In Sydney

  12 replies

  5 years, 4 months ago

  By: Jeff Moden

• Best Practice for batch processing In SQL Server

  Hello,  I have a general question regarding best practices for creating a batch process in SQL…

  Miru Seshadri

  5 replies

  5 years, 4 months ago

  By: Jeff Moden

• Help with creating a parameterized Stored Procedure which takes Server Name, DB Name and Table Name and gets metadata from information_schema

  Hello All,I needed help with the below query. I was trying to create a parameterized proc that …

  Nexana

  1 replies

  5 years, 4 months ago

  By: Mike01

• how to select each row 500 records(with comma separate values string) from table in sql server 2016

  Hi All,               My table have a 10000 recor…

  polo.csit

  4 replies

  5 years, 4 months ago

  By: polo.csit

• Create JSON message in T-sql

  Hi All,   I need help to create a Json message using T-sql , If any Here is my Requi…

  kaladharreddy15

  2 replies

  5 years, 4 months ago

  By: Eirikur Eiriksson

• query to check count in last 30 min interval

  I am trying to set up job - first it retrieves the count if records for that day in the last 30&nbs…

  mcfarlandparkway

  2 replies

  5 years, 4 months ago

  By: Steve Jones - SSC Editor

• The requested OLE DB provider Microsoft.ACE.OLEDB.16.0 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode.

  I created a package last week. Source was excel and dest. was SQL Server. I also changed the 'Run64…

  LearningDBA

  9 replies

  5 years, 4 months ago

  By: frederico_fonseca

• If condition when running SSIS package on the secondary server which is part of AG

  I have 2 servers which are part of AG. On the primary server, we have some agent jobs (around …

  LearningDBA

  4 replies

  5 years, 4 months ago

  By: x

• dealing with Bulk load data conversion error

  Hi  we have process that load formatted log files into table  file size 200-300 MB a…

  ebooklub

  6 replies

  5 years, 4 months ago

  By: Jeff Moden

• Transforming "xml" field to pivot-like results

  My apologies for bad formatting and perhaps not posting all that I need to - first-time poster, her…

  ms.user.0

  3 replies

  5 years, 4 months ago

  By: drew.allen

• Set @rptStartDate = CASE WHEN 'TransactionCount' = 2 Then '11/1/2018' - 30 days Else '11/1/2018' End

  Hello again! The issue I am having today is dealing with a date change when certain conditions are …

  gQuery

  17 replies

  5 years, 4 months ago

  By: x