Viewing 15 posts - 2,191 through 2,205 (of 3,221 total)
badkow
It would help those who want to help you to have some further information. Can you post the table definition, perhaps some sample data (does not have to be...
January 17, 2010 at 4:51 pm
Clicked on Compare-28Jan
Go this reply
Sorry, an error has occurred
If problems persist, please contact us to let us know.
January 17, 2010 at 4:48 pm
Clicked as I normally do on Prompt-17August
and got this
Sorry, an error has occurred
If problems persist, please contact us to let us know.
January 17, 2010 at 4:46 pm
A further few hints. Never ever send a cover letter/resume to a Chief Technical Officer or IT Manger in which you ask for a job. In many companies...
January 16, 2010 at 11:19 am
Did a quick search (google) and Results 1 - 10 of about 2,830,000 for resume cover letter samples. Might find a few you can use by cutting and pasting...
January 16, 2010 at 10:34 am
Now if you desire to have your first batch of T-SQL function, that is create a temp table, in one connection and query it from another connection, create a GLOBAL...
January 15, 2010 at 4:41 pm
Go to this posting by Lynn Pettis for almost every useful datetime T-SQL examples.
https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx[/url]
I am sure you will find what you need in the extensive listing.
January 15, 2010 at 11:17 am
Saurabh Dwivedy
Isn't the purpose of the question to test the understanding that an explicit BEGIN TRANSACTION is not actually required in case ANSI_DEFAULTS are on?
Yes that was the purpose of...
January 14, 2010 at 10:20 am
I guess the answer to your question is "It depends"
Search TECHNET at:
http://technet.microsoft.com/en-us/default.aspx
using as the search words "SQL Server computed columns" and it will list for you a good deal...
January 14, 2010 at 10:09 am
Purchase my copy of SQL Server 2008 Developer Edition for 50 USD from Anazon.com .. just checked and price is now down to 40.49 Here is the link I...
January 14, 2010 at 9:21 am
ChiragNS
learnt something new , but i think this is not used regularly or am i wrong?
My off the cuff answer is that universal "It all depends"
Read this page...
January 14, 2010 at 7:34 am
Your revised T_SQL to adjust the calculated value of MonthsInService appears to do the job properly .. Go ahead and test further.
Have you considered eliminating the computed...
January 14, 2010 at 7:23 am
If this is a one time event - have you considered using the upsizing wizard available in Access - very, very simple to use and no work writing a script
January 13, 2010 at 6:12 pm
Nickson Asiimwe
Pardon me for injecting this comment, but I believe your problem to some extent currently lies outside of being a T-SQL problem. Rather it lies in the...
January 13, 2010 at 8:51 am
Kevin Gill
From
SQL Server 2008 Books Online (November 2009)
SET ANSI_DEFAULTS (Transact-SQL)
AT:
http://msdn.microsoft.com/en-us/library/ms188340.aspx
When enabled (ON), this option enables the
In my explanation all I did was add the words "SET IMPLICIT_TRANSACTIONS" to...
January 13, 2010 at 6:49 am
Viewing 15 posts - 2,191 through 2,205 (of 3,221 total)