Hi ! i'm new in this forum so i say you hello asking help with a function ahahI have to update my t…
2 years, 7 months ago
I would like to restructure this query in a different way to use OPENQUERY instead but …
By: Lynn Pettis
Hi,I have an insert command saved to a table in a database "after insert" the trigger take the inse…
Lets say I have a database of an hospital.so.. i got a table with 2 columns: patients_ID ,tr…
I would like to get below 3 raw as result.
12 67 6010…
I have recently upgraded to VS/SSDT2017 and I am missing intellisense/colors for the script view of…
I need to convert a date type (2017-11-27 for example) to a Julian date.
I have seen several exampl…
Hi Guys,I am using the below which does the following. Show the data for the current month&nb…
So, the basics of what I want to accomplish is simple...I have a stored procedure that has some rea…
Currently trialing SQL Prompt Pro 9 in Visual Studio 2017.
Anyone know if there is a way to apply t…
By: Thomas Rushton
Hi everyone, I'm a NooB at SQL XML creation so hoping you can help me out here.
I have a query like…
By: Eirikur Eiriksson
We have a few fairly large databases in production (about 2TB each) that i would like to con…
By: Gail Shaw
Guys, is there a way for me to show the results of the below where there is a distinct Q.REGN…
By: jcelko212 32090
,SUM (CASE WHEN Q2.CSISeqNo = 185 AND A.Description = 'Loan Cars - C&D's Not Suitable' AND Q.An…
By: Scott Coleman
I have the following temp table listed below.In the interface we created the user has the optio…
By: Michael L John
Viewing 15 topics - 1,081 through 1,095 (of 1,105 total)
You must be logged in to create new topics.