Viewing 15 posts - 1,201 through 1,215 (of 3,221 total)
Suggest reading this:
Above article contains:
CREATE TABLE #ConnectionOptions (property VARCHAR(100), value INT)
INSERT #ConnectionOptions
SELECT 'implicit transactions', 2 UNION ALL
SELECT 'cursor close on commit', 4 UNION ALL
SELECT 'ansi warnings', 8 UNION ALL
SELECT 'ansi...
May 28, 2011 at 5:59 am
Here is what we expected from you, remember you are closest to the problem and we are not, so you may have something that you are aware of and we...
May 27, 2011 at 5:25 pm
Steve Jones - SSC Editor (5/27/2011)
bitbucket-25253 (5/27/2011)
May 27, 2011 at 3:47 pm
Difficult to answer your question without some sample data and desired results.. could you post same? For ease of posting readily consumable data please click on the first link...
May 27, 2011 at 11:32 am
Stefan Krzywicki (5/27/2011)
Lynn Pettis (5/27/2011)
Stefan Krzywicki (5/27/2011)
GSquared (5/27/2011)
Stefan Krzywicki (5/27/2011)
GSquared (5/27/2011)
ALZDBA (5/27/2011)
GilaMonster (5/27/2011)
Elliott Whitlow (5/26/2011)
Jan Van der Eecken (5/26/2011)
GilaMonster (5/26/2011)
From the posts the person has made,...
May 27, 2011 at 11:09 am
Having served as a volunteer at the same event, I agree with all that you have said. But would add that the speaker's dinner the night before was...
May 26, 2011 at 1:03 pm
Is this what you want?
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[T_computedCols](
[Col1] [int] NOT NULL,
[Col2] [int] NOT NULL,
[col3] AS ([col1]+[col2]),
[col4] AS ([col2]+(1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_computedCols] ADD CONSTRAINT...
May 26, 2011 at 11:00 am
WayneS (5/23/2011)
bitbucket-25253 (5/23/2011)
bitbucket-25253 (5/23/2011)
WayneS (5/23/2011)
bitbucket-25253 (5/23/2011)
QOD - easy enough to display the page to create and submit etc., etc.
When...
May 23, 2011 at 11:35 am
bitbucket-25253 (5/23/2011)
WayneS (5/23/2011)
bitbucket-25253 (5/23/2011)
QOD - easy enough to display the page to create and submit etc., etc.
When the submittal...
May 23, 2011 at 8:36 am
WayneS (5/23/2011)
bitbucket-25253 (5/23/2011)
QOD - easy enough to display the page to create and submit etc., etc.
When the submittal page...
May 23, 2011 at 8:16 am
A plea for assistance, from the denizens of the thread.
QOD - easy enough to display the page to create and submit etc., etc.
When the submittal page displays mine...
May 23, 2011 at 6:42 am
1. Do you have a question about the code?
a. Does the code when executed fail and return an error?
2. Does your code...
May 21, 2011 at 8:02 am
Sean Lange
"the system does exactly what they asked for, unfortunately what they asked for isn't what they want".
In the distant past at a location far away an analysis of...
May 20, 2011 at 8:29 am
Here is a step by step possible solution for you to walk through and combine statements when you understand them and of course want to.
DECLARE @St AS Datetime
DECLARE @et...
May 19, 2011 at 8:53 pm
Viewing 15 posts - 1,201 through 1,215 (of 3,221 total)