Viewing 15 posts - 106 through 120 (of 621 total)
CELKO (9/6/2012)
Why did you fail to follow minimal Netiquette if you know the basics?
Does anyone else see the irony in this?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 7, 2012 at 6:14 am
CELKO (9/6/2012)
And you need a number that is greater than the number of electrons in the universe!
That's a fairly unprovable assertion in my opinion, as the known substance of...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 7, 2012 at 5:57 am
a4apple (9/6/2012)
Hi, I have edited the post, can you please see now and suggest me a solution?
Not quite there yet. Your values list includes 6 values into table jd,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 6, 2012 at 6:40 pm
Using Vinu's sample data, this might get you pointed in the right direction. Some caveats here though. If there are two instances of event 117 following an event...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 6, 2012 at 3:35 pm
Sean Lange (9/6/2012)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 6, 2012 at 2:59 pm
a4apple (9/5/2012)
I am looking for a sql code that will actually tell me, if I have my status changed the data gets updated if I run it.
I'm not sure what...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 5, 2012 at 12:20 pm
Maybe something like this...
CREATE TABLE dbo.YourNewTable
(
lssID INT IDENTITY(1,1),
[subject] VARCHAR(50),
[desc] VARCHAR(50),
Accepted_date DATE,
Assigned_date DATE
)
But seriously, what is the reason for this? If you turn 3 tables...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 5, 2012 at 11:33 am
Dan, I think Lynn's solution is probably better, but just for academic purposes, you could try something like this...
IF OBJECT_ID('tempdb..#test','u') IS NOT NULL
DROP TABLE #test;
SELECT
'Dan' AS [name],
'123 Main' AS addy,
'555-5555'...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 4, 2012 at 3:30 pm
UmaShankar Patel (9/1/2012)
You need to select query as
select * from @NumberTableorder by Convert(numeric,REPLACE(REPLACE(ItemNumber,'ABC-',''),'-xyz','')) asc
The problem I see with this is that 'ABC' may not always be 'ABC', and 'XYZ' may...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 1, 2012 at 6:41 am
Lynn Pettis (8/29/2012)
Looks like Greg beat me this time.
...And I consider that a great honor Lynn 🙂
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 29, 2012 at 9:21 am
Crazy Nash, I'm no performance expert by any means, nor an index pro, and as you don't give any information with respect to your indexes, there are no guarantees with...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 29, 2012 at 9:09 am
CELKO (8/27/2012)
We do not care
Now let's not be too hasty. Some of us do care. In fact, I'd hazard a guess that if the total number of users...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 28, 2012 at 11:11 am
Luis Cazares (8/28/2012)
PS. I can't stop laughing at all the nonesense from the previous poster.
I mean really. What's wrong with some good ole' constructive feedback, like Sean gave?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 28, 2012 at 11:04 am
Ayeager78, it was not too many years ago I was in a manhole all day splicing phone cable for Ma Bell. While I did not change companys at first,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 22, 2012 at 2:11 pm
SQL Kiwi (6/1/2012)
Updated recursive solution:
Thank you so much Paul. I get everything down to the recursive bit. It's going to take me some time to digest the rest....
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
June 1, 2012 at 5:27 am
Viewing 15 posts - 106 through 120 (of 621 total)