Viewing 15 posts - 436 through 450 (of 1,183 total)
Here's the jist of it.....
DECLARE @myTable TABLE
(val1 CHAR(9)
,val2 CHAR(9)
,val3 CHAR(5)
,val4 CHAR(9))
INSERT @myTable
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 26, 2009 at 2:36 pm
I found that my ASSUMPTIONS were wrong... LOL
I create a SQL Dataset/Command and ASSUMED that the parameters for that command are "linked" to the report when the Dataset is linked....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 22, 2008 at 4:25 pm
Jeff Moden (11/17/2008)
You might not want to use a pivot... please see the following... especially the performance chart near the end of the article...
Might I hope that you always continue...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 17, 2008 at 11:39 pm
B (11/17/2008)
Jason is right.... Why didn't I see the obvious?!?!B
You just made it more complicated than it was. 🙂 It happens to all of us.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 17, 2008 at 4:13 pm
No need for CTE here. the pivoted columns exist as columns in the outer level so you can simply add them together there.
SELECT
OS
,Severity
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 17, 2008 at 4:08 pm
The problem is that the line number is NOT a column in the source file.
I tested with a file of 10 million rows and it worked fine, but that's not...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 17, 2008 at 10:19 am
I have a PK on the table, and the original file's line number is all that is important. That is, I'm not concerned how it is stored in the table,...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 16, 2008 at 3:24 pm
Emilio.Mendoza (7/8/2008)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 8, 2008 at 1:38 pm
Sometimes, just stepping back from the problem, walking around behind it and looking from the other side helps. 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 8, 2008 at 9:41 am
You're close ...
DECLARE @mytable TABLE (IdentityKey INT IDENTITY(1,1), field1 VARCHAR(10))
INSERT @mytable
select 'test1' UNION ALL
select 'test1' UNION ALL
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 8, 2008 at 9:35 am
From BOL ...
.WRITE ( expression, @Offset , @Length )
Specifies that a section of the value of column_name is to be modified. expression replaces @Length units starting from @Offset of column_name....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 8, 2008 at 9:27 am
Sure, create a Tally table and use the below function ....
(compliments to Jeff Moden)
ALTER FUNCTION [dbo].[split]
(@String VARCHAR(8000)
,@Delimiter VARCHAR(5))
RETURNS @RtnValue TABLE
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 7, 2008 at 2:27 pm
I'm still not sure why yours isn't working, but the code below seems to get the correct results. 😀
ALTER TRIGGER [trUpdateBeginVacant]
ON [dbo].[propbut_mi]
FOR INSERT, UPDATE
AS
IF (UPDATE(DDELIVERED) OR UPDATE(DMOVEIN) OR UPDATE(DMOVEOUT))
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 3, 2008 at 1:18 pm
jim.powers (7/3/2008)
It seems like it...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 3, 2008 at 12:49 pm
Change to ... ????
CREATE TRIGGER trUpdateBeginVacant
ON propbut_mi
AFTER INSERT, UPDATE
AS
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 3, 2008 at 12:32 pm
Viewing 15 posts - 436 through 450 (of 1,183 total)