Viewing 15 posts - 6,496 through 6,510 (of 10,143 total)
elham_azizi_62 (11/2/2011)
I work with sql server 2008 and windows server 2008.I configure target in odbc properties to %SystemRoot%\SysWOW64\odbcad32.exe and add microsoft visual foxpro driver in UserDSN and select...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
November 2, 2011 at 3:01 am
Stefan Krzywicki (11/1/2011)
ChrisM@Work (11/1/2011)
You're welcome Stefan. I'd be interested to hear what you come up with.
...If I use GetDate in the Execute SQL, it should give me the time I...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
November 1, 2011 at 7:55 am
You're welcome Stefan. I'd be interested to hear what you come up with.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
November 1, 2011 at 6:53 am
Stefan Krzywicki (10/31/2011)
ChrisM@Work (10/27/2011)
Stefan Krzywicki (10/27/2011)
ChrisM@Work (10/27/2011)
Right-click on the white space of a package, select Logging, select what you want...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
November 1, 2011 at 3:08 am
Ugly but it works:
DROP TABLE #Sample
CREATE TABLE #Sample ([Line#] int, Level1 int, Level2 int, Level3 int, Level4 int, Goal CHAR(1))
INSERT INTO #Sample ([Line#], Level1, Level2, Level3, Level4, Goal)
SELECT 1, 102111,NULL,NULL,NULL,...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 31, 2011 at 11:00 am
Jeff Moden (10/30/2011)
ChrisM@home (10/30/2011)
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 31, 2011 at 3:10 am
There are a couple of things I want to confirm using your data.
Firstly, IIRC aggregating the columns separately then adding up the aggregates is quicker than aggregating the sum...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 28, 2011 at 6:21 am
Kiara (10/28/2011)
ChrisM@Work (10/28/2011)
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 28, 2011 at 5:56 am
No worries Ki. There's an aspect of this which is interesting to me and I'll continue to work with it - at home, they wouldn't allow these volumes at work...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 28, 2011 at 5:30 am
bass8117 (10/27/2011)
in the CHRG0.CHRG_AMT column I have a reverse charge of -289.00 with a CHRG0.CHRG_BAL...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 28, 2011 at 2:59 am
Vishal Sinha (10/27/2011)
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 28, 2011 at 1:52 am
Stefan Krzywicki (10/27/2011)
ChrisM@Work (10/27/2011)
Right-click on the white space of a package, select Logging, select what you want to log.
During dev,...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 27, 2011 at 9:29 am
Look at LoggingMode on the properties tab of the package.
Right-click on the white space of a package, select Logging, select what you want to log.
During dev, log just about...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 27, 2011 at 8:28 am
What does the following query return?
SELECT count(*)
FROM TABLE1 AS CC
INNER JOIN TABLE2 AS M ON CC.FORMATTED_PHONE_ADDRESS = M.EMAIL_ADDRESS
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 27, 2011 at 7:56 am
Here's a wee script to get the ball rolling. No PK's / FK's yet (or even indexes), and not even fully normalised, but simple enough to use as a framework...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 27, 2011 at 7:51 am
Viewing 15 posts - 6,496 through 6,510 (of 10,143 total)