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
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...
Could we Insert Multiple Rows within a Single Round Trip?
IF so can you guide me please.
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...
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....
I did it but alas! it shows hte order as
How else to do it?
oops! Thank you Frank for natsort() info. Looking...
In a DB I have found an nvarchar code field which needs to be sorted as follows:
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...
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:
IT works Adriaan. Tahnk you.
Create FUNCTION dbo.fnListOfUNames(@FilterId INT)
DECLARE @List VARCHAR(8000)
SET @List = ''
SELECT @List = @List +...
Separate names with a comma.