SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• 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 days, 17 hours 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

  3 days, 1 hour ago

  By: Ken McKelvey

• SSIS raw file conversion

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

  bokswager

  7 replies

  3 days, 13 hours ago

  By: frederico_fonseca

• 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

  3 days, 17 hours 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

  3 days, 17 hours 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

  6 days, 3 hours 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

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

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

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

  2 replies

  1 week, 3 days ago

  By: ratbak

• 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

  1 week, 5 days 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

  2 weeks ago

  By: Site Owners

• what etl tool are folks moving toward?

  Hi as we replace on prem machines , sometimes not with vm's, what should we be thinking about for e…

  stan

  30 replies

  2 weeks ago

  By: stan

• Find Duplicate Rows

  What’s the best way to find duplicate rows in a sql query? I heard there is a way where RC is used …

  JP789

  3 replies

  2 weeks, 1 day ago

  By: rothj

• Is there an ISERROR equivalent in SS?

  Hi everyone I have a SP that just failed.  Format of SP is: Select symbol, date, …

  water490

  4 replies

  2 weeks, 5 days ago

  By: Steve Collins