Just at the time when we're trying to find a way to improve our data import this article comes along. Perhaps it is a God-send.

While your article does not...

Thank you all for your input on this editorial, it has been a very enlightening and instructive dialog.

My initial thoughts related to the "speak up" part of the editorial. ...

Well said, Steve!

Looonnnng ago, in a GUIDE conference in a city faaaarr away in a mainframe community, a presenter made some excellent points which I offer (in my own words) in addition to...

This was an interesting question.  Such a simple thing, of course it would be 3.33333... ad infinitum.  Not so, when I tested it!  When the answer appeared, I wondered whether...

I'm impressed with your article, Janet.  And I find Vincent Rainardi's experience very helpful.  Being the novice that I am with SQL DTS (I shudder when I think of DTS),...

Good for you-all! And good for us-all.  Thanks for communicating with us, the community, and thanks for the integrity and conscientiousness to pass along the site to folks who have, as...

The only time I've seen this "strange message" was when I was debugging code and tried to add a line of code. When I've encountered this message,...

PW, well done!  Your solution is a LOT SIMPLER than the gyrations I was going through.

Thanks

A variation of Steve's answer, plus adopting msahoo's suggestion to use '=' ... and I wonder about the performance of this option.

SELECT CardNumber FROM CreditCardDetails

WHERE RIGHT(CardNumber,LEN(srcharg)) = srcharg

... with "srcharg"...

I agree: Good article, Andy.

I'm looking forward to the traffic signal showing how much time is left on the YELLOW (and maybe even FLASHING THE RED to STOP! STOP! STOP! before going...

The forum post listed below says there is no way to export/import, but we can open the DTS package and SAVE AS to another destination (Server and/or database?).  I'm trying...

Dear poger67, in the first reply from Steve Jones, he referred to BOL. For a long time I wondered what BOL was until I asked one of my fellow...

Hello, Peter.

I had a similar situation just recently.

What worked for me was to make each count an int or bigint, and set the variable for Percent to be decimal(5,2).

Table Variables...

This posting was intended for the T-SQL group, and somehow I put it here.

Since table variables cannot be used as inputs to functions (Antares686's reply above), the query...

THANK YOU to ALL of you! What a great and rapid response!

After I sent my cry for help, I found another person's question where he was using a table...