Topics
Started by
Posts
Last post
Hi! I have a stored procedure with parameters, and I wonder if there is any way of using SELECT wit…
1 replies
Hi guys and gals, I'm tearing my hair out (or rather, what little's left, being follically challeng…
3 replies
We have a developer who is running a cursor and storing the results into a varchar(8000) variable, …
4 replies
Write the query to create table by copying the contents from another table
2 replies
I am having trouble adding two money values. Currently, I'm trying to accomplish the following: SEL…
3 replies
What is the best way to update 2 tables if a condition in one of the tables is met? What I wa…
2 replies
CREATE table Table1 ( Col1 varchar(100), Col2 varchar(100), Col3 v…
6 replies
I have the following query to get the duplicate AccountNames; SELECT AccountName FROM Account GROUP…
2 replies
Does anyone know if it's possible to use a variable with a USE statement? ie: declare @dbname…
4 replies
I have a total of 2 tables that are involved in this query. tblAdmissionSummary: holds unique …
4 replies
I have a table where I have two columns name and date. Sample data is hown below. Name …
8 replies
Does anyone know how to write a UNION in Oracle? TIA I wasn't born stupid - I had to study.
7 replies
Hi there, I need a sql query to get the next or previous sequential id where status >= 1 or status
4 replies
Hi I have the following SQL in a stored procedure to return all records with date values between tw…
23 replies
hi, simplified form- i have a table (table1) which contains 4 fields (Gid,Pid,Value,Cat…
12 replies
Viewing 15 topics - 9,466 through 9,480 (of 17,082 total)
You must be logged in to create new topics.