Jayant i think they are refering to the OPENROWSET command; you can substitute SELECT * FROM YOURTABLE where i'm using EXEC dbo.sp_Who for the command

SELECT *

...

Yep I'm still sure you can calculate the accrued holidays (vacationtime?) with a view instead.

dunno your math, you will need to be very specific: give us the create table ,...

i agree with john.arnott; if we know the reason, we can help;

for example, why not use a view?

you can easily create a view or function that returns a number, based...

blocked at work, is that the "little bobby tables" comic?

Adan, you might need to switch to dynamic SQL to do that I think; you need to get the data into a comma delomited list for the IN() statement to...

dheer (2/22/2010)

---

Hi i have column with data type as Varchar.The coloumns contains the numbers with decimal point in between for ex: 789.24,7892.5 etc. How can i remove those decimal points....

maybe something like this as a prototype?

trying to join the two linked tables together.

SELECT

o.ordernumber ,

o.status,

o1.orderdesc,

l.location

FROM orders o

INNER JOIN (SELECT

...

Linked servers are slow to join against.

here's the reason:

you are joining LINKEDSERVER.ORDERS.dbo.orders to your table.

the result is that the entire table LINKEDSERVER.ORDERS.dbo.orders gets pulled into the temp database,...

SQLRecon[/url] is free, and uses a number of different methods to find all the SQL servers on your network.

i've used it a lot of times, it does a lot more...

hey I'm glad you got it working the way you wanted! Congrats!

i thought select serverProperty('ComputerNamePhysicalNetBios') was supposed to give you the actual machine you are connected to in a clustered environment, am i wrong?

Roust this seems to be working on my sandbox; i was able to create a table with a pk and a uq, and it iterrupts the create index statement:

CREATE TRIGGER...

copy paste error; your variable is missing the @:

set @vBackupPath ='\\l04\backup\RightFax_backup_'+@vDate+vTime+'.bak'

should be

set @vBackupPath ='\\l04\backup\RightFax_backup_'+@vDate+@vTime+'.bak'

ben i hope this helps;

this is the syntax i would use to update from a different table; it would be different if this is inside a trigger;

i *think* your current...

which registry key are you looking at?

on my machine, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

has a value of CurrentVersion=10.0.1600.22

for the the FileVersion of sqlservr.exe, i had 2 on my machine, one for an 2005 express...