I need to convert a date type (2017-11-27 for example) to a Julian date.
I have seen several exampl…
2 years, 9 months ago
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…
2 years, 10 months ago
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
hi,Here is the delete syntax but it is not working even though all the conditions satisfy. What is …
By: Jeff Moden
Hello. I have two tables with a one to many relationship. The Master Table is named Stores an…
By: Sean Lange
I have 3 tables. employee , division and empDivMap.
The employee table is the master tab…
By: Thom A
I am adapting the below code and i understand what it is doing with the exception of the d, I…
By: Matt Miller (4)
I have a date column below RunDate , I want to create two column StartDate and EndDate like this St…
I have two tables and I want to delete records from one table for which there is no matching record…
Viewing 15 topics - 1,126 through 1,140 (of 1,144 total)
You must be logged in to create new topics.