TKE402 did you get a linked server to work yet? I've played with SQLite a little bit now; I've used this .NET provider for SQLite[/url] in VS 2005/2008 with no...

thank you Jayant, I'm glad i could point you in the right direction with your project.

feedback like yours is exactly why I like to help here; knowing I got to...

Here's what I always do, it might help you out as well.

I create a new regular user in AD or on the local machine called SQLAdmin. (ie yourdomain\SQLAdmin)

i make that...

replace your static column "Holidays with the calculation included in my example,a dn you get the results you wanted, without the whole update of my db every five seconds:

Create Table...

yeah this is a very common issue; pretty sure the issue is permission to get to the share; especially with the error access denied.

change the login used to run the...

pretty sure the issue is this:

\\<servername>\medlog\sql_apps\afmsql\daasc_reb\txt\work_reb_ftp1.txt

when you jump to xp_cmdshell, it doesn't matter what YOUR credentials are; sql server uses the credentials that is running the sql service, which...

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...