MadDogs... sorry all of that took so long. The code above solves your problem. Appologies for the delay.

Sorry Brian... didn't mean to sound condescending or for you to take any of this as an insult.

The last point was that you used a form of RBAR to drive...

Heh... you used procedureal code to drive a set based solution. :hehe: Ok... I guess I'll...

Remi,

There's a huge hidden benefit to all of this if it's running on a SAN. Most SAN companies have software that make "nearly instantaneous" copies of the entire system...

Sorry, Lynn... here it is and, yes, like your's, it's a CTE...

;WITH

cteTally AS

(--==== Create a Tally CTE from 1 to whatever the length

-- of the...

K. Brian Kelley (11/14/2008)

---

But truth be told, Jeff, the optimal solution would likely be to make the check with compiled code, whether it be an extended stored procedure or a...

K. Brian Kelley (11/14/2008)

---

And I'll acquiesce, because over a run of 20,000 with a permanent tally table (Jeff's condition, and that makes sense since that's the costliest operation), the original...

Heh... I wanna piece of the check that has 16 digits to the left of the decimal place. 😛

anam (11/13/2008)

---

you can run query below for all numbers which are not having decimal.

create table #tmp

(id varchar(10))

insert into #tmp

select '10.10'

union select '1010'

union select '20.20'

union select '2020'

select *, cast(id as...

Any chance of seeing...

To me, it doesn't matter if you change your network handle or not... posting/publishing sensitive information "in the public domain" does. I've made no effort to hide who I...

vkundar (11/11/2008)

---

Hi,

I have a recursive query which is very slow. AS this is a dataware housing ENV, We will not create any indexes or constraints. So the query is scanning...

If dropping and recreating the linked server doesn't do it for you, then I think you're pretty much toast for using a linked server to read the files. There's...

You're the second person to say that without showing how... 😉 And, just how would you do that if...

There's a really, really simple way to get simple returns from a query to look great... lookup sp_MakeWebTask. With a little effort, you can also turn out some absolutely...