Topics
Started by
Posts
Last post
I have a table - TrnDate, TrnYear, TrnMonth, StockCode, InvoiceQty The TrnYear and TrnMonth are th…
12 replies
Hi everyone. I've got to figure out whose games scores changed the least over time. I've created DD…
5 replies
Hi , What would be the best way to dynamically self join a table to create the example contained wi…
1 replies
Hi, I would like some help with my first inline table valued function, I have to create one that bu…
13 replies
I have an index occupying almost 77 GB space on the drive which is 70 percent fragmented. I am tryi…
1 replies
i have created a view in MYSQL which is imported into SQL Server. The originating MYSQL table colum…
3 replies
Can anybody recommend a good online guide to SQL commands? Or at least a list of the ones I should…
14 replies
We have a table in which we want to know whether any of the columns has unique constraint defined. …
6 replies
currently i am undertaking msbi course.. will it be a added value to my resume in which direction i…
7 replies
Hi, I am confused with a query that: SELECT STNNo FROM table1 where VoucherBookletNo = 'VVB0000021'…
8 replies
I'm struggling with following issues that I would like to see if it can be resolved using SQL Queri…
4 replies
I have to write a trigger that stores old values in an audit table, I have managed to write the tri…
5 replies
(Bear with me, I have Googled this first, and done a search here! I've followed the Troubleshooting…
3 replies
I create trigger after insert into table i want send mail on outlook and example trigger please. th…
16 replies
INSERT INTO ACC_JVDTL_TRN ( FINYRTRN_ID, VRDT, LEDGER_ID, AMOUNT) VALUES ((select i.FINYRTRN_ID fro…
8 replies
Viewing 15 topics - 1,621 through 1,635 (of 5,050 total)
You must be logged in to create new topics.