u r welcome 🙂

BTW which query did you use out of those three which are there?

I think its exactly what is there here. Please have a look at this discussion,

http://www.sqlservercentral.com/Forums/Topic807524-149-1.aspx

I think thats different level of validation that you may want to put depending on your business needs/justification,

Declare @STR varchar(10)

SET @STR = 'ABCDEFG'

SELECT LEFT (@str,...

dbo.benyos (10/23/2009)

---

Good luck there!

Just don't forget that besides good naming convention for your procedures, T-SQL itself has undergone a long way and is very different than 5 years before, so...

In most of cases that...

Just for fun eh!

Isn't it a case of pivoting?

Test script and data:

drop table #t1

drop table #t2

drop table #t3

Create table #t1(col1 int, col2 varchar(10), col3 int)

Create table #t2(col1 int, col2 varchar(10),...

Sorry, I aint givin the complete solution. This I guess you would anyway have it. I am really interested to know how anyone will approach this other part of the...

Phil Parkin (10/21/2009)

---

Try removing the T2 aliasing and writing out the full name of the table. You cannot alias a table in the first line of an update statement, even...

Will this do?

Select * from T1

LEFT JOIN T2

ON T1.id = T2.id

Where T2.Id IS NULL

This is something what you would like to do, but its meaningless.

CREATE TABLE #tSTATUS (FLAG varchar(1))

INSERT INTO #tStatus VALUES ('Y')

INSERT INTO #tStatus VALUES ('Y')

INSERT INTO #tStatus VALUES ('Y')

INSERT INTO #tStatus...

u r welcome 🙂

Will this do??

DROP TABLE ORDERS

CREATE TABLE ORDERS(OrderNo int, OrderDate datetime, Cost int, PreviousCost int, NewCost int)

Delete from Orders

INSERT INTO ORDERS VALUES(1, '2009-09-19', 100,0,0)

INSERT INTO ORDERS VALUES(2, '2009-10-19', 200,0,0)

INSERT INTO ORDERS...

Please dont think I am doubting/underestimating your sqlserver database understanding. Just wanted to know if you understand these things please?

1. First query returns the rows from softwareProduct table where product...

nothin here, please move on. Some technical glitch!

I think requirement is bit incomplete,

you have a orderdate column, What if there are multiple orders in the previous month and what if there are multiple records in the...