Hi, I have installed the sqlxml 4.0 sp1. Need help on how to start programming and advanced performance issues faced. Is there a book on this? Can...
Can somebody please guide me to get download of SQL Server 2000 Reporting Services. I am unable to gert information as to how to obtain it. I have...
With me and SQL-Server [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Usha Rani
Both of you are nuts. [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />Usha Rani
ummm.... Thank you. Usha Rani
But can't avoid dynamic SQL <img src='/community/emoticons/emotion-6.gif' alt=':(' /><br /><br />Usha Rani
ex: Insert Selected Categories from front end as multiple records into a detail table. I have constructed a string with IDS to insert, passed it to...
Hi, Could we Insert Multiple Rows within a Single Round Trip? IF so can you guide me please. Thank you. Usha Rani
Well it works. I mean to say it is't a solution to follow or advice. Frank is right but how else to takle with problems of this sort without being...
HI Frank,<br /><br />This is a real junk. Well it works now but.........<br />really not the solution<br />[<img...
Thank you Frank. I have suggested the change to my PM but well they have their limitations. But if I design the table or reengineer it I will...
Hi Frank, I got it! Select SortID, substring(SortID,1,len(SortID) - Len(RIGHT(SortID, LEN(SortID) - PATINDEX('%[0-9]%', SortID)+1)))alpha,...
Hmmmm...... You are very Cleaver! Thank you. Been a lot insight fulll.<br />How come that 100 is after A2? <img...
Thank you! Frank. But still the three digit numaral does not fall under numeric order. All Numerals must come first. Then the alphanumeric....
Hi Frank, I did it but alas! it shows hte order as 0,1,10,100,2,A1, ABC12 How else to do it? oops! Thank you Frank for natsort() info. Looking...
Hi all, In a DB I have found an nvarchar code field which needs to be sorted as follows: 1,2,3,4,5,6,10,100,200,2000,A1,A2,AB1,AB2,ABC1,ABC2 Is...
Thank you. I have got it up by getting the live server backup. Since my Test server database has been in simple-logged recovery model, hence I could...
Hi! Please help me restore my database to the prior time. I have no uptodate backup. This is a test server database. I have run script as: RESTORE...
IT works Adriaan. Tahnk you. Usha Rani
Create FUNCTION dbo.fnListOfUNames(@FilterId INT) RETURNS VARCHAR(8000) AS Begin DECLARE @List VARCHAR(8000) SET @List = '' SELECT @List = @List +...
Separate names with a comma.
