Using MS SQL Server

Help - Finding the newest date without using max()
Hi, Can anyone help please? select notefield, modifiedon FROM Table1 WHERE id = '100426' and (statusfield like '%criteria1%' OR statusfield like '%criteria2%') Produces a list of records based upon the criteria. I would like to be able to only show the newest dated record, from the modifiedon field. I... 18 Sep 2006 11:39

Flattening Parent Child, an issue, please help
Hello Experts, Here is the code to flatten a PC hierarchy into a level based table. It works fine. SELECT t1.TASK_ID AS TASK_LV1, t2.TASK_ID AS TASK_LV2, t3.TASK_ID AS TASK_LV3, t4.TASK_ID AS TASK_LV4, t5.TASK_ID AS TASK_LV5 FROM dbo.Project t1 LEFT OUTER JOIN dbo.Project t2 ON t... 26 Sep 2006 22:48

Best practice for storing long text fields
As we all know, there is a 8060 bytes size limit on SQL Server rows. I have a table which requires a number of text fields (5 or 6). Each of these text fields should support a max of 4000 characters. We currently store the data in varchar columns, which worked fine untill our appetite for text fields increased to t... 13 Sep 2006 18:13

delete sql server registration in tsql
Is there any way in tsql to delete a sql server registration? (I know how to do this from Enterprise Manager). Thanks! Jennifer ... 29 Aug 2006 17:41

Counting the occurence of a string ...
Hi ... I have a weblog database where I want to count the occurences of a table of string values that appear in all the urls viewed. My tblWebLog as a field that contains the url ... tblWebLog.[cs-uri-stem] I have another table ... tblStrings ... that has a field [strSearch] for a string value and an integer ... 27 Aug 2006 09:17

joins
hi dis is kalaivanan, which one of inner join or left join is efficient and in what way. ... 26 Aug 2006 06:48

Transaction log keeps growing
Hi, We have created a SQL server 2000 database. We observe that the transaction log keeps growing over time. We are now about to run out of space. We have been periodically shrinking the database. Nevertheless the size has increased. I would imagine that a transaction log can be eliminated if we stop the databas... 25 Aug 2006 07:58

Max Row Date
Hello, I am reposting this from another group, because I had no responses. I need to get the max row date from the following query. There is a date field in rcompl.date_time. There can be several rows identical except the date_time in which I need only the max of those rows. Thanks select rcompl.*,fastener_dat... 25 Aug 2006 01:54

SQL Server 2005 Opening Script File Problem
I just installed SQL Server 2005 on my PC (the developer's edition) yesterday. I have some scripts written by one of my coworkers to create some tables and stored procedures in a database that I've already created on my computer. Whenever I go to open the script file (whose icon shows that it's a SQL Server Query... 24 Aug 2006 03:57

how to add primary key in existing table
i have table fff .it has two fields one is fno int , another is fname varchar(20) fff fno fname -------- ----------- 100 suresh 102 ramesh here there is no not null constraint and identity column then i am add primary key constraint fno column pls help me ... 17 Aug 2006 18:44