Topics
Started by
Posts
Last post
Good Afternoon; Any chance I can do the following in T-SQL. I've done something similar, and as usu…
22 replies
By: SwePeso
How do I turn this statement into an UPDATE that updates COL5 when SUM(COL4)>5? COL4 cannot be in …
10 replies
Hi, need result for a full outer join on 4 tables with 1 identical id. select COALESCE…
1 replies
Dear all, I have the following problem: I currently have an overnight process (VB6 application) tha…
3 replies
By: andreask
how to check duplicate value on six fields - if exists- but not zero on " fld1+fld2+fld3+fld4…
9 replies
By: SwePeso
Knowing that the MAX() function eliminates NULLS before processing, I need to find a way to query a…
8 replies
Hi, I am working on this website. We currently have one forum, we are planning to add 6 more forums…
3 replies
Hi I've one table called 'Customer' and the columns are Cust_id Char(4), Photo IMAGE data type. I …
1 replies
Ok folks, I'm in over my head.. What I'm trying to do is get the next available item from a table …
2 replies
By: iwaldner
I have a table of 2000+ records that I need to divide up and call dynamically. I'm converting ever…
8 replies
I have an Access query that I would like to change into a SQL view (or stored proc - I'm not sure w…
4 replies
Hello, I have a problem where I'm trying to get a result set of distinct values based on one column…
5 replies
Is there a way in SQL to get the percentage of 2 columns? I tried using SELECT (col1/col2) AS per…
14 replies
Hi, I have table column with binary(8) data type that has hexadecimal value like 0x0000000000000162…
4 replies
By: vadba
I have a part that goes through a sequence of status's. I am looking to simplifiy my stored proced…
3 replies
Viewing 15 topics - 4,921 through 4,935 (of 17,082 total)
You must be logged in to create new topics.