Viewing 15 posts - 631 through 645 (of 706 total)
Dear All,
Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER NAME combo...
April 6, 2009 at 6:32 am
Dear All,
Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select...
April 5, 2009 at 10:44 pm
Dear All,
Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select...
April 5, 2009 at 10:43 pm
It got detahced when they installed SQL 2000.
I uninstalled wot they had instaled...after that I was not able to login into SQL 2005. it was not allowing me to REINSTALL...
April 3, 2009 at 9:03 am
How about passing a single XML parameter (as string) with one tag as column name and second as it's values and import into a temporary table inside the procedure..Using that...
April 2, 2009 at 5:25 am
Everything seems to be ok. I dont see any problem as such.
Are both the databases in the same server..?.
April 2, 2009 at 4:14 am
I realy dint understand the actual probelm....
but still, you should enclose ONLY the column names with "[]".
some thing like below..
[UnitSno] LIKE 'AZX%'
and NOT [UnitSno LIKE 'AZX%'] - which is...
April 2, 2009 at 2:30 am
Msg 911, Level 16, State 1, Procedure COBOChanges, Line 57
You are executing a procedure COBOChanges and not just simple update statement.
Is there any trigger in the table in which you...
April 2, 2009 at 2:16 am
You can try the below query as well.....There will be a better way...will check and revert back..
SELECT * FROM
(
SELECT
CASE WHEN (Row_Number() OVER (ORDER BY Q.QText)) > 1 THEN...
April 2, 2009 at 1:39 am
hi,
Set your browser to the below link, might be useful to you.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20961170.html
March 31, 2009 at 11:57 pm
Table 1
Doctor_ID Patient_ID Blood_Tests
123 1A 4
123 1B 67
222 6A 4
333 9G 756
.
Yeah....We need a clarification on this.
Since '4' has been given as the blooad_tests for doctor_id ids 123 &...
March 31, 2009 at 7:51 am
Currently I programatically cycle through every record once a week, ans resequence the lot. and there are thousands of records
I dint understand this..Can you explain in detail.
Dint understand what exactly...
March 31, 2009 at 4:53 am
Now in my report i need to find total blood tests done by the doctors
Select Doctor_ID, Patient_ID, Count(*) as [Count]
From Table1 as t1
Inner Join Table2 as t2 ON...
March 31, 2009 at 2:18 am
Viewing 15 posts - 631 through 645 (of 706 total)