Skip to search.
sqlcon

Group Information

  • Members: 779
  • Category: SQL
  • Founded: Feb 23, 2004
  • Language: English
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Messages

  Messages Help
Advanced
Messages 300 - 331 of 6711   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
300 jsrajjan
jsrajjan@... Send Email
Jul 2, 2004
2:46 am
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...
301 Veer Ji Wangoo
vwangoo Offline Send Email
Jul 2, 2004
9:45 am
Upcoming Chat Events<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> Date & Time SQL Server 2000 Indexes Inside out Host: Srinivas...
302 Santosh Sharma , Gurg...
SantoshS@... Send Email
Jul 2, 2004
11:11 am
Answer is - 3. The trigger assumes only one row is being updated at a time. **...
303 Veer Ji Wangoo
vwangoo Offline Send Email
Jul 2, 2004
11:11 am
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...
305 Anand Vijayaragavan (...
anandv123 Offline Send Email
Jul 2, 2004
1:45 pm
3. The trigger assumes only one row is being updated at a time. With Thanks and Regards, V.Anand ________________________________ From: Veer Ji Wangoo...
307 Ramesh Kondaparthy (S...
haikramesh Offline Send Email
Jul 5, 2004
2:56 am
3 The trigger assumes only one row is being updated at a time. ________________________________ From: Veer Ji Wangoo [mailto:veerw@...] Sent:...
308 aneesh
aneeshattingal Offline Send Email
Jul 5, 2004
7:22 am
hI, i Have a table containing Duplicate values (i.e. No Primary keys). How can I delete these duplicate entries from the table. Aneesh ...
309 Viswamitra Chevendra ...
mitracv Online Now Send Email
Jul 5, 2004
7:22 am
3. The trigger assumes only one row is being updated at a time Thanks & Regards, Mitra ________________________________ From: Veer Ji Wangoo...
310 Sreejatha Ramakrishnan
sreejatha@... Send Email
Jul 5, 2004
7:28 am
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...
311 veer
vwangoo Offline Send Email
Jul 5, 2004
7:28 am
Dear sreejatha, We appreciate your feedback on Advertisements comming on to this group and regret the inconvenience caused to you by certain JOB advertisements...
312 sudhakar.sadasivuni@...
svsmart2000 Offline Send Email
Jul 5, 2004
10:27 am
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...
313 jsrajjan
jsrajjan@... Send Email
Jul 6, 2004
3:47 am
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,...
314 Rajkumar S
srk_dba Offline Send Email
Jul 6, 2004
3:47 am
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...
315 Mohammed Zaheer Khan ...
mobik Offline Send Email
Jul 6, 2004
3:47 am
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...
316 Satya
hisatya Offline Send Email
Jul 6, 2004
3:47 am
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,...
317 sriram surapureddy
surapureddys... Offline Send Email
Jul 6, 2004
3:47 am
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...
318 Veer Ji Wangoo
vwangoo Offline Send Email
Jul 6, 2004
3:47 am
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...
319 Durgaprasad Ch
durgaprasadch2k Offline Send Email
Jul 6, 2004
3:47 am
Hi Aneesh, Do you want to delete all the duplicate records , I meant to say complete records with that value or keeping one? Thanks, Durga aneesh...
320 aneesh
aneeshattingal Offline Send Email
Jul 6, 2004
3:47 am
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...
321 Raghava
meetrag Offline Send Email
Jul 6, 2004
3:47 am
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...
322 vadlamani murthy
vadlamanimurth Offline Send Email
Jul 6, 2004
3:47 am
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...
323 pskantu Offline Send Email Jul 6, 2004
3:47 am
Hello Friends, Can anyone help what is the profile management system? How to get the information on this topic. thanks pskantu...
324 veer
vwangoo Offline Send Email
Jul 6, 2004
4:05 am
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... ...
325 papasani.ravi@...
papasanir Offline Send Email
Jul 6, 2004
6:42 am
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...
326 Anjana Ram
anjana_r21 Offline Send Email
Jul 6, 2004
8:39 am
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= ...
327 jsrajjan
jsrajjan@... Send Email
Jul 7, 2004
2:29 am
A List Of Date Formatting String in Reporting Services Design Reports Formatting Dates The following table describes common .NET date formatting strings. ...
328 Kiranmayee Vajapeyaya...
vnvk Offline Send Email
Jul 7, 2004
2:29 am
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...
329 Rajkumar S
srk_dba Offline Send Email
Jul 7, 2004
2:29 am
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...
330 sriram surapureddy
surapureddys... Offline Send Email
Jul 7, 2004
2:29 am
Hi Ravi, The following query could be useful if know the constraint name in that database . If the name of the databse is "testdatabase". ...
331 lakshmi_murthy16
lakshmi_murt... Offline Send Email
Jul 7, 2004
2:29 am
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®...
Messages 300 - 331 of 6711   Oldest  |  < Older  |  Newer >  |  Newest
Add to My Yahoo!      XML What's This?

Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines NEW - Help