Understanding Report Layout and Rendering A report consists of three main areas: a page header, a page footer, and the body. The page header and footer repeat...
jsrajjan
jsrajjan@...
Jul 2, 2004 2:46 am
301
Upcoming Chat Events<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> Date & Time SQL Server 2000 Indexes Inside out Host: Srinivas...
Answer is - 3. The trigger assumes only one row is being updated at a time. **...
Santosh Sharma , Gurg...
SantoshS@...
Jul 2, 2004 11:11 am
303
WELCOME NEWS :- As part of the combined efforts,Now QOD[Question of the Day] will be sent to SQL Banglore as well as to SQLCON Hyderabad. One has to reply...
3. The trigger assumes only one row is being updated at a time. With Thanks and Regards, V.Anand ________________________________ From: Veer Ji Wangoo...
Mr. Sanjay Gupta, Can you take your advertisements somewhere else. We are a bit tired of it. Thanks sanjay gupta <sguptasolntec@...> wrote: A large IT...
Sreejatha Ramakrishnan
sreejatha@...
Jul 5, 2004 7:28 am
311
Dear sreejatha, We appreciate your feedback on Advertisements comming on to this group and regret the inconvenience caused to you by certain JOB advertisements...
Veer, That would be really a good one. BTW when we will be grove in to SQL Server 2005 :-) MUGH/SQLCON is going to do a session on "T-SQL Enhancements in SQL...
Working with Items in a Report A report in Reporting Services uses report items to display data and graphical elements. In addition to the data regions table,...
jsrajjan
jsrajjan@...
Jul 6, 2004 3:47 am
314
hi u can use the following script to delete duplicate entries from ur table DECLARE csr1 CURSOR FOR SELECT Col1, Col2, COUNT(*) FROM test -- Give your...
Hello Anees, You may proceed with the below query.... Create a temp table with the Original where 1=2 (false condition) Create a clustered index with those...
Hi Aneesh, There are no. of ways to achieve this - Before proceeding..you need to identity those duplicate records by using Group By query select field_1,...
Hi Aneesh, one solution is to create a temptable and insert the unique rows in to it and then recreating the original table from temptable. +++++++ select...
The following script can be used to remove duplicate rows from a SQL Server table: SELECT DISTINCT * INTO duplicate_table FROM original_table GROUP BY...
hello everybody, I've found a way to delete the duplicate keys You add an identity cloumn first, then delete the duplicate rows at last remove the above...
Hi, Aneesh SELECT <Row> INTO #DupRows FROM <Table> GROUP BY <Row> HAVING COUNT(*) > 1 DELETE FROM <Table> a INNER JOIN #DupRows b ON a.Row = b.Row INSERT INTO...
Hi aneesh, If i am not wrong, the column should have distinct values am i right. Please confirm. Also please also confirm and on which column primary key is...
Hi Pskantu, Can you explain the context about profile management system Like if it means for Desktop Profile management System,User profile on Network etc... ...
Hello I want to drop one index from via one stored procedure, But the thing is:- My procedure will be executed in one database but the index which I want to...
Hi, Check this thread as an example http://groups.msn.com/dotNETUserGroupHyd/general.msnw? action=get_message&mview=1&ID_Message=1220&LastModified=0&ID_Topic= ...
A List Of Date Formatting String in Reporting Services Design Reports Formatting Dates The following table describes common .NET date formatting strings. ...
jsrajjan
jsrajjan@...
Jul 7, 2004 2:29 am
328
You can delete the Index of Database A from Database B by menitioning the DB name before the table/index. <DBname>.<username>.<tablename> is how the tables are...
Hi Ravi Drop index statement does not allow you to use databasename as prefix to the indexname. Instead you can write a stored procedure in the other database...
Hi Veer, I think the answer is option 2:sqlservr.exe -c -s {instancename} Note You must switch to the appropriate directory (for the instance of Microsoft®...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
