SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• AD, powershell and ssis

  Hi, i have a requirement that involves visiting multiple folders in AD for active, disabled etc com…

  stan

  2 replies

  8 months, 2 weeks ago

  By: stan

• Help with parent/child query please

  Hi everyone, Trying to get this data to the following format but I can't seem to group it properly.…

  Mr. Holio

  6 replies

  8 months, 3 weeks ago

  By: Mr. Holio

• Temp table security

  So, I have an interesting situation that I need a double-check on. One of my coworkers (who is no l…

  Brandie Tarvin

  3 replies

  8 months, 3 weeks ago

  By: Brandie Tarvin

• SQL Query to use in MS SSRS server to give you your report structure.

  Code that can be used in order to create dashboard or SSRS report on report statuses based on Repor…

  wolfsvein

  2 replies

  8 months, 3 weeks ago

  By: Jeff Moden

• Remote query is taking 99% cost of local sp execution

  So we have local sp in which remote table is udpated.this remote query part is 99% of cost of all s…

  anoop.mig29

  6 replies

  8 months, 3 weeks ago

  By: anoop.mig29

• Using ROW_NUMBER() to increment every time a value occurs

  Hello folks, I have some rather unstructured data coming into a staging column from a file. I can g…

  Chrissy321

  10 replies

  9 months ago

  By: Jeff Moden

• how to keep report from running automatically when my params all default to null

  Hi I'm standing up a report with 9 visible cascading params , none of which needs to be entered.   …

  stan

  2 replies

  9 months ago

  By: stan

• standard deviation function doesnt seem to be behaving like an aggregate

  hi i have 6 statistical populations in my overall data set.  They run across 21 data points.  No ma…

  stan

  4 replies

  9 months ago

  By: stan

• Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date

  I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model', L.…

  gski

  2 replies

  9 months ago

  By: ScottPletcher

• Remote query is taking 99% cost of local sp execution

  So we have local sp in which remote table is udpated.this remote query part is 99% of cost of all s…

  anoop.mig29

  2 replies

  9 months ago

  By: Steve Jones - SSC Editor

• Join 2 tables

  Table A ServerName ColB ServerA C ServerA I ServerA L ServerA M Ser…

  mtz676

  3 replies

  9 months, 1 week ago

  By: mtz676

• Impact of Not Including Foreign Keys in an SQL Archive Database

  Hello everyone, I am about to start a data archiving project that will affect almost all tables in …

  abdalah.mehdoini

  1 replies

  9 months, 1 week ago

  By: Grant Fritchey

• how to fix this error?

  hi I am creating a stored procedure to reduce log size when needed.  I want to explicitly state whi…

  water490

  2 replies

  9 months, 1 week ago

  By: water490

• dont see a file system task approach to copying excel

  Hi , rather than the approach at https://stackoverflow.com/questions/68314594/copy-an-excel-sheet-a…

  stan

  2 replies

  9 months, 1 week ago

  By: stan

• need community help on 1 final cdata odbc driver product eval question

  Hi, for whatever reason,  CDATA is conflicted about answering 1 remaining disclosure type question …

  stan

  2 replies

  9 months, 1 week ago

  By: stan