SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• SQL Help - Beginner 2*

  Hello, I'm back again with another problem.   I ran this through a syntax checker and I got no…

  jimbob524

  2 replies

  4 years, 12 months ago

  By: Lowell

• SQL Help Beginner

  Hello,   I don't know if this is a place to ask for help, if it isn't, please point me in the …

  jimbob524

  2 replies

  4 years, 12 months ago

  By: jimbob524

• SSIS Package calling a rest api with JSON outpu

  Hello forum.  I'm having to query some ESRI rest api and returning some JSON output.  I have the li…

  HildaJ

  3 replies

  4 years, 12 months ago

  By: HildaJ

• Issues with SQL Trigger

  I have created a SQL Trigger as below. create trigger testtrigger on testdb for insert as declare …

  n.subbuu

  15 replies

  4 years, 12 months ago

  By: Jeff Moden

• Export to text file for specific row inserted

  I am looking for a solution to export the sql rows to a text file in a path when the database inser…

  n.subbuu

  1 replies

  5 years ago

  By: pietlinden

• Silly SQL Question

  I'm sure there's a simple way to do this, but I can't seem to figure it out.  I have data something…

  EsquireDeveloper

  7 replies

  5 years ago

  By: Jeff Moden

• Weird non-deterministic outcome from Stored Procedure.

  I work as a developer in a manufacturing company.  We use Jitterbit to manipulate complex XML from …

  edwardwill

  5 replies

  5 years ago

  By: edwardwill

• SSIS Variables can't be NULL, so how to pass NULL to sproc in Execute SQL Task?

  This one has me flummoxed.   SSIS variables are not capable of holding a NULL value, so it seems se…

  sgmunson

  3 replies

  5 years ago

  By: sgmunson

• SSIS Expression Task - Can you set the value of a NON-Boolean variable?

  From what I've seen online in various Google searches, folks have repeatedly claimed to be able to …

  sgmunson

  2 replies

  5 years ago

  By: sgmunson

• SSIS Expression Task - Does it even work?

  Okay, so I gave up on setting a string variable... and now I'm trying to just set a value for a Boo…

  sgmunson

  4 replies

  5 years ago

  By: sgmunson

• Update many records to a date next week based on a Numeric Day Value

  I need to run a stored procedure that will update all records date field (meetingDate) to the follo…

  netguykb

  11 replies

  5 years ago

  By: Jeff Moden

• find group of time

  hi all, i have the follwing table : 10 lines i want to show only row after 30 second (should be par…

  sharon-472085

  13 replies

  5 years ago

  By: Jason A. Long

• How to CAST() the value column in a dynamic unpivot

  I have a set of data that has multiple different data types including one field that is a nvarchar(…

  Nelson B

  7 replies

  5 years ago

  By: Sergiy

• SSIS - Flat File Connection - Programatically change the connection manager?

  Hi folks! I'm wondering if it's possible within an SSIS package to use the incoming package variabl…

  sgmunson

  14 replies

  5 years ago

  By: Jeffrey Williams

• Duplicate rows when selecting from multiple Phone numbers

  I have a query that is intended to select a single alternate phone number from a record (There can …

  Paul Stasny

  3 replies

  5 years ago

  By: Paul Stasny