Viewing 15 posts - 1,006 through 1,020 (of 5,504 total)
Jeff Moden (9/8/2011)
Consider which letters may occur between ZA9999 and ZZZZZZ. You can spell some pretty offensive words with just the 5 letters. 😉
Now, I realize that you...
September 8, 2011 at 11:55 am
Ninja's_RGR'us (9/8/2011)
LutzM (9/8/2011)
I'm confused: you started a new thread after getting several replies on the other thread?(http://www.sqlservercentral.com/Forums/FindPost1171968.aspx)
Why?
Edit: Sorry, Remi. Didn't see your reply. :blush:
I said, NO MORE REPLIES 😀
Now you...
September 8, 2011 at 11:31 am
I'm confused: you started a new thread after getting several replies on the other thread?
(http://www.sqlservercentral.com/Forums/FindPost1171968.aspx)
Why?
Edit: Sorry, Remi. Didn't see your reply. :blush:
September 8, 2011 at 11:25 am
Jeff Moden (9/7/2011)
SQLServerMS (9/7/2011)
I need to populate the values for a column in a sequential manner as below, these need to be auto generated:
i1st it starts with
000001
000002
......
999999
A00001
A00002
......
A99999
B00001
......
B99999
......
Z99999
ZA0001
......
ZA9999
......
ZZZZZZ
How can i...
September 8, 2011 at 11:18 am
Something like
SELECT RIGHT(100000000 + ID, 8)
FROM YourTable
September 7, 2011 at 12:28 pm
SQLRNNR (9/7/2011)
Stefan Krzywicki (9/7/2011)
SQLRNNR (9/7/2011)
SQLkiwi (9/7/2011)
Stefan Krzywicki (9/7/2011)
OK, who had 9/7/2011 in the end of the world pool?Hmm. Where's the incentive to win?
You get a billboard posted by a...
September 7, 2011 at 12:20 pm
fails on Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (Intel X86)
with
Msg 4060, Level 11, State 1, Line 65536
Cannot open database "Corrupt" requested by the login. The login failed.
Msg...
September 7, 2011 at 10:08 am
Please attach the actual query since the execution plan does not show the full query.
My pot shot would be this task would benefit from a divide'n'conquer approach (based on the...
September 6, 2011 at 1:15 pm
I just hope the logic that's being used is protected against SQL injection... But that's a different story.
In the scenario described I would run a server side trace. While running...
September 6, 2011 at 1:01 pm
Roy Ernest (9/6/2011)
Yes, I live in a paradise. 🙂 White sandy beaches. No winter, No shark attacks yet..!!! 🙂
It is also famous for a place called Campo...
September 6, 2011 at 12:29 pm
GSquared (9/6/2011)
LutzM (9/6/2011)
Ninja's_RGR'us (9/6/2011)
...Here's the full album from that day! Enjoy and dream on!
http://s1123.photobucket.com/albums/l551/Ninja_RgRus/Sunrise%20August%2023rd%202011/
Do you know it seems like you're living in a place others would pick for...
September 6, 2011 at 12:26 pm
You could run a server side trace (PROFILER trace, but not using the GUI) to capture the calls of the sproc. This will show the actual parameter used.
Another option could...
September 6, 2011 at 12:20 pm
Ninja's_RGR'us (9/6/2011)
...Here's the full album from that day! Enjoy and dream on!
http://s1123.photobucket.com/albums/l551/Ninja_RgRus/Sunrise%20August%2023rd%202011/
Do you know it seems like you're living in a place others would pick for vacation? Do...
September 6, 2011 at 12:09 pm
Is V_SMPN_gerentes a view? If so, please post the view defintion, too.
September 6, 2011 at 12:02 pm
@Remi:
That's what I call quite an achievement!! Awesome!
My personal "records":
1) a search function frequently called from an application from 30+ seconds to less than half a second (moved the queries...
September 6, 2011 at 11:56 am
Viewing 15 posts - 1,006 through 1,020 (of 5,504 total)