A combination of Left and Charindex.

declare @String varchar(20);

select @String = '123 456';

select left(@String, charindex(' ', @String);

The question doesn't actually ask what the author thinks.

I got it right, but only by trying to outthink the author.

None of the answers given were actually sequitur to the question.

Your screen shot is of the preview. The delimiters are on a different tab. What do you have there?

Then what you need to do is have a "three-part-name" for the tables you want to query.

If, for example, you have DatabaseA and DatabaseB, and the proc is in DatabaseA,...

Some mainframes use something other than cr/lf for end-of-line. You might want to check what's being done on that end.

I have to ask, is there any reason to not simply add 8 * @b-2 to @i?

declare @i int, @b-2 bit;

select @i = 0, @b-2 = 1;

select @i + (@b...

Very possible.

Is the separate database on the same server, or a different server?

First, you need to look at what recovery model the database is in. You can get that by looking at the Options tab in the properties. (Right-click the...

Run a trace for a while. Track batch completions. That'll give you a very good idea of what's being used and how.

What problems are you having with it?

I've imported hundreds of Excel files. Different ones have different problems for different reasons. Can't really tell you what to do without...

Start by looking at the system view master.sys.syslogins. That'll give you most of what you need. You can expand it from there if you need further data.

It probably means that your log file is about to autogrow, or that it will need to be grown.

It probably also means that log backups aren't being done the way...

Are you just trying to get a list of all the logins and their permissions? Or am I misunderstanding your question?

Just over 2 minutes vs over 22 minutes should be good enough. Shouldn't need Profiler for this one. But it's still a good idea to get familiar with...

Sometimes.

Other times, no.

You could have 0 use because the index hasn't been used since the service was started, but that doesn't mean it won't be used a dozen times in...