Topics
Started by
Posts
Last post
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
hi friends, i am writing simple query as below. select count(total) as total, monthname, type, stan…
1 replies
Hello everyone. Can anyone provide some assistance. We have 2 tables, one is the customer table, an…
8 replies
Hi all, OK, I should know this to be honest, but after reading up on the web on loads of different …
6 replies
I am trying to backup a table to a different database on the same server. Using "Select Into" works…
7 replies
Viewing 15 topics - 9,466 through 9,480 (of 12,230 total)
You must be logged in to create new topics.