SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  7 hours, 4 minutes 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

  1 day, 11 hours 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 days, 12 hours 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 days, 12 hours 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 days, 12 hours 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 days, 14 hours 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 days, 15 hours 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

  1 week, 3 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

  1 week, 5 days ago

  By: EdVassie

• Window Functions in a View

  Is there a trick to get a where clause filter to push into a view that has window functions that do…

  Jackie Lowery

  3 replies

  2 weeks, 4 days ago

  By: Jackie Lowery

• Is there a way to exclude records from being loaded when using BULK INSERT?

  Hi everyone I have one record in the source CSV file that is not letting BULK INSERT load the file.…

  water490

  8 replies

  2 weeks, 4 days ago

  By: Ken McKelvey

• are the caching messages in ssis for a lookup an indication of poor performance?

  Hi, i am curious if i made the best choices for a lookup component in ssis.    my head is saying 2.…

  stan

  1 replies

  2 weeks, 5 days ago

  By: frederico_fonseca

• BULK INSERT messing up import of CSV file with a comma in it

  Hi everyone I am using BULK INSERT to load a CSV.  I have noticed a problem when a value has a comm…

  water490

  2 replies

  2 weeks, 5 days ago

  By: frederico_fonseca

• Users Default Schema in a stored procedure.

  One of our systems contains data for multiple organizations.  OrgA should not be able to see OrgB's…

  Michael L John

  1 replies

  3 weeks, 1 day ago

  By: Ed B

• Error converting data type varchar to float

  Hi everyone I have a bunch of CSV files that I need to import into SS using BULK INSERT.  One file …

  water490

  2 replies

  3 weeks, 2 days ago

  By: water490