Hi Dwain ,

Very good article.

I read the article,

I didn't read the whole discussion that is going on.

I have one...

oh sorry .i should have tested myself in machine before posting .

Actually ,

confused me.Now its clear .I thought this will directly insert into table...

Thanks.Great article.

so now can do DML operation inside function using TVP.

so database state can be change inside function .

Great Article !

Suppose I create some other type of constraint on table like allow only numeric then how will this type of constraint affect performance ?

Suppose I create computed column...

Hi,

Can you draw the conclusion in other words ?

refer this link,

http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html

http://searchsqlserver.techtarget.com/tip/The-difference-between-CONVERT-and-CAST-in-SQL-Server

you can do this by few ways.

SELECT DISTINCT

(COUNT(TblSuppliers.City)+ COUNT(TblInvoices.ShipCity) + COUNT(TblInvoices.City)+ COUNT(TblCustomers.City)) as total

FROM TblCityRef RIGHT OUTER JOIN

TblSuppliers ON TblCityRef.City = TblSuppliers.City RIGHT OUTER JOIN

TblInvoices ON TblCityRef.City =...

Can't you create one additional table,which will hv its own id(ideneity,id of that table,Createdate (datetime).

Thanks,I got it.

Thanks.

Data is repeating.If I run the query as it is then,

"b/w 24 and 48" is repeating,rather it should show its sum.

Please check my query,only thing is that I am unable...

Hi,

Kindly ignore my language.I never meant that,I am not trying and someone just help me.

I am trying to follow the link u gave.

What I meant was even if someone ...

Sorry,its sql server 2000.

I hv corrected it.

CREATE TABLE [tblTest] (

[TimeId] [int] NOT NULL ,

[EmpId] [int] NOT NULL ,

[weekStartingDate] [datetime] NOT NULL ,

[Totalhours] [decimal](18, 2) NOT NULL

) ON [PRIMARY]

GO

Just someone...

Hi,

Thanks.

Actually,I hv a best practices of Sql server document,where it is mention

like whether to use cursor or not etc and many such thing.

I was expecting equivalent of this document in...

Hi,

Thanks a lot.

This query also work,

SELECT b.block_id, b.total, count(1) AS RowOrder

FROM mytable AS a, mytable AS b

WHERE a.total>=b.total And a.block_id=b.block_id

GROUP BY b.block_id, B.total

HAVING Count(1) BETWEEN 1 AND 2

ORDER BY b.total...

Hi,

how is the date column stored in table,dd/mm/yyyy or mm/dd/yyyy.

convert varchar to datetime,not directly.

Make seperate table with same structure,only change will varchar to datetime column.

Then transfer the whole data to...