Viewing 15 posts - 2,101 through 2,115 (of 3,221 total)
Imu92
My apologies ... for not being more careful .... anyway I hope the end result is that to poster of the question will understand it better than I did
Again...
February 14, 2010 at 5:07 pm
Have used extended properties, and it works well, if your description is well written. If your description of what table is and why it exists, and what each column...
February 14, 2010 at 5:02 pm
lmu92 Your code:
UPDATE #SalaryHistory SET #SalaryHistory.salaryamount = cte3.salaryamount
SELECT cte3.*
FROM cte3 INNER JOIN #SalaryHistory ON cte3.rowid=#SalaryHistory.rowid
Your code kept giving me an error The multi-part identifier "cte3.salaryamount" could not be bound after...
February 14, 2010 at 4:42 pm
Iggy-SQL
Check out this link:
SQL Server 2005 Books Online (November 2008)
Reporting Services Enhancements
http://technet.microsoft.com/en-us/library/ms170438(SQL.90).aspx
This may clear up some of the confusion then again it may not
February 14, 2010 at 3:03 pm
bitbucket-25253 (2/14/2010)
--------------------------------------------------------------------------------
Tom.Thomson
Yes, it's a good clear question, a correct answer, and an "explanation" which doesn't explain anything at all about why that is the correct answer
emphasis above added by this...
February 14, 2010 at 2:53 pm
From the question
under timeout (in dataset):
Sorry to say this but the page referenced in the explanation does not match the Microsoft page:
SQL Server 2008 Books Online (November 2009)
How to:...
February 14, 2010 at 11:57 am
Tom.Thomson
Yes, it's a good clear question, a correct answer, and an "explanation" which doesn't explain anything at all about why that is the correct answer
From the reference cited in...
February 14, 2010 at 9:54 am
Is there an efficient way to handle large # of columns in a db like there's the views concept of large # of rows?
Remember a view only contains the columns...
February 13, 2010 at 4:47 pm
3. I have heard about a CTE being a new feature in sql server 2005. Can you point me to a URL where a CTE can be used with alot...
February 13, 2010 at 4:35 pm
John Many thanks for the correction .. next time I will pay more attention to this line in my signature block:
If everything seems to be going well, you have...
February 13, 2010 at 12:03 pm
subbarayudu.net 37258
From Books On Line (BOL) the help file for SQL Server:
Granting and Denying Permissions to Users and Roles
Permissions within a database are always granted to database users, roles,...
February 13, 2010 at 9:38 am
subbarayudu.net 37258
In the window in the upper right hand corner of this forum input "transaction log' in the next window that shows select only
"Articles" and "blogs" you will then...
February 13, 2010 at 9:14 am
WebTechie38
Now without any data supplied by you, I searched the SSC site and found this very interesting article and sample code:
When's Your Anniversary
By Steve Jones, 2003/11/11
http://www.sqlservercentral.com/articles/Advanced+Querying/anniversary/496/%5D
True it returns birthday...
February 13, 2010 at 8:40 am
Could you supply some sample data, using the format described in the article in my signature block .... that is
INSERT INTO .......................
SELECT ' '. ''' ,.... UNION...
February 12, 2010 at 5:01 pm
You might want to download and use:
Microsoft SQL Server 2008 Upgrade Advisor
Brief Description
Download the Microsoft SQL Server 2008 Upgrade Advisor. Upgrade Advisor analyzes instances of SQL Server 2000 and SQL...
February 12, 2010 at 4:45 pm
Viewing 15 posts - 2,101 through 2,115 (of 3,221 total)