you can, but you need to have specific access to the command

xp_cmdshell

EXEC xp_cmdshell 'Dir C:\*.*'

haven't built a horse-racing one, but did build a rugby-league one a few years ago. didnt help to much with the betting though.

SSIS (Integration Studio) will be...

as the others have said look at the execution plan and time.

Other general ideas are;

Avoid costly queries in your procedure, avoid cursors and try and use a set...

it looks like you are grouping the same field that you are summing, so it will never sum correctly

post your exact output and it will be easier to diagnose.

Okay it sounds like you have installed the server tools locally, you need to run the install again and select management studio client tools to install on your client...

SSMS = sql server management studio, it is the client side for sql server.

sql server should be run off a server , though you can run it...

unless you have SQL server avilaible to you either locally or over a network on a server, you will not be able to use it in VS.net.

the basic functionalitly is...

You will need to install sql server seperately from vs.net, it does not matter what order you install them in.

Do you currently have acces to a sql server, ...

yeah, i had to read it a couple of times as well 🙂

check the link, according to the diagram they can.

There is no black dot this means that they can be run at the same time.

try this;

Declare @Keywords varchar(50)

set @Keywords = 'YourString'

SELECT *

FROM Product

WHERE...

though i would usually look for another solution, dealing with third party consumers of data some times takes compromise

try this code

update

set [payee] = replace([payee],'''','`')

depends on the max lenght of them, for a lenght of 12 i would use

varchar(12)

Sorry I skimmed over that was expecting some graphics or something, sorry about that.

As Lynn said It looks like it is not making a match at all and the...

They look like really useful tools I will have to have a look at them a bit further, Maybe you should consider doing a bit more advertising..