Won't work. Jeff knows my coding too...

Steve! C'mon! It...

Just to annoy Jeff, here's my "ultimate version":

SET NOCOUNT ON;

DECLARE @Table1 TABLE (

ID int IDENTITY PRIMARY KEY,

Number int);

DECLARE @Number INT;

SELECT @Number = 1;

WHILE @Number <= 100

BEGIN

INSERT INTO @Table1 (Number)

SELECT @Number

WHERE...

You can include any number of them in an index. You can't have them as the key columns for the index. It's really as simple as that.

Often, you're...

WinZip has a command-line utility that I've used for that before. Call that from the package, and it'll do the job nicely.

The text piece makes sense. My XQuery education has all been "trial and error", based on abysmal documentation and samples online and in BOL, so no great surprise that...

Questions seem okay right now. Some of the answers have been abysmal recently. I guess it balances...

Paul White (2/21/2010)

A much more efficient query plan is produced from...

The reason Australians, et al, don't fall off is the same as for those of us in the northern hemisphere. Earth sucks!

Paul, that returns everything left of the colon. He asked for everything right of it.

The only thing I can think of is checking the update history. If you open Windows Update, you can get a fully history of installed updates. There may...

DECLARE @XML XML;

SELECT @XML =

'<ROOT>

<Customers>

<CustomerId>1111</CustomerId>

<CompanyName>Sean Chai</CompanyName>

<City>NY</City>

</Customers>

<Customers>

<CustomerId>1112</CustomerId>

<CompanyName>Tom Johnston</CompanyName>

<City>LA</City>

</Customers>

<Customers>

<CustomerId>1113</CustomerId>

<CompanyName>Institute of Art</CompanyName>

</Customers>

</ROOT>';

SELECT --R.Node.query('.'),

R.Node.query('.').value('(/Customers/CustomerId/.)[1]','varchar(100)') AS CustomerID,

R.Node.query('.').value('(/Customers/CompanyName/.)[1]','varchar(100)') AS CompanyName

FROM @XML.nodes('/ROOT/Customers') R(Node);

You'll need to use your column name instead of the XML variable, but it...

Considering that this is the MS Access forum for the site, I think it's perfectly acceptable to post questions and answers about Access here. 🙂

On the original question, I'd set...

Here's one way:

DECLARE @Text VARCHAR(100) = 'abc:xyz';

SELECT

REVERSE(

LEFT(

REVERSE(@Text),

CHARINDEX(':', REVERSE(@Text))-1));

SSIS packages don't have to be run as jobs. They can be run from the command line using dtexec.