Viewing 15 posts - 1,306 through 1,320 (of 1,396 total)
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...
September 19, 2019 at 2:55 pm
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...
September 18, 2019 at 11:46 am
I use this query to find the details of the last time a query was run
Could you explain please why the guid is there?
September 13, 2019 at 5:05 pm
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...
September 13, 2019 at 11:42 am
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...
September 12, 2019 at 12:28 pm
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...
September 11, 2019 at 6:49 pm
Yes it still happens after the reboot.
September 11, 2019 at 6:39 pm
It's Chrome. I closed and opened the browser a couple of times and it occurs again. I'll reboot.
September 11, 2019 at 6:36 pm
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...
September 11, 2019 at 2:27 pm
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. ...
September 11, 2019 at 1:54 pm
I tried another simple stored procedure above, which I executed. It didn't display the results window for the SELECT statement result at this time.
Not sure which proc with what...
September 11, 2019 at 1:27 pm
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?
September 10, 2019 at 9:04 pm
So I'm trying to get an external image to show after I deployed the report. When I run the unpublished report in Visual Studio it's not an issue. I...
September 10, 2019 at 8:49 pm
I have set up the "Amazon Redshift (x64) driver in the ODBC "System DSN" window and that connects fine.
Ok
I have connected SSMS to the driver via a linked...
September 10, 2019 at 5:55 pm
Viewing 15 posts - 1,306 through 1,320 (of 1,396 total)