Topics
Started by
Posts
Last post
I trying to use following OPENROWSET to select a bunch of rows from a DB2 table: SELECT a.* FROM OP…
3 replies
Hi, I need help with the following: Here's the sample of the two tables . I want to update column B…
4 replies
Good Morning All, I a trying to create a stored procedure that I need to pass a list of value…
8 replies
I've got a few horizontally partioned tables. They're partitioned by month, so they look some…
8 replies
I am writing a program that store the following information in a table. Item e.g 1.1, 1.2, 1.2.1,&n…
18 replies
im trying to update many columns in the one update statement, but i keep getting an error. here is …
5 replies
I need to make activity report like below: CUSTOMER : mr. X description amo…
2 replies
i had a load of duplicate rows in a table. i have selected them all out to a temp table. i then del…
8 replies
Hi all, I have three tables: Table: Week WeekID (int) WeekNum (int) WeekPlannedWork (decimal) Table…
9 replies
Hi, everybody I want to create a table name but the table's name must use a parameter for ex…
6 replies
I want to prevent a column in a table from being updated once it has a value. The column has a bit …
6 replies
Hello, I would like to create a stored procedure in which I can give a tablename as a variable. For…
4 replies
Ok, run this... SELECT * FROM dbo.fnListSplit('a,b,c,d,e,f', ',') ---------------------------------…
7 replies
Hi all, I have an address column in database, and I need to output this address column…
2 replies
Hi All: I need to update a table and not sure what is the best way to do this. see SQL below: upda…
1 replies
Viewing 15 topics - 6,961 through 6,975 (of 17,082 total)
You must be logged in to create new topics.