As suggested i can use output clause as one way.

This is a ETL process and the deletion logic in the WHERE clause varies from table to table based on business...

Using CTE, you can select, update and delete specific record(s). Pls refer the below code

create table #temp (id int)

--delete #temp

insert into #temp values(1)

insert into #temp values(2)

insert into #temp values(3)

insert into...

I too tried the same and end up with error. To quickly start with, i am trying to create CLR function to handle this and bring the same functionality and...

I apologize to all those who assumed all answers were wrong as time portion was missing.

As mentioned earlier, the objective of the question was to demonstrate century cutoffs and not...

Hi,

How do we filter the result using WHERE and HAVING clause as used in group by

Say like...

select MAX(TaxRate) AS 'Tax Rate',StateProvinceID

from Sales.SalesTaxRate where Name <> 'Canadian GST'

group by StateProvinceID

having...

Thanks for posting this.

I am new to SQL server programming. Though both question and answer was clear i would like to know the reason or why SQL server is...

Pradeep, Thanks for the update. The link you provided was very useful.

Hi,

Thanks for posting this. I have few clarification on COALESCE result type and i am confused the type conversion.

Consider the case below.

--Case 1

DECLARE

Hi,

Thanks for the update.

Still few more clarification needed.

We have 8192 bytes of page. 96 bytes is used for header information.In my above example 16 bytes will be reserved for offset...

Hi,

But another sample query as shown below gives expected result which contradicts from while loop.

DECLARE @i float

set @i = .9

set @i = @i + .1

-- Query 1

if @i <> 1

print...