Hi,

You will need to set up the HashValue column to use two parameters. The first is the algorithm (e.g. SHA1); the second is the unique value to be...

Hi.

We had a similar problem and we eventually set up two system DSNs.  One using the 64bit driver; the second using the 32bit driver.  The two have an...

Hi,

Some options for compression are still available with columnstore tables.  See https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression?view=sql-server-2017#using-columnstore-and-columnstore-archive-compression

The stored procedure sp_estimate_data_compression_savings may also be useful for estimating what compression will do...

Hi

Is it possible you have some values formatted differently?  Such as '006403/'  ?  See the example code below, the first value is fine but the second one will...

Hi,

I'm not sure if I have worked out your requirements correctly but hopefully this query will get you a step closer....  I have assumed that your first row...

Hi.

Are you just after some INSERT scripts?  This can be done in SQL Server Management Studio:

Right-click on the database in Object Explorer
Click on Tasks >...

Hi,

I think SP:CacheMiss might help you. It is under Stored Procedures in the Events Selection tab. According to msdn this will : "The SP:CacheMiss event class indicates that...

Hi,

You can use isdate function along with a case statement as below:

create table #temp

(string varchar(32) null);

insert #temp

select '2012-01-08'

union

select '2012-04-04'

union

select '2013-01-04'

union

select '2013-02-26'

union

select '2013-03-12'

union

select '0210-05-12'

union

select '2010-02-30'

union

select...

Hi,

Let us know if this is the sort of thing you are after. Note that I have recursively joined back to the duplicate_id and the master_id. Hope that...

Hi,

If you want to split the value inside SQL you can use this:

declare @input varchar(max)

declare @delimiter varchar(1)

declare @index int

declare @corrected_input varchar(20)

set @input = 'ABC DEF GHI'

set @delimiter =...

Hi,

This resource, Logical Query Processing , from Itzik Ben-Gan's book will help you understand what is going on behind the scenes.

But if you want to know for sure then run...

Here's another option....

I've listed all the fields so you can confirm it is working. You can decide which fields to use.

Regards,

Bevan

with cte

as

(

select ho.[WorkingDate], sl.[WorkDate] , sl.[BusinessUnit],...

Add a distinct to your select:

insert names2 (fname, lname) select distinct fname, lname from names

truncate table names

Hi,

I'm not sure what your desired output is but you could try the following:

select a.LinkID, a.PhaseType, a.StartDate, a.EndDate, b.PhaseType, b.StartDate, b.EndDate, c.PhaseType, c.StartDate

from @tblLinks a inner join @tblLinks b on...

hi,

What are the three queries you wrote? We can probably help optimise them or improve them.