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.