Topics
Started by
Posts
Last post
Morning, Hope you can set me straight. on this left join problem I'm having. I have a left Join to …
4 replies
I'm trying to figure out what the best way to calculate the number of days between two dates, but I…
11 replies
not looking for solution just maybe some ideas. This is from 3rd party vendor (i helped some with …
4 replies
Hi I have got a business need where a user can execute a proc but if there are any DML commands in …
9 replies
My post is bit long. Please bear with me. Thanks. I have requirement where I need to transfer data …
2 replies
I have four parameters, any of which may or may not contain a value (they may also all be NULL). Th…
5 replies
Given the availability of collected data, I'm trying to combine multiple date fields into an Inform…
7 replies
I'd like to re-write SELECT below without using function. It returns 19544 records. SELECT dbo.Func…
14 replies
Hi, In my sql server database, there is table called Ticket_NUM and there are few fields like Ticke…
12 replies
Hi all I need help with writing a SQLstatement for an Arithmetic expression (Division) by joining t…
1 replies
Is there another way of getting a list of tables that all contain the same 3 column names without u…
4 replies
Dears, I need some ideas about how to export from 2-3 sql server tables ( filled with app mess…
5 replies
Hi All, Happy new year 2020. It been long time I am here. There is a job running for me daily @ 4 A…
1 replies
I am subtracting two columns (_REG_READING- START_REG_READING) and want to match the output (Actual…
2 replies
WITH T1 (ID1, ID2) AS ( SELECT 1,1 UNION ALL SELECT 1,1 UNION ALL SELECT 1,1 UNION ALL SELECT 1,2 )…
2 replies
Viewing 15 topics - 1,096 through 1,110 (of 3,091 total)
You must be logged in to create new topics.