You can build and execute dynamic SQL within your loop. I use this approach to build qualified table names for databases that reside on linked servers....

Ted Codd would be very surprised to learn that. Pity he isn't still alive.

...

Sorry I didn't post my code. There's nothing secret about it, but Rob requested it in PM and I respected his request. I was...

Jeff, two things.

1. Some code is missing from your first example. But I presume you were going to cross join syscolumns to itself. I...

Also be prepared for the possibility that the database design will be critiqued. If it turns out that the table structure is a poor design, the fault...

I guess I'm lucky that my guys just ask me for stored procedures now. They know I will give them something that runs fast on the front...

First you're going to have to get the file into the database. Your code just specifies a string constant, and you are assuming there is magic to go...

Test question?

I've been taking buisness requirements for years, and never...

Perhaps he sensed the strength of the Force within you, my little green friend.

More likely, he hit the bars soon after his last post.

Or he's a kid who is finally reaching a comfort level in one language, and now he wants everything to be like that so it will come easier to him....

I'm waiting to see if the ranter gets off his high horse or comes back for more ugliness. I bit back my first reply which was...

Really stupid paradigm...

Get some sleep, Jeff.

If you look at BOL (books online - the SQL Server Help function) you can find the format for both the EXISTS keyword and the IN keyword ... with EXAMPLES...

And yet another 😛

declare @number varchar(100)

set @number = '12345678902331234'

select @number as [before], len(@number) as [length]

set @number = STUFF(@number,1,len(@number)-4,REPLICATE('*',len(@number)-4))

select @number as [after], len(@number) as [length]

There are ways to take sums and then to take averages of those sums, but they usually involve different groupings. For example I could take the sum of...