Topics
Started by
Posts
Last post
I need to convert a date type (2017-11-27 for example) to a Julian date. I have seen several exampl…
4 replies
Hi Guys,I am using the below which does the following. Show the data for the current month&nb…
15 replies
So, the basics of what I want to accomplish is simple...I have a stored procedure that has some rea…
25 replies
Currently trialing SQL Prompt Pro 9 in Visual Studio 2017. Anyone know if there is a way to apply t…
3 replies
Hi everyone, I'm a NooB at SQL XML creation so hoping you can help me out here. I have a query like…
2 replies
Hi all We have a few fairly large databases in production (about 2TB each) that i would like to con…
1 replies
Guys, is there a way for me to show the results of the below where there is a distinct Q.REGN…
4 replies
,SUM (CASE WHEN Q2.CSISeqNo = 185 AND A.Description = 'Loan Cars - C&D's Not Suitable' AND Q.An…
3 replies
Hi, I have the following temp table listed below.In the interface we created the user has the optio…
20 replies
hi,Here is the delete syntax but it is not working even though all the conditions satisfy. What is …
25 replies
Hello. I have two tables with a one to many relationship. The Master Table is named Stores an…
3 replies
hello all, I have 3 tables. employee , division and empDivMap. The employee table is the master tab…
12 replies
Guys, I am adapting the below code and i understand what it is doing with the exception of the d, I…
3 replies
I have a date column below RunDate , I want to create two column StartDate and EndDate like this St…
26 replies
I have two tables and I want to delete records from one table for which there is no matching record…
14 replies
Viewing 15 topics - 1,126 through 1,140 (of 1,144 total)
You must be logged in to create new topics.