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?
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...
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,...
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...
September 6, 2012 at 3:35 pm
Sean Lange (9/6/2012)
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...
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...
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'...
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...
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 🙂
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...
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...
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?
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,...
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....
June 1, 2012 at 5:27 am
Viewing 15 posts - 106 through 120 (of 621 total)