Topics
Started by
Posts
Last post
I'm trying to build a query where: 1) one of the columns is a subquery 2) another (computed) column…
5 replies
hi, i am new to sql server 2005, i am currently doing my project by using sql server, in my project…
4 replies
Hi All, Can you Please help me in this topic? I executed the following Sql Script and Its working F…
3 replies
Hello, I need help to chose the winner for each sample base on Max(RDN), but remove winner ID from …
5 replies
I have a situation where I could use some help Here is the table structure cstid________point type_…
2 replies
Hi Guys This is my first post so I hope I get my query over to you all in a reasonable way. I’m try…
2 replies
I have an application in which I need to get a user's last login datetime. I don't know how to do t…
2 replies
I have a query where I am doing a select on three columns that have a DB defined varchar(50). I wa…
3 replies
HI There, i have a requirement of storing the language preference of the user in the database. does…
1 replies
Hello, I am currently reading a book on SQL2K5 which also covers CTEs. Originally I thought that CT…
9 replies
if object_id('tempdb..#tmpExample') is not null drop table #tmpExample create table #tmpExample (…
1 replies
Hi everybody, I found a heavily fragmented table so I ran alter index all on mytable but after it w…
6 replies
we have migrated from 2000 to 2005 .if i change the text column to varchar. rowsize goes over 10000…
1 replies
Hi All, I have been told to use [font="Courier New"]DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE SET S…
6 replies
Hello, I am trying to get the average time out of a datetime column. I am able to get the average …
10 replies
Viewing 15 topics - 11,416 through 11,430 (of 12,230 total)
You must be logged in to create new topics.