Hi Scott...

You have some minor errors you need to fix... (found in 2k, and 2k5)

Msg 102, Level 15, State 1, Procedure fnc_AllowNumbersOnly, Line 8

Incorrect syntax near '?'.

Msg 102, Level 15,...

Which version of SQL are you using? 2000, 2005, or ???

Any chance of changing the design to something a bit more normal instead of storing seconds for hours, minutes, and seconds?

Also, what have you tried? Generally speaking, you should...

Spend %50-60 USD on SQL Server 2005 Developers edition... install it on your home PC. Start answering/verifying questions on this forum... you'll stay current.

But it does takes some...

Um... is [DC-Base] the changing part number you're referring to? And, if so, what is the datatype of that column?

Yep... that and recompiles... because of the 1=1 trick to make it easier to form a WHERE clause,...

Which sites did you try that you were disappointed with?

Just because a proc may run more than once concurrently, I try to never name constraints on temp tables.

Or, maybe in the process 😀

Thanks for the links and info, Tom... I'll take a look.

You certainly don't need any prefixes to make them run. So far as not being able to tell what the views are used for, that's thanks to the lack...

Ok... I'm just going to go ahead and guess you meant "shrinking" TempDB... 😉

Yes... you may shrink the "files" associated with TempDB as you would any other database. It...

Yes... here's the syntax from Books Online (comes free with SQL Server)...

SET IDENTITY_INSERT [ database. [ owner. ] ] { table } { ON | OFF }

... but, generally, there's...

adshisode85 (5/30/2008)

---

I have only column in my table and i want to display values in table columnwise. like this

1 6

2 7

3 ...

Howdy folks,

Someone who wishes to remain anonymous, send me an email asking the following questions related to this article. I've not worked with SQL Server 2008 (shoot, I'm just...