NineIron (5/1/2014)

---

The data contains medications given to patients. If a patient is given Vitamin K, DrugID='VITA100T2', then, the status can be 'AC' or 'DC'. All other drugs with a status...

Before I answered this question, I read

It reads, in part:

The hash join has two inputs: the build input and probe input. The query optimizer assigns these roles so that the...

It's complicated. Lots of things to consider, e.g.

1. Can any indices be used to join on?

2. What do the statistics say?

3. Is the predicate(s) simple or not-so-much and are...

If you post the following:

1. Create table ... -- for all tables in the queries

2. Insert into ... -- to populate the tables with sample data

3. expected results

we can take...

Why not just have two textboxes? The first one has the string 'Checking' in it. The second one has the value. You can set the formatting property...

How many groups (ssn) can you have? Is it reasonable to build the parsing inline or maybe break it up into a temp table based on the sections beginning...

I just changed your table slightly:

create table #sample (rowguid int identity ,id_frm bigint ,id_to bigint)

using bigint instead of int. With that in place, the rest of your queries work...

Use bigint. And you don't need the dynamic SQL:

create table #sample (rowguid bigint identity ,id_frm bigint ,id_to bigint)

insert into #sample values( 1,5)

insert into #sample values( 7,13)

insert into #sample values(...

nick.latocha (4/30/2014)

---

I have an SSIS package with 5 separate data flow tasks. They are not linked and run in parallel. I;m trying to figure out how to stop the other...

I don't really understand the one-to-one mapping between users and databases. Please explain a bit more what the databases are used for and why you need one per user....

Please post some sample data in the form of DDL (CREATE TABLE ...) and DML (INSERT INTO ...) along with the query you have so far and the output you...

- You don't have to reformat your system (by which I assume you mean your C: drive)

- If you have a database that is growing, its space usage will grow....

It looks like the error is in the MERGE statement, not an ALTER INDEX...REBUILD.

Maybe you could post the DDL of the tables involved and the entire MERGE statement that throws...

Here's one solution I found:

On the subreport properties in the main report, there is a KeepTogether property that is set to false by default.

Once I changed that to true on...

FWIW I just landed a job like that where I lacked all the front-end skills. They asked for the usual SQL stuff plus ASP.NET, C# and other front-end stuff....