Topics
Started by
Posts
Last post
I have a stored procedure that has a calculation the looks like this: [Total Minutes] = SUM(CONVERT…
2 replies
This is a weird one. We were sure we had it working before we changed the sizes of the data types, …
19 replies
Hello, This capture is a part of my database : orders and orders_done have the same structure, same…
2 replies
Hello, I have this string : 2017-06-08 16:00:00 as a function paramater. I want to get …
4 replies
I have several reports that follow the same structure as below, some of which get quite lengthy and…
12 replies
I am working on a project where I have created a Linked Server to a Progress database. The project …
8 replies
In the sql code below, I'm trying to understand why @idMin is NULL and not equal to 0. I'm pr…
8 replies
How would I write past15.past_15, ,past30.past_30,past60.past_60, ,tot.t…
1 replies
I need to dynamically search a folder on a local drive and load the file names into a string and th…
6 replies
I have a view that I need to expand upon but not sure how to do it. Below I have a successfully run…
4 replies
I wanted to change the code in the below if statement to more like sql code. Can I simplify i…
8 replies
create table ##TestTable ( IncidentId int, File_date date, ScheduleTime time, ExceutedTime tim…
29 replies
Hello Everyone, I have a raw table with Billions of records. I have a look up table with around 100…
2 replies
I've always wondered why you can't use datediff with two dates that are in int format. When I run s…
7 replies
I have two queries the first one is for the header information and the second is for the recor…
3 replies
Viewing 15 topics - 1,186 through 1,200 (of 4,984 total)
You must be logged in to create new topics.