Topics
Started by
Posts
Last post
Dear All I am trying to transfer some data from an old database to a new database, however I am get…
2 replies
Hello Does anyone know how I can calculate the % value of a result set. e.g. I table that consist …
5 replies
Hi, Please help me to find out solution of following requirement. I have two table 1) Student with…
1 replies
Hi. I was just wondering if someone could give me some advice on the best way to do following I ha…
1 replies
Hello, I have got 2computed columns. select * from table followed by condition as memotype1 I want …
1 replies
I m using SQL server 2005, i want to apply a trigger after insert, update that will update a tinyin…
3 replies
Hi All, I have a problem in T-Sql , I Want to See Top 3rd Positional Value in a Table not Top Three…
2 replies
There are many articles says that small table you probably don't need any indexes because the exeuc…
2 replies
Hi how do you determine if a table exists before creating it? If it exists I want to drop it. I tri…
5 replies
Ok so I have three tables that have the following scheme and am having trouble figuring out how to …
3 replies
OK this is weird... I have a simple two part UNION query. When I run each query separately I get 4…
1 replies
I have a S.P. written like this create proc my_sp @p1 varchar (20) = 'Default', @p2 v…
4 replies
Working on a stored proceedure that will select a random row in the table, update it as "won" and a…
8 replies
I think I'm encountering a fundamental gap in my understanding of index fragmentation, and I'm hopi…
4 replies
/* I have SQL that identifys overlaps in employee assignments and places the overlapped rows into t…
9 replies
Viewing 15 topics - 8,851 through 8,865 (of 12,230 total)
You must be logged in to create new topics.