Thanks a lot for removing the horizontal scroll.

Sachin

:))

I did not like the new design as much. 🙁

I fell the previous design was cool and that is one of the factor that made me hook onto sqlservercentral.com apart...

quote:

---

The result of the first OSQL run is correct EXCEPT for 1> 2> 3> 4> 5>

6> 7> 8> 9> 10> 11>...

I wonder what is that u want to do in a trigger on a table without executing Insert/Delete/Update queries???

What u can do is write a stored procedure and call this...

I agree with Tim. I have started using table variable in stored procedues. Yet to check to performace of the procedures...

From BOL

---------------------------------------------

Functions and variables can be declared to be of...

How about trying this one...

if exists (select * from dbo.sysobjects where id = object_id(N'[BackupUserTables]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

BEGIN -- table exist

IF NOT exists (Select * from dbo.syscolumns where name...

2 Good...Perfect & Excellent....

Sachin

🙂

There is always another way...

🙂

Hi Chiby,

How about trying something like this...

SELECT [first], [second], [first] + [second] AS [Total]

FROM ( SELECT (1 + 2) AS [first], (3 + 4) AS [second]) AS NewTbl

HTH...

Sachin

Hi Tom,

Thanks for the appreciation...

:))

How about trying this???

SELECT ... /* various fields */

FROM PatientInfo

WHERE UserID = CASE

WHEN @Id > 0 THEN @Id

ELSE UserID

END

I guess this eliminates the...

Well, sailing in the same boat...

But I guess my case is more complicated....in that I have FromSource and ToDestination and both can vary Specific or ALL so 4 combi!!!

I am...

Hi,

Well, could not reply 'coz of weekend.

I am working on SQL Server 2000. So I guess these are the additions in Profile for SQL Server 2000.

Anyway, you made your...

Hi,

> Is the trace applicable only for users of the same domain?

No, don't think there would be such a limitation with this wonder...

> Have I made some basic mistake in...

You can find the description for a column in 'value' column of 'sysproperties' table.

Hope this helps you...

IF U DON'T SEEK PERFECTION, U CAN NEVER REACH EXCELLENCE!!!

SD

Neither do I see it. Well, will check it later during the day or rather tomorrow morning. Almost time to wind up my job for the day...

Thank you for your...