I want to execute a .sql script within a stored procedure but I want to do it without enabling …
1 year, 6 months ago
By: Jeff Moden
What is the best way to automate the clearing out of an error message that pops up a few times a da…
1 year, 7 months ago
I am trying to export the contents a query into a ASCII file.
I need the character "LINE FEED" to b…
hello, below is my query, the query result is2 columns from2 different databases the columns "…
Hi,I have two tables:1) ZIPCodes- ZIPCodes table contains all the zipcodes of the USA with lat…
By: Lynn Pettis
I am trying to execute a Stored Procedure after two other jobs in the schedule have completed&…
Vitor da Fonseca
By: Vitor da Fonseca
SELECT id_product, SUM(COALESCE(received_qty, ordered_qty)) AS totalFROM (Select id_department,id_p…
By: Sean Lange
How can i accomplish this using case within select. Please see my sample below.
1 year, 8 months ago
I'm hoping someone can help with this please.I need to join the 2 below case statements into…
By: Thom A
Dear Community,An application that validates user accounts, using assemblies, IIS, etc. works fine.…
1 year, 9 months ago
I have a couple long (1000+ lines) queries in development. I tend to use a lot of CTEs, and throw i…
By: Luis Cazares
Each day I create a FULL backup of a database using:BACKUP DATABASE [utility] TO DISK = 'U:\Databa…
I have code in a stored procedure that is like this:
IF EXISTS(SELECT * FROM table_a WHERE …
By: gvoshol 73146
Does anyone have any experience with django and how it works with databases in development?
I am ge…
Viewing 15 topics - 46 through 60 (of 4,287 total)
You must be logged in to create new topics.