LutzM

Forum Replies Created

Viewing 15 posts - 3,391 through 3,405 (of 5,502 total)

RE: Want to insert Blank inside the main table instead of Null

Now, all that's still missing are some sample data (in an INSERT INTO SELECT format) to play with that would match your expected result so we have something to test...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 1, 2010 at 1:20 pm

#1174989
RE: SSPI handshake

No problem.
The reason why some of us tend to add the "duplicate post" information ist to make sure the answers are all within one thread. That makes it easier for...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 1, 2010 at 1:17 pm

#1174988
RE: Want to insert Blank inside the main table instead of Null

If you would provide table definition, sample data and expected result in a ready to use format as decribed in the first link in my signature I'm sure there will...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 1, 2010 at 12:53 pm

#1174977
RE: SSPI handshake

duplicate post.
Discussion already started here.

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 1, 2010 at 12:45 pm

#1174972
RE: Script to continuously insert data

Lowell (6/1/2010)
CREATE TABLE [Test] (col1 bit)
DECLARE @endDate datetime
SET @endDate = DATEADD(hh,8,GETDATE()) -- 8 hours from now
WHILE GETDATE() < @endDate
BEGIN
INSERT INTO [Test]...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 1, 2010 at 12:10 pm

#1174953
RE: Collapsing a Table

Ok, here's what I came up with: It's a "double self referencing" table.
The first one (sub) is used to eliminate consecutive rows and the second one (final select) gets the...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

May 31, 2010 at 4:45 pm

#1174603
RE: Collapsing a Table

I've been trying to come up with a self referencing solution, but I'll give up now since I won't be able to come even close to your solution. :crying:

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

May 31, 2010 at 4:19 pm

#1174598
RE: Collapsing a Table

Jeff Moden (5/31/2010)
lmu92 (5/31/2010)
I'm not sure if this is the fastest way, but at least it's an option... 😉
That seems to loose the bubble when the ranges on the same...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

May 31, 2010 at 3:39 pm

#1174596
RE: Collapsing a Table

I'm not sure if this is the fastest way, but at least it's an option... 😉
;
-- unpivot and group the values
WITH upvt AS
(
SELECT Val
FROM
(SELECT START,[END]
FROM @rangeTable)...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

May 31, 2010 at 12:11 pm

#1174572
RE: Script to continuously insert data

Please be a little more specific regarding the table/data structure you want to insert.
Otherwise, you might see a script like the following to enter a few thousand rows into a...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

May 30, 2010 at 4:45 pm

#1174367
RE: INSERT BULK execute with @variables

You're very welcome 🙂

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

May 30, 2010 at 7:55 am

#1174327
RE: ADD column storeID while bulk inserting

daniarchitect (5/30/2010)
Unfortunatley our company uses DB2 as main database ,
but they have sql server on side which is version 2000.
I ask apology for posting it here,but that was the only...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

May 30, 2010 at 7:36 am

#1174324
RE: INSERT BULK execute with @variables

You need to use the real file names instead of @txtFile and @xmlFile.
The following should work:
SET @SQLString = 'INSERT INTO competition (Competition_ID,Competition,Title,Parent_ID) '
+ 'SELECT Competition_ID,Competition,Title,Parent_ID '
+ 'FROM OPENROWSET(BULK '...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

May 30, 2010 at 7:27 am

#1174323
RE: For XML to decimal datatype

You need to add precision and scale when converting to DECIMAL. Otherwise it will use the default values (DECIMAL(18,0)) leading to integer values.
Try
SELECT
ISNULL(CONVERT(DECIMAL(20,2),@val),2) AS [column1]
FOR XML RAW('row'), elements, root('XMLData'),...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

May 30, 2010 at 2:52 am

#1174309
RE: Getting the Message

I agree with rwatson and, partially, with futura.
However, we managed to use ServiceBroker to replace a job that repeated every minute to check if new data are available... It took...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

May 30, 2010 at 2:47 am

#1174308

Viewing 15 posts - 3,391 through 3,405 (of 5,502 total)