SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Error converting data type varchar to numeric

  issue resolved. This topic was modified 12 months ago by water490.

  water490

  2 replies

  11 months, 4 weeks ago

  By: Jeff Moden

• Two queries or one?

  The setup: 3 tables: core_users, core_roles, and core_user_roles.  core users is the "base" table, …

  Steve Collins

  3 replies

  11 months, 4 weeks ago

  By: Jeff Moden

• Random Execute SQL Task(s) keeps hanging when I try to run it in parallel

  Hi everyone I am trying to implement parallelism in my SSIS package.  There are about 20 SP in tota…

  water490

  3 replies

  1 year ago

  By: Ed B

• is the ssrs auto refresh without its faults

  Hi, i considered power bi with embedded for this.    Not a big fan of that plumbing. a peer of mine…

  stan

  3 replies

  1 year ago

  By: stan

• how to force SS to run certain SP in parallel?

  hi everyone I have a SP that is run in SSIS.  That particular SP is basically running a bunch of SP…

  water490

  5 replies

  1 year ago

  By: water490

• SSIS Package error when running through SQL Agent job

  Hi, Can someone please help me resolve below error. To run a SSIS package outside of SQL Server Dat…

  anshu.shikha

  11 replies

  1 year ago

  By: Phil Parkin

• problem with PIVOT Table

  Thanks in Advance! I'm having trouble grouping all counts and sums on one line for each county whic…

  DaveBriCam

  3 replies

  1 year ago

  By: Jeff Moden

• Iterative query to sum a colum relating to dates.

  Hi, I have a simple table with 5 columns as follows with about 80,000 rows, I wish to sum the Hours…

  Tallboy

  11 replies

  1 year ago

  By: Jeff Moden

• How to pass a variable in look up transformation in SSIS ? With Oracle database

  We have a need to pass a variable in the look up query against Oracle database using SSIS, is there…

  SKAK7102

  8 replies

  1 year ago

  By: Ed B

• Pivot Using SQL

  I need some help with pivot. For the following data set:   and produce an output like this:

  QQ-485619

  6 replies

  1 year ago

  By: QQ-485619

• best choice for index when creating a composite key

  hi everyone I am planning on adding a composite key for my tables.  I have SPs that are writing to …

  water490

  4 replies

  1 year ago

  By: water490

• dtexecui

  I have some IT peeps that will run an SSIS package manually from a location on the file system by r…

  Anita Lakhani

  10 replies

  1 year ago

  By: brad.melin@bcdtravel.com

• Operand data type varchar is invalid for sum operator

  I have this view [dbo].[Asset Metrics - Client(Rama -Client-Test)], which makes use of multiple tab…

  yrstruly

  5 replies

  1 year ago

  By: Johan Bijnens

• changing over to a tab delimited file in my pkg that walks thru folders

  hi, we just decided to change over to a tab delimited format in a handful of dw files coming our wa…

  stan

  5 replies

  1 year ago

  By: stan

• Best Approach to cutover from Test to Live with new columns and tables added

  We have a Production/Live version with up-to-date data and a Test version with older data where we …

  JP789

  2 replies

  1 year ago

  By: Phil Parkin