Hi,

Are you try to change the data available from null to desired record, or try to change the table schema?

declare @temp table (col1 varchar(10))

insert into @temp

select '1st' union all

select '15th' union all

select '3rd'...

select * from @test-2

where round(col2,0)- col2 = 0.00

Nice approach cold coffee, a bit change in the statements. It’s should like

select dateadd(dd,N-1,@startdate)

from dbo.tally

where n <= datediff(dd,@startdate,@enddate)+1

SELECT Key1, MAX(VAL1) as MAX1, SUM(VAL2) as SUM2 ,

(case when MAX(VAL1) = 12 then 1

when MAX(VAL1) = 15 then 2

else 0 end) SOMEVALUE FROM @TableVar

GROUP...

Hi Vijay,

The concern is, unless you have any one of the column like identity, date of creating/modify, or row version (timestamp), it’s very difficult/can’t to get the last insert row...

--==To find out the all triggers in the DB==--

SELECT

OBJECT_NAME(parent_obj)TbName ,

[name] TrName,

(CASE WHEN (STATUS & 2048) = 2048 THEN 'Disabled' ELSE 'Enabled' END) Status

FROM sysobjects

WHERE xtype...

Hi,

You find out with the help of profile, this may the customized validation in your application on the sql. Once you catch the procedure/function which is returning with the...

Hi,

Check the DB table index is same with the second table.

Or these second tables for analysis/report purpose ie like the temp purpose than just select with order by class.

Hi,...

Hi,

Suppose you have the table permission and the table exists in the target server, then again check with select statement by,

SELECT * FROM [112.137.162.205].[CCRSVTEAM].[DBO].[TBL_SVDETAILS]

OR

SELECT *

FROM OPENQUERY([112.137.162.205],...

Hi,

I would thing yet it’s by join, but in the wild compares good result, but...

Jeff Moden (3/5/2010)

---

Colin-232036 (3/5/2010)

---

One table has many fields. And in the table,it has a clustered index on a fieldA, and a nonclustered index on a fieldB. I have...

Hi Jeff,

Very cheerful,

Credit to explain in both the versions

🙂

Hi Jeff,

You are good,

“You are not responsible for what people think about you,

But you are responsible for what you give them to think about you” – Stanley Ferrard.