Viewing 15 posts - 2,161 through 2,175 (of 3,221 total)
Hugo Kornelis and Kelsey Thornton
It is my turn to apologize .... I thank both of you for your constructive comments .... (none were harsh)
I too learned something from the...
January 25, 2010 at 9:16 am
Hugo Kornelis
Not a good explanation, though
Ditto for Kelsey Thornton
Did you click on the supporting documentation link to read the full explanation?
January 25, 2010 at 8:43 am
Mauve
BTW, the code will only run under SQL Server 2008, which wasn't stated. And it will successfully execute.
The question is not wether the CREATE TABLE and INSERT INTO statements...
January 25, 2010 at 8:40 am
From Steve Jones blog post on the Question of the Day
A few notes on submitting a question:
Don’t get too cute, keep your code and the question simple.
Specify the version if...
January 24, 2010 at 8:30 pm
Thank you Mark
If you have any further SQL questions come back and post them to the appropriate forum. Many people who are regulars on SSC go out of their...
January 24, 2010 at 10:01 am
This links to a podcast by Steve .. NOT a printed editorial
Never the less very, very interesting
January 24, 2010 at 9:28 am
cranmer.mark
When I go to File menu, and point to New, the only options I have are:
That instruction pertains to SSMS for versions higher than the Express edition. You have...
January 24, 2010 at 8:56 am
Read this
http://blogs.msdn.com/bonniefe/archive/2008/08/07/sql-server-2008-samples-are-here.aspx
From there
navigate to http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx) to download the sample databases and sample database scripts. We have a lot of sample database installers and now zip files for those...
January 23, 2010 at 2:10 pm
In my past ... I have always informed the customer that prior to beginning work and after discussion with them (at no charge) I will draw up a formal software...
January 22, 2010 at 4:27 pm
find if there are any exact duplicate records in that table.
Here is a CTE to find duplicate records within a single table
;with numbered as(SELECT rowno=row_number() over
(partition by...
January 22, 2010 at 4:13 pm
Since you have two different criteria for deleting may I suggest first deleting using the Pin values for which you could use a CTE such as:
;with numbered as(SELECT rowno=row_number() over
...
January 22, 2010 at 3:18 pm
bercea.nick
Apologies for the lack of clarity - you know, so close to the forest that ya can't see the trees
No need for apologies, if you need assistance, help those who...
January 22, 2010 at 12:59 pm
Try this
-- Shows all user tables and row counts for the current database --
--===Remove OBJECTPROPERTY function call to include system objects
SELECT o.NAME, i.rowcnt FROM sysindexes AS i
...
January 22, 2010 at 12:05 pm
First what is your question?
If it is what I think it is (hmmm) look at Books On Line for the following
SQL Server 2005 Books Online (September 2007)
sys.all_columns (Transact-SQL)...
January 22, 2010 at 11:33 am
Look in Books On Line
SQL Server 2005 Books Online (September 2007)
CREATE TABLE (Transact-SQL)
SQL Server 2005 can have up to two billion tables per database and...
January 22, 2010 at 11:19 am
Viewing 15 posts - 2,161 through 2,175 (of 3,221 total)