thank you very much now I have a clearer understanding May the best cheaters win
hello everyone about the sorting order in setting up new instances. if I was using the default one(case incensive etc) now we would like to...
thank you <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />May the best cheaters win
by the way I know how to detached and shrink manually but not auto setup May the best cheaters win
Hi We just upgrade to Sql 2005, how do I setup so that the transaction log should be committed at day end and clear up ? thanks May the best...
Solution for problem above. Just post so that if anyone needs. tested using QA in SQL2000 DECLARE @rating TABLE (compid Int, ratingname char(2),...
Thanks since we have 1000 rows updated everyday and may be there are only a few changes and about 10 columns and there will be more columns later...
Hi Andrian your return duplicate item eventhough order and dtlogg are unique because of inner join and joining identical table put distinct May...
try this <img src='/community/emoticons/emotion-1.gif' alt=':)' /> <br /><br />SELECT dbo.test.*<br />FROM dbo.test<br />WHERE...
The easier solution would be to record everyday change in value to T1 and T2 make them both column name in table Table 1 ID CompanyName 1 A 2 B...
it add a new entry therefore the latest date is the change in value from previous date D RatingName Value TimeStamp 1 T1 5 10/11/2006 1 T2 5...
replace tablename test with yours SELECT dbo.test.* FROM dbo.test WHERE (dt_logged = (SELECT...
I have two tables Table 1 ID CompanyName 1 A 2 B Table 2 <--this table only record the change in RatingName Value ID RatingName Value TimeStamp 1...
the only way split the tables into many is to use select and insert or update to the new table. Example<br />Tables<br />id c1 c2 c3 c4<br />1 a b...
can't picture what you want, you need table design ? give an example of data you want to put it May the best cheaters win
http://www.dotnetspider.com/technology/kbpages/706.aspx May the best cheaters win
Your question is too general. here is my company site i wrote .NET and SQL2000 www.newshoretrust.com. secure or not depend on the programmer. If...
Thanks alot I got it working yes that is what I want the queries. May the best cheaters win
Excellent it gives me the correct result. Thanks Another question is it possible to do a 90 days column as well by creating another table ? May...
ignore this done already May the best cheaters win
Separate names with a comma.
