The code you provided executed without error and returned 24 rows.  The two temp tables have identical DDL so it seems to maybe make sense to do UNION ALL and...

Could be something like this

ALTER PROCEDURE [dbo].[employee]
@isemployee int
AS
BEGIN
DECLARE @Email Varchar (100)
DECLARE @Name Varchar (100)

IF (@isemployee = 0)
BEGIN
SELECT @Email = text from dbo.emailtable WHERE email = 'XXX'
SELECT @Name...

This code has the 3 ranking methods (row_num, row_rank, and dense_row_rank) and joins to itself twice to get the next and previous list members.  The ORDER BY for the rankings...

One sane way to allocate inventory is to do it when the invoices are generated.  Is the purpose here to answer the question "how many of which products can I...

It must be for testing.

Could you explain please why the guid is there?

In this link: https://wordpress.org/support/topic/strange-search-error/

The user 'rundlof' wrote:

I have seen this on non-WordPress sites too, only Chrome. I believe it is an autocomplete entry created as a result of an error...

This works:

declare @v table(
  varchar_id varchar(36));
declare @u table(
  unique_id uniqueidentifier);

insert @v(varchar_id) values('09C4C7B4-1275-460A-AE23-FFA9256B1ABE');

insert @u(unique_id) select * from @v where varchar_id='09C4C7B4-1275-460A-AE23-FFA9256B1ABE';

select * from @v v join @u...

If I paste the entire error message into notepad it says:

Error: An invalid email address was specified for 'em'. This data will not be sent with any events for this...

Yes it still happens after the reboot.

It's Chrome.  I closed and opened the browser a couple of times and it occurs again.  I'll reboot.

Could you explain a little more what you're trying to accomplish?  Sql Lite and Sql Server are very different databases.  From a Sql Server perspective there are a bunch of issues...

The short answer is no.  Ideally the "share drive" would not be read from by your reporting server and definitely not by letter-aliased file path.  In reality it always depends. ...

Not sure which proc with what...

• This reply was modified 6 years, 4 months ago by Steve Collins. Reason: Matched the (useless) capitalization

What lead you to conclude it was the images which were causing the render to take so long?  400 thumbnails are tiny.  Is there a query being run too?