Viewing 15 posts - 1,261 through 1,275 (of 3,221 total)
Did you execute this DBCC CLEANTABLE
Read about it here to see if it could help
http://technet.microsoft.com/en-us/library/ms174418(SQL.90).aspx
April 21, 2011 at 6:03 pm
There will often be someone held accountable, even if the issue isn't publicized, and that person could easily be you. Follow best practices for security, raise awareness where you can,...
April 20, 2011 at 3:25 pm
CirquedeSQLeil (4/20/2011)
Brandie Tarvin (4/20/2011)
LutzM (4/20/2011)
bitbucket-25253 (4/19/2011)
opc.three
The SSMS Tools Pack rocks! and so do RAR files
Care to share the link for the Tools Pack?
Is there anything wrong with the...
April 20, 2011 at 11:22 am
First of all I would place all your data from Table 1 and Table 2 into a single temporary table
CREATE TABLE #T3(COL1 VARCHAR(1), COL2 VARCHAR(1),COL3 VARCHAR(1), COL4 VARCHAR(1)
,COL1A VARCHAR(1),COL2A...
April 20, 2011 at 10:37 am
Steve, Andy may I congratulate you and those you select as mentors on this endeavor. Microsoft should add an award for the two of you.
MVPE .. Most Valued Professional...
April 20, 2011 at 9:08 am
shubham.saxena67
with cte
as (select row_number() over(partition by Adm_no order by adm_no) as rn,Adm_no,
first_name,mid_name,last_name
from dbo.tb_studentDetails)
SELECT * FROM cte
Sample of result returned:
rnAdm_nofirst_namemid_name
106/2036ESHITA SINGH
206/2036RajeevSolanki
106/2037DIVYAMTEOTIA
206/2037Divyam Teotia
106/2039Rhythem Saxena
206/2039RHYTHEMSAXENA
106/2040ISHITACHANDRA
206/2040Mohan Gupta
Code removed per correction of me by ColdCoffee...
April 20, 2011 at 8:42 am
To help those who want to help you, please, please post your table definitions, sample data, and your expected/required results in an easy to use format. To do...
April 20, 2011 at 6:56 am
CirquedeSQLeil (4/19/2011)
bitbucket-25253 (4/19/2011)
opc.three
The SSMS Tools Pack rocks! and so do RAR files
Care to share the link for the Tools Pack?
Not a direct link but I have it linked...
April 20, 2011 at 6:02 am
Just what I needed, a simple question with obviously correct answers
April 19, 2011 at 8:14 pm
opc.three
The SSMS Tools Pack rocks! and so do RAR files
Care to share the link for the Tools Pack?
April 19, 2011 at 7:39 pm
Have you tried OPENROWSET ? I know it works on 2005, but have as yet not tested on 2008
/*Text file must exist and have a first line of...
April 19, 2011 at 4:49 pm
If you want tested help from those who can help you, post your table definition(s), sample data and the desired result from that sample data following the instructions which you...
April 19, 2011 at 1:26 pm
lianvh
I suggest that you read this blog posting of Kimberly L. Tripp
http://www.sqlskills.com/BLOGS/KIMBERLY/post/Spring-cleaning-your-indexes-Part-I.aspx
It may suggest a plan that you can implement to solve your problem
April 19, 2011 at 12:36 pm
To receive test help, please, please post your table definition, some sample data, the results required from that sample data, and any T-SQL code you have attempted to use?. ...
April 18, 2011 at 2:45 pm
NOt quite what I asked for. Remember many people do NOT like to open an attachment, not knowing what "worm" or other malicious code could be hidden in it....
April 18, 2011 at 1:54 pm
Viewing 15 posts - 1,261 through 1,275 (of 3,221 total)