I love the way they have put MS SQL Server on linux - however I am looking for a GUI, like SSMS…
1 year, 10 months ago
By: Thom A
"string or binary data would be truncated. the statement has been terminated"
This is a very co…
This was brought up in the automate everything article, so I figured I start a new thread on the to…
1 year, 11 months ago
By: Steve Jones - SSC Editor
I have a SP which gives the me the report of 12 months. I have a query in WHILE LOOP …
I want to execute a .sql script within a stored procedure but I want to do it without enabling …
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…
2 years 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.
2 years, 1 month ago
I'm hoping someone can help with this please.I need to join the 2 below case statements into…
Dear Community,An application that validates user accounts, using assemblies, IIS, etc. works fine.…
Viewing 15 topics - 46 through 60 (of 4,292 total)
You must be logged in to create new topics.