Viewing 15 posts - 9,046 through 9,060 (of 10,144 total)
josemyj (12/30/2008)
¿What do you think about this?;with CTETable (Field) as
(
Select 1 union all Select 2 union all Select 3 ... union all Select n)
)
select * from CTETable;
This...
December 30, 2008 at 4:06 am
Mark (12/29/2008)
For example, I have a column called POINTS. This column stores the total points a user has. ...
December 30, 2008 at 3:55 am
Jeff Moden (12/27/2008)
http://www.sqlservercentral.com/Forums/Topic478330-8-1.aspx#BM480712
Scroll up from that post to see the hell he caused a bunch of people because he thought Sybase...
December 30, 2008 at 12:28 am
debjani.bedajana (12/23/2008)
But I want to show the name of the other Element too in the query result which has not been clicked
No problem - post the query you're currently...
December 24, 2008 at 1:44 am
Double post, see http://www.sqlservercentral.com/Forums/Topic625180-338-1.aspx
December 23, 2008 at 11:42 pm
bitbucket (12/19/2008)
Enjoy your experience as a Scout leader, devote as much care, energy and thought to that as you...
December 22, 2008 at 12:55 pm
Lynn Pettis (12/19/2008)
Are you getting an error? If so, what error. If not, what is the result you are getting, and what are you actually looking for?
cast (Table.column1...
December 20, 2008 at 2:18 am
You'll get a small but noticeable improvement by moving the BEGIN TRAN to between these two lines
--get next available id
...
December 19, 2008 at 12:23 pm
Lynn Pettis (12/19/2008)
December 19, 2008 at 12:12 pm
Jack Corbett (12/19/2008)
[font="Courier New"]SELECT TOP 366
IDENTITY(INT, 1, 1) AS n
INTO
#nums
FROM
sys.all_objects
SELECT...
December 19, 2008 at 11:59 am
Paul
"exception of an internal table used to log traffic"
Can you describe this in full detail please, including table structures and SQL?
Thanks.
December 19, 2008 at 11:54 am
dejanette.gordon (12/19/2008)
December 19, 2008 at 11:51 am
Alan Brownlow (12/19/2008)
December 19, 2008 at 9:20 am
J (12/19/2008)
As shown in my real-life example, the OP data set is only a very restrictive of a larger, PRACTICAL set where length is not fixed. Besides, the OP also...
December 19, 2008 at 9:07 am
bnordberg (12/19/2008)
Chris's works for me (with my samlpe table, I have not adapted to my real mess - err tables)Most will have times associated, some will not.
Thanks for your help!
"It...
December 19, 2008 at 9:00 am
Viewing 15 posts - 9,046 through 9,060 (of 10,144 total)