like this?

you'd have to work out what the criteria for joining the table is though

declare @table table(ID int, UName varchar(10),alert_datetime datetime)

iNSERT INTO @table

SELECT '1','ABC','2011-07-06 14:12:00' UNION ALL

SELECT '2','XYZ','2011-07-06 14:12:10'...

there is an execution time-out option in SQL.

click Tools --> Options... and then choose 'Query Execution' from the resulting popup window.

you will see an option that says 'Execution time-out' which,...

Eugene Elutin (4/17/2012)

---

CELKO (4/16/2012)

---

Yes, but it is bad programming. The PRINT is for debugging and not production code. Think about 100 people calling the same program. You do not want...

brilliant, thanks for the info.

i also used this thread http://www.sqlservercentral.com/Forums/Topic542581-145-1.aspx, based on the table names you gave me, and have found the offending SQL job.

select (select name from sysjobs...

i see. i guess i'll just have to put up with it 🙂 thanks anway!

i was hoping to get it sorted like so:

footballs

footballStates

footballs_MLFlags

footballUnits

footballValidation

footballValidationStates

football_suspend

which is alphabetical from what i can see....

this is a great script! i've already found a number of examples of 'bad' data.

i had to be careful though as i found that names like 'Stuart' and 'Kirsty' are...

ok. thats weird.

my example was totally made up to illustrate my point. Maybe, in making it up, i inadvertently made it less clear what was going on.

Here are my table...

i found something weird. i have two databases with different collations. so if i do:

WITH TBProduct (Description)

AS

(

SELECT 'Nº20' UNION ALL

SELECT 'No Special Characters' union all

select 'Coedcae Comprehensive' union all

select col1...

Rose Bud (3/27/2012)

---

It appears to...

Hugo Kornelis (3/27/2012)

---

That is, apparently,...

Sean Lange (3/27/2012)

---

davidandrews13 (3/27/2012)

---

Important to note. You are creating the view via SSMS and NOT a create view statement. I am not surprised that SSMS expands the actual sql to...

Hugo Kornelis (3/27/2012)

---

davidandrews13 (3/27/2012)

---

bitbucket-25253 (3/27/2012)

---

davidandrews13 (3/27/2012)

---

surely it doesn't matter if you do SELECT *?

every time i create...

bitbucket-25253 (3/27/2012)

---

davidandrews13 (3/27/2012)

---

surely it doesn't matter if you do SELECT *?

every time i create or update a...

Hugo Kornelis (3/27/2012)

---

davidandrews13 (3/27/2012)

That's...

surely it doesn't matter if you do SELECT *?

every time i create or update a view to...