Topics
Started by
Posts
Last post
Hi All, I would like to get the logical/physical model of a database. I have been asked to analyze …
7 replies
Hello, I have to integrate two applications, I have to read, from my sql Server, a xml file in a we…
12 replies
By: amy3672
Hello, I'm trying to compare 1 table to another that contains extra info that I need. IE Table 1 h…
2 replies
how to delete the duplicate records from a table? like Item is a table and its columns are Item(IID…
17 replies
Hello, I am trying to write a DDL script that will create database objects. In Oracle you can ins…
8 replies
By: GSquared
This burned me when declaring a table variable inside a loop and the table kept getting bigger and …
4 replies
I have the following tables: Tbl1 (sid int, cid int) Tbl2 (oid int, tnum varchar(10)) Tbl3 (rec_i…
7 replies
How can I have the select statement return both products (10 and 20) in the select statement as two…
2 replies
Writing my first trigger. Can anyone verify or fix if I am missing anything? Many thanks in advance…
34 replies
By: Garadin
Ok, here's my issue I need to import an xml file into SQL, I tested everything out using Bulk Inser…
21 replies
Hi, My table structure is as below.I want to get rid of NULL values by a Non Null values available …
8 replies
By: sumi.mcp
Hi, I have a query which display result from one table ticket_history. My requirement is that I sho…
4 replies
Dont know if am having a bad day, but I'm trying to work out a way of join the two tables attached …
3 replies
By: J39L4753
Hello all I am coding a report and i need some help. I hope i can explain this right. i have pulled…
4 replies
Hi, I have the following piece of sql in a Stored procedure SELECT * FROM Table1 WHERE (@State = 1 …
4 replies
Viewing 15 topics - 4,636 through 4,650 (of 12,234 total)
You must be logged in to create new topics.