Details a bit sparse, but try pivot the lookup table so that you can compare column to column?

Ok, there's probably a SPN setting problem in one of your servers?

Check out here and here.

I'm guessing it is some subtle discrepancy between server A and server B accounts and logins that cause the current security context to be different.

What are the types of accounts...

You're welcome 🙂

The rule of thumb with GROUP BY is to include every column in the result set that isn't wrapped inside an aggregate function. For computed...

Try using an aggregate such as the below:

selectlicdet.LicNum,

licdet.CustomerId,

licdet.customerholder,

licdet.issuedate,

licdet.expirydate,

case licdet.LicStatusDesc when 'current' then 'C' else 'E' end as LicStatusDesc,

licdet.HolderAddress1,

licdet.HolderAddress2,

licdet.holdersuburb,

licdet.HolderState,

licdet.HolderPostcode,

max ( case CONTACT_USAGE_ID when '54076' then tel.formatted_number else '' end ) as...

This is a classic cross-tab or pivot query.

The hardcoded way:

http://www.sqlservercentral.com/articles/T-SQL/63681/[/url]

The dynamic way:

http://www.sqlservercentral.com/articles/Crosstab/65048/[/url]

#2. Especially in the banking sector.

Nothing wrong with a technical path, but from your description it appears that any skills growth will have to come from outside the work...

Regardless of the number of queue readers, items in the queue will be picked up in a FIFO manner. From the Service Broker point of view, it will always...

Can you please provide a detailed example with table scripts, sample data, and the expected results like this[/url]? Also, can you please describe how are the sets of rows...

SQL Server Agent is not an available feature in the Express edition, the service default is disabled.

Ref: http://msdn.microsoft.com/en-us/library/cc645993%28v=sql.100%29.aspx

To connect to your local named instance:

Server type: Database Engine

Server name: .\SQLEXPRESSJD

Authentication/login/password: As...

If you want to allow connections to the named instance using the SERVER\NAME notation, ensure the SQL Server Browser service is enabled and running, and open UDP port 1434.

http://msdn.microsoft.com/en-us/library/ms175043%28v=sql.100%29.aspx

Turn the join into a correlated subquery and use nested FOR XML claused queries, adding the TYPE directive. For example:

declare @Store table (Name nvarchar(21), SalesPersonID smallint, ModifiedDate datetime);

declare @SalesPerson...

Hidalgo 😛

Also maybe an aggregate will work:

-- Set up sample data, this is a guess of what your current query results look like

-- For the sake of this example webinar #45623...

I would set up the SSIS package to insert into a staging table first. Then use a SQL task to check for references in the staging table that does...