Recent content by sRockyHill

Hi, I am confused on these query, why I get different result? 883782 vs. 901223 Thanks -- Total COUNT Return - 883782 SELECT Count( Transaction_ID) FROM (SELECT DISTINCT Transact.Transaction_ID, convert(varchar(10), Date_RUN, 101) as Date_RUN, City_RUN, Gender_RUN, Age_RUN, Service_RUN...

Individual Index fields are Service_Run, Transaction_ID, Date_RUN No clustered index

Hi, This update query very slow to do a update, 12 gigabyte databse, sql server 2000, windows server 2003. UPDATE CallStat.dbo.RUN SET Service_RUN = ''' + @Good + ''' WHERE Transaction_ID = ' + @Bad + ' AND Date_RUN BETWEEN convert(DATETIME, ''' + @Date1 + @vsTime + ''') AND...

Thank you All - I tried solutions from DBAWinnipeg, and JayKusch. Both solution works well. Thank you

Hi, I want to delete a database everynigth. Sometime it works when no users are in use. If database in use, I can't delete this database. Can you please give me a code - stored procedure that will terminate or Kill this active or sleep user from this database. Thank you

I dettach the database, and deleted .ldf file. I try to attach database again and gives following error. Error 1813: Could not open new database 'ReferReports' Create database is aborted. Device activation error. The physical file name 'D:mssql$surfin\logs\referreports_log.ldf' may be...

I think it works fine now. Thank you

They will be deleting 1 IssueNo at a time. I get an error message: Error 209: Ambiguous column name 'IssueNo' CREATE TRIGGER UpdateIssueNo ON [dbo].[IssueTable] AFTER DELETE AS UPDATE it SET IssueNo = (IssueNo)-(1) FROM dbo.IssueTable AS it INNER JOIN Deleted AS del ON...

Hi, I need to execute this tsql code: UPDATE IssueTable SET IssueNo = (IssueNo)-(1); WHERE (CaseID = ?) This could be a trigger or something else... When a case worker delete a Issue Number = 1, we need to reset the IssueNo to 1, 2, 3. We have to have sequence 1, 2, 3... They can delete...

Hi, I have a memo field that has a value - ©1st Time User©©Special Need©©TFA© I need to split the value to say ©1st Time User© ©Special Need© ©TFA© Thank you

Hi All - I have developed a web form that has web text fields. How do I implement onkeypress events? We are having a few problems with the <enter> key and also with tabbing from a form that initialized on a specific field. The form does not navigate as expected? Please help. - Thanks

<authentication mode="Windows" /> <identity impersonate="true" /> <authorization> <allow roles = "BUILTIN\Administrators" users"BUILTIN\Administrator" /> <deny users="*" /> </authorization> We want to authenticate the windows based...

text1.text = items.selecteditem or Selectedvalue

Hi, My form is a form.aspx . This page don't have a keydown event.

Hi, How can I write a query that will return a table names ,a nd its field names. something like this: Select Name from dbo.sysobjects where xtype = 'u' AND NAME NOT IN('dtproperties') This only return table name, I need the table names with field names. Thank you Salim Bhura