Try this:

--update table

--set ecode = NULL

select * from table

where

patindex('%[^0-9]%', @Str) > 0

or

...

Try this:

;with cte as

(

select row_number() over ( partition by site_key, p_key order by SiteVR_key desc ) RN ,*

from #t1

)

select * from cte where rn =...

Andrew , are u trying to find if your SQL Server Version is 2005 or 2008 ? or rather which version of SQL Server?

Jaime , how many databases do u have in your system??

WILLIAM MITCHELL (8/4/2010)

---

Also, because information_schema includes not only tables but views, and has no column to distinguish between them, you have to inspect the results to find which are actual...

WayneS (8/3/2010)

---

ColdCoffee (8/3/2010)

---

WayneS (8/3/2010)

---

ColdCoffee (8/2/2010)

---

Wayne, awesome job in that explanation , mate! Thanks.. Hope the OP now and the other poster got what the code exactly does.

Also i remember a...

WayneS (8/3/2010)

---

ColdCoffee (8/2/2010)

---

Wayne, awesome job in that explanation , mate! Thanks.. Hope the OP now and the other poster got what the code exactly does.

Also i remember a thread where...

WayneS (8/2/2010)

---

So, you just need to get @@datefirst, and adjust accordingly. Something like:

declare @DateFirst int

set @DateFirst = @@datefirst

SET DATEFIRST...

jvanderberg (8/2/2010)

---

dateadd(wk, datediff(wk, 0, @ThisDate), 0)

This will convert a date into the first Monday of the week that contains it. Group on this date.

Check out Lynn Pettis' wonderful one-stop-shop...

Wayne, awesome job in that explanation , mate! Thanks.. Hope the OP now and the other poster got what the code exactly does.

Also i remember a thread where RBarryYoung takes...

Going through you request, i found that Table Partitioning might do the trick for you.. Me, in my sytem, implemented this Partition for Archive data; which is maintaining only the...

You cant do that ways... You will have to insert the matching values into a temp table and then join them both.. I have another code as well to accomplish...

Will this help you, sire?

WITH CTE AS

(

SELECT Cust.ID ,Cust.CustomerName , Cust.OrderDate , Items.ProductName , Items.Quantity

FROM TestCustomerOrders Cust

JOIN TestCustomerOrderItems Items

ON Cust.ID = Items.TestCustomerOrdersID

)

SELECT p1.id ,CustomerName...

Are there any flaws on the data provided, sir? whats the relation between [TestCustomerOrderItems] and [TestCustomerOrders] ??

Is [TestCustomerOrders].[ID] = [TestCustomerOrderItems] .[TestCustomerOrdersID] ??

Cool man :cool:, i wondered if u would take that lightly! Well, nicee... 😉