SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  8 months, 1 weeks 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

  8 months, 1 weeks 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

  8 months, 1 weeks 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

  8 months, 2 weeks 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

  8 months, 2 weeks 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

  8 months, 3 weeks 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

  8 months, 3 weeks 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

  8 months, 3 weeks 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

  8 months, 3 weeks 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

  8 months, 4 weeks 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

  9 months ago

  By: water490

• How to convert this to datetime format?

  hi everyone I have a CSV that is storing date as "20180919T201400+0000".  I am using BULK INSERT to…

  water490

  2 replies

  9 months ago

  By: water490

• telephones and sql

  hi im pretty sure i could trigger a page on a pager if i had to from t-sql. but triggering a phone …

  stan

  5 replies

  9 months ago

  By: stan

• average duration increasing inline with exec counts

  As the title says , I've got a handful of stored procs where the avg duration rises and falls prett…

  simon_s

  1 replies

  9 months ago

  By: Site Owners

• can ssrs detect rls and cls thru proxy like user ids?

  Hi we often use non expiring windows and sql accounts to actually run (credential wise) ssrs report…

  stan

  1 replies

  9 months, 1 weeks ago

  By: Site Owners