Can you post the exact error message please?

Edit:

Apologies, the error is thrown because it's looking for each SELECT...

Hi,

It is certainly possible to create a GUID using NEWID() and then appending a sequential number to it; can I ask what the requirement is for this though as a...

Hi,

I use the following script to show the columns in temporary tables. It can easily be wrapped in to a store procedure or function to produce similar repeatable results.

SELECTso.xtype, so.id,...

Hi,

Have a look at the DATEDIFF function in Books On Line:

DATEDIFF(dd, startDate, endDate)

Hth

Hi,

If you're going to do this in Crystal, I can't remember if this is correct or not, but I have a nagging feeling that there is a special field called...

Looking at the performance of 1.0/n against POWER(n, -1) it seems that there is negligible difference. For a run on a table of 500,000 rows, on my heap of junk,...

If you wanted to update the rate using the power function you would:

UPDATE tblPandL

SET rate = POWER(CAST(rate AS FLOAT), -1)

...

...

Hi,

You can use the POWER function...

POWER(CAST(rate AS FLOAT), -1)

Hth

I'm not quite sure on that to be honest. These pages may be able to help you... :ermm:

http://msdn.microsoft.com/en-us/library/ms144287(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms143702(SQL.90).aspx

and this one shows how to check for a successful installation...

http://msdn.microsoft.com/en-us/library/ms143673(SQL.90).aspx

Hi,

If you've used the default settings for installation path etc, then you should find the main log in:

C:\program files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt

There will also be other logs for each component...

I should've done that! 😀

Hi,

Something like this should work for you:

UPDATE asset_table

SET locationID = (

SELECT a.locationID

FROM asset_table a

...

You can use xp_cmdshell to run the DIR command.

DECLARE @dir VARCHAR(200)

DECLARE @cmd VARCHAR(205)

SELECT @dir = '\\machine\dir'

SELECT @cmd = 'DIR ' + @dir

CREATE TABLE #directoryFiles (lineID INT, line VARCHAR(2000))

INSERT INTO #directoryFiles(line)

EXEC...

To be completely honest, I don't know off the top of my head, but I think it should... :ermm:

Hi,

I think this is what you're after:

@[User::ArchivePath] + SUBSTRING( @[User::MyFileValue] , 1 , FINDSTRING( @[User::MyFileValue],".",1) - 1 ) + "-Processed" + SUBSTRING( @[User::MyFileValue] , FINDSTRING( @[User::MyFileValue],".",1) , LEN( @[User::MyFileValue] )...