SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• do i lose "what this object depends on" etc when moving sprocs to etl server

  Hi i was surprised to see the approach my coworkers used to sunset talend , a combo etl and job sch…

  stan

  0 replies

  5 hours, 38 minutes ago

  By: stan

• how to move all SP from one db to another db?

  Hi everyone I have two db - one is test and other is archive.  In the test db I have SP that begin …

  water490

  8 replies

  12 hours, 7 minutes ago

  By: DesNorton

• Report Table/view or SP in SQL to handle various reports

  I have an Access database with a SQL backend with tables, views, SP's. I have reports to run based …

  JP789

  2 replies

  5 days, 19 hours ago

  By: pietlinden

• is there a way to have a table sorted automatically?

  Hi Everyone I have one table that has a unique requirement to be sorted in order for the table to h…

  water490

  7 replies

  1 week, 5 days ago

  By: dmbaker

• BULK INSERT question

  Hi everyone I have a text file that I want to import into SS table.  I can import the file but the …

  water490

  9 replies

  1 week, 6 days ago

  By: water490

• Create League Standings use game data table with home and away on same line

  OK - very new to this so I apologize if this is obvious but I can't figure this one out. I'm lookin…

  legacyvbc

  8 replies

  2 weeks ago

  By: willamjack

• SUM([value]) and highest record type

  Given a record mapping table: Id Initial Updated 1 1 2 2 3 4 3 …

  Pete Bishop

  2 replies

  2 weeks, 1 day ago

  By: Steve Collins

• should i expect data types in task->export data from ssms?

  Hi i recently exported a number of "to be purged resultsets " to .tsv's.     this is a related link…

  stan

  1 replies

  2 weeks, 2 days ago

  By: stan

• cant that export task be scripted without ssis

  hi, i'm archiving some dw stuff to tsv's.   i got the manual sequence working where you pick tasks-…

  stan

  2 replies

  2 weeks, 4 days ago

  By: Mr. Brian Gale

• is there a reorg available in sql server?

  hi i have a 67 million row fact table that needs about 30 million rows deleted after they've been a…

  stan

  9 replies

  2 weeks, 4 days ago

  By: Mr. Brian Gale

• Is there a way to implement ROWS between logic?

  Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow for a rolling sum…

  water490

  14 replies

  2 weeks, 4 days ago

  By: Mr. Brian Gale

• SSRS: An error occurred during local report processing. The definition of ...

  Here's the complete error: An error occurred during local report processing. The definition of the …

  sgmunson

  3 replies

  2 weeks, 4 days ago

  By: Mr. Brian Gale

• SSIS raw file conversion

  Hi, Does anyone know how to handle a raw data file where some rows contain carriage return characte…

  bokswager

  9 replies

  2 weeks, 4 days ago

  By: sgmunson

• skipping the second line in a spreadsheet being read by ssis

  hi, my new user provided a new multi tab (sales, customer etc. not what i really wanted either) exc…

  stan

  3 replies

  3 weeks, 5 days ago

  By: stan

• Problem with CASE statement

  Hi Everyone I have used CASE many times but not sure what I am doing wrong here.  SS won't accept i…

  water490

  3 replies

  4 weeks ago

  By: EdVassie