Recent content by indoaryaan

I use the following VB function as embedded code in SQL reporting to generate a message box if the date entered is NOT Monday. The message box pops up fine when the date is NOT Monday. The report spans 90 pages(group inserted with page break) and I have to click the message box (vbOkCancel) 90...

Did you try putting the distinct values into a temp / separate table and then do count(*) or count(column)?

We are using Ascential 7.5, windows 2000 server. The error log says "Non-Clustered indexes are being rebuilt". Then Ascential aborts. No we did not turn on any debugging. Is there a way to do debugging in Ascential?

Hi all, I have a datastage job executing a stored procedure in sybase(version 12.5). The stored procedure basically drops and creates a clustered index on a table. Needless to say non-clustered indexes are also created. During non-clustered index creation, sybase sends a informational message -...

I am working with VS2002/VB.NET/ASP.NET. I have a Modal Dialog as PopUp window. I can create and close the PopUp. The below are the two scenarios when i need the PopUp. I am using JavaScript to create and close PopUp. 1) I need the PopUp to occur only the first time the page loads. Subsequent...

What do you want to insert into the database ?? Do you want to insert the checkbox.text or just a boolean value to check whether the checkbox was checked/not checked ??

I am using OpenDatasource function to retrieve data(filename) from a #table ( using cursor, one row(filename) at a time) and process the contents of the text file..say n rows in a file. If the file has no contents(no rows), i get an error. How do i work around this?? I would like to insert the...

i have checked for defaults...none there. No i am not using VB...i have to do this in SQL. Is there a way i can capture the command / command name which kicks in the trigger / update ???

I am using a SP to update a nText column. The update is fine. The next column is a DateTime column..and in few cases the datetime col gets updated to NULL. The SP does not touch the DateTime col at all. I have looked for any triggers being fired..but none seem to exist. I have run trace to check...

this is done as an in T-SQL code. No front end App is present. This code will be a part of a trigger.

Hello, I want to write the DBCC INPUTBUFFER output to a text file. I have created a temp table and the DBCC output is loaded into the temp table. The aim is to write the output to a text file to know the EventInfo of SPID. Any help would be appreciated. Thanks.........

I have nText and DateTime columns in a table. A stored procedure updates the nText col for X number of users. The stored procedure does NOT query the DateTime column. But for few users, only some records(not all records), the DateTime column is being set to NULL. Clearly, a trigger is being...

Hello, One can copy data from one source table to another the following maner, Copy <cursor number> source table to <cursor number> destination table; e.g SQL> COPY EMP TO 2.EMPLOYEES; NOTE : THE DESTINATION TABLE MUST EXIST. If you have toconnect toanother DB and copy from another table...

Does your statement include a "where" clause too ?? or is it a simple "select * from <tablename>" ??

Did you try SQLTalk ?? Just point the Sql.ini file to where the .dbs file exists. Also give the path for Log files in sql.ini file. Le me know if this helps....