Just curious:

Is the except statement just syntactic sugar for "Where Not IN" or is there some additional optimization magic that goes on behind the scenes?

When I've had to reverse-engineer systems with a large number of tables in past, it really helped to examine the existing system to see how they pulled data.

In reality, my...

OK...don't skewer me for this 🙂

create function SumDigits(@value int) returns int

as

begin

Declare @acc int

set @acc =0

while 1=1

Begin

set @acc = @acc + @value % 10 ; set @value...

could be done mathematically too:

Declare @number int, @acc int

select @number = 219, @acc = 0

while 1=1

Begin

set @acc = @acc + @number % 10 ; set @number =...

I personally like using the INFORMATION_SCHEMA.TABLES view.

Yes, I did get distracted. The nested repeater is definitely the wrong way to go with just one record in the second query. I like Mr. Corbetts solution as posted...

OK, I misunderstood the direction you are going with this. What you are after is a nested data repeater. Googling for "nested data repeater" will get you everything you need...

Without knowing anything about your particular situation, I can try to ffer a general answer. There are two ways to "combine": UNION or JOIN.

I'm guessing you want a JOIN here,...

What you actually have to store is the relative path to the image from where the web page is going to be run, then you can simply bind the path...

One other thought here is to utilize Views. If your goal is to limit data for the end user, then have one physical table with your data (which you can...

It must be the way SQL handles floats and reals, which on import it is probably using. In my quick experiment, a cast to numeric forces SQL out to the...

I think the simple answer is to not import it into a varchar field.

Check out the numeric data type. It may suit your needs better.

In order to dynamically generate column names, you need to have dynamically generated SQL.

Declare @sql varchar(max)

Declare @col1Name varchar(50), ...

Set @sql = 'Select Monday as '...

1. Go into the server room

2. Whip out your Canon 5000

3. Take a picture

😀

Sorry...couldn't resist

I usually start with a database diagram, and go from there.

It also helps to talk to...

One more thing...this article uses the"image" data type. You should also research the binary and varbinary datatypes that I believe can be written and read in the same way. Someone...