Viewing 15 posts - 10,321 through 10,335 (of 26,489 total)
Something like this maybe?
CREATE TABLE #Sales
(
ClientID int,
SaleDate date
);
INSERT INTO #Sales (ClientID, SaleDate)VALUES (1, '20120131');
INSERT INTO #Sales (ClientID, SaleDate)VALUES (2, '20120131');
INSERT INTO #Sales (ClientID, SaleDate)VALUES (3, '20120131');
INSERT INTO #Sales (ClientID, SaleDate)VALUES...
August 2, 2012 at 2:20 pm
Stefan Krzywicki (8/2/2012)
Lynn Pettis (8/2/2012)
Stefan Krzywicki (8/2/2012)
SQLRNNR (8/2/2012)
Steve Jones - SSC Editor (8/2/2012)
August 2, 2012 at 1:01 pm
Stefan Krzywicki (8/2/2012)
SQLRNNR (8/2/2012)
Steve Jones - SSC Editor (8/2/2012)
August 2, 2012 at 12:55 pm
SQLRNNR (8/2/2012)
Steve Jones - SSC Editor (8/2/2012)
August 2, 2012 at 12:49 pm
L' Eomot Inversé (8/2/2012)
Lynn Pettis (8/2/2012)
Brandie Tarvin (8/2/2012)
What is the difference between sculling and rowing?I Binged your question:
http://www.graftonrowing.asn.au/oldgrcsite/about/row_scul.htm
Don't believe what you read on the internet.
Single oar sculling happens...
August 2, 2012 at 12:48 pm
gsd1 (8/2/2012)
My xml file from web service:
<Rows><row><lastUpdateDate>2009-10-07T15:19:23.000-04:00</lastUpdateDate></row></Rows>
I am pulling data into the temp table like the following:
...
August 2, 2012 at 12:02 pm
Also, this code ran quickly because the data itself is not very wide. You would need to test this is a test environment using your actaul table to determine...
August 2, 2012 at 11:56 am
Reading what opc.three posted I need to agreeregarding the clustered index. I ran the code above once with the primary key being a nonclustered index, and it ran for...
August 2, 2012 at 11:53 am
As soon as you add the column with the IDENTITY property, it will be populated by SQL Server. Even using SET IDENTITY_INSERT you will not be able to change...
August 2, 2012 at 11:49 am
Brandie Tarvin (8/2/2012)
What is the difference between sculling and rowing?
I Binged your question:
http://www.graftonrowing.asn.au/oldgrcsite/about/row_scul.htm
August 2, 2012 at 10:31 am
GSquared (8/2/2012)
It's been a while since I used Erwin, but, last time I used it, it was a serious PITA. Visio works...
August 2, 2012 at 10:10 am
Lynn Pettis (8/2/2012)
Rob Schripsema (8/2/2012)
Lynn Pettis (7/20/2009)
WHERE
...
and [CORE_CO-PERSON].[D-O-B] <= datediff(yy, -16, getdate()) -- where DOB is less than or equal to todays...
August 2, 2012 at 9:52 am
Rob Schripsema (8/2/2012)
Lynn Pettis (7/20/2009)
WHERE
...
and [CORE_CO-PERSON].[D-O-B] <= datediff(yy, -16, getdate()) -- where DOB is less than or equal to todays date 16...
August 2, 2012 at 9:47 am
Unfortunately it is hard to help you when we can't see what you see. If you would post the DDL (CREATE TABLE statement) for the table or tables involved,...
August 2, 2012 at 9:30 am
CELKO (8/1/2012)
have a suggestion Mr. Celko, and it may save you a lot of typing in the future. Look at all your (imho, not so useful) posts...
August 1, 2012 at 8:23 pm
Viewing 15 posts - 10,321 through 10,335 (of 26,489 total)