Topics
Started by
Posts
Last post
Hi I am sorry if someone has already posted this question and am asking again. This problem is eat…
8 replies
Dear all., I need your hellp on this.. i have a table screen_optional_field & scree…
3 replies
When joining two tables I know I can use either: 1) a JOIN statement such as INNER JOIN or, 2) have…
9 replies
How do I display sample records (let's say 3 items ordered) on the last order for each buyer? Thank…
7 replies
Thanks everyone who responded to my previous question! Turned out that I misunderstood the task and…
7 replies
Hi All, I can't seem to figure out what should be a fairly easy query. Any help would be appreciate…
2 replies
My company's primary business is the management of residential housing and our primary application …
2 replies
What is the different this queries ? update table1 set table1.a = table2.b from table2 where table…
2 replies
before i write some awful case statements or multiple UDFs, is there any direct way to determine if…
27 replies
I am working on doing a proximity search and the concept is simple to an extent. right now, i hav…
5 replies
CREATE TABLE BUYERS (buyer_id bigint, order_id bigint, item_id bigint) INSERT INTO BUYERS VALUES (…
11 replies
I have 3 enviroments (dev, test, prod) we creates stored procedures to generate reports using Cryst…
4 replies
Hi I need to make a list of the views, tables, functions, triggers of a databases How can I do tha…
1 replies
I'm developing a 'busy' view with a several datetime and string conversions. I don't mind cut-n-pa…
2 replies
Hi All, I have a query, all code below, which works but I am convinced there is a better way. If yo…
1 replies
Viewing 15 topics - 9,466 through 9,480 (of 12,234 total)
You must be logged in to create new topics.