Topics
Started by
Posts
Last post
How do you get your case statement to test for a NULL? SELECT CASE WHEN data1 = NULL OR data2 = NUL…
3 replies
DECLARE cur_ProdHistMstr CURSOR FORWARD_ONLY FOR SELECT convert(datetime,absdate) as absDate …
9 replies
I know my description is not clear but I will try to explain and give the tables and data so hopefu…
8 replies
Hi, We have an ERP which is being used by a school. I have a requirement where there is a page in w…
1 replies
I need a trigger on insert Example for insert trigger: MasterIp studentstat …
4 replies
Hello experts, Please help me to rewrite this ugly query Its work properly but looks like overweigh…
4 replies
Hi, I hope someone can help. I have a legacy report to amend. The report needs a start date and an…
7 replies
Dear Sir, I have written a trigger which includes three action insert,update,delete when i insert a…
2 replies
hi i'm trying to create a pivot of sales by sku, month using the following... SELECTTrnYear, Cust…
3 replies
Hi, I have a task to complete that involves running a series of tests (mostly text comparisons) aga…
4 replies
How do I remove the time portion from my date/time results? SELECT CAST(FLOOR(CAST(EecDateOfLastH…
6 replies
Can't wrap my head around this one. Not sure which is the best way to handle the logic, in t-sql o…
7 replies
Hi, i have a table with following structure TableA OldId int, NewId int select * from tableA; O…
2 replies
I have this statement and want to update the a.upn_id with the value of b.upn_id SELECT * FROM PS_…
1 replies
hi i'my building an sql string in access through some list box selections. the end result is a wher…
8 replies
Viewing 15 topics - 1,051 through 1,065 (of 12,234 total)
You must be logged in to create new topics.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy