Viewing 15 posts - 61 through 75 (of 443 total)
Excellent question if you ignore the minor errors. Made me investigate a feature I was not aware of.
Thank you
November 3, 2011 at 5:02 am
Dev @ +91 973 913 6683 (10/18/2011)
Kudos to the respondents for cleaning it up
Not only cleaning it up but also to encourage new guys to come upfront as...
October 19, 2011 at 2:00 am
SQLRNNR (10/18/2011)
nigel. (10/18/2011)
Sean Lange (10/18/2011)
... 😛...edited...
Nigel - could you also edit the quote since Sean edited his original comment and apologized?
Kudos to the respondents for cleaning it up:-)
Done!
October 19, 2011 at 1:58 am
Dev @ +91 973 913 6683 (10/17/2011)
What's New in SQL Server 2008 R2
.
.
.
Are you trying to bully OP? :unsure:
No, I don't think he is. Just making a point...
October 18, 2011 at 10:01 am
priya.pk20 (10/17/2011)
October 18, 2011 at 9:58 am
Steve Jones - SSC Editor (10/18/2011)
October 18, 2011 at 8:13 am
Had already had first coffee before attempting to answer this. 😀
Good question, thanks
October 17, 2011 at 3:31 am
Almost. 😉 You also need to subtract 12 hours when the time is 1300 hrs or later. Similar to Gianlucas earlier solution.
SELECT
CONVERT(VARCHAR(30),
...
October 5, 2011 at 8:56 am
skra (10/4/2011)
I am surprised that anyone is still reading it since it was published in february 2008 🙂
It is the "Featured Script" in todays news letter.
October 4, 2011 at 3:20 am
Have a look at this too, by Itzik Ben-Gan:
http://www.sqlmag.com/article/sql-server/virtual-auxiliary-table-of-numbers
Should perform better than a recursive CTE.
October 4, 2011 at 3:03 am
Lowell (10/2/2011)
pramany (10/1/2011)
but i am trying to insert data on multiple base tables in a view.
in order to insert into that view then, you would have to put an instead...
October 3, 2011 at 8:28 am
Slight variation on a previous response that doesn't require the join, and uses QUOTENAME to ensure validity of the table/schema name:
SELECT
'ALTER...
September 23, 2011 at 9:15 am
hydbadrose (9/20/2011)
For Project_Item 1.1.A I was thinking to use float.
But '1.1.A' is not a valid float its got an 'A' in it. Since when was 'A' a valid digit?
September 20, 2011 at 10:01 am
Given your sample this will tell you your column widths: 🙂
SELECT LEN('A Nat System Must Be band at the Community Level'),
LEN('Milestone #1'),
LEN('A. Develop Protect-Prep Comm'),
LEN('1.1.A')
:w00t:
September 20, 2011 at 9:23 am
Viewing 15 posts - 61 through 75 (of 443 total)