Listing words with no of occurances in sql server

Hi,
Is it possible to get words from text columns in a sql server database in the order of their occurances in that column with full text search or by any other method.
Thanks in advance.try this approach -- Simple Keyword Relevance (http://r937.com/keyword_relevance.html)|||:cool:

My query is regarding retreiving words from table on the bases of its maximum occurances in column irrespective of a row.

means a word that appears maximum number of times in a column, suppose if i have 10 rows in a table and word "Globe" appears maximum no of times say in 5 rows i want Globe word on the top.

Thanks in advance.|||select wordcolumn
, count(*) as occurrences
from daTable
group
by wordcolumn
order
by occurrences desc|||Hi,
Thanks for quick reply...

This could solve my problem if reffered column contain only single word at a time.
But this column is varchar column containing text of multiple words.

Any suggestion?

Thanks|||ok, that's going to require that you split out every word in the column individually

this may require a cross join with a numbers table

what's this for? how often are you going to use it?

the query will definitely not be easy to write, nor efficient to run|||Please read the sticky at the top of the board and post what it asks for...we need some examples|||you gonna write the query, brett?

here's an example --create table somewords
( id integer not null primary key identity
, blah text not null
);
insert into somewords (blah)
values ('a word that appears maximum number of times in a column')
insert into somewords (blah)
values ('Is it possible to get words from text columns in a sql server database')
insert into somewords (blah)
values ('This could solve my problem if reffered column contain only single word')
insert into somewords (blah)
values ('that''s going to require that you split out every word in the column individually')
insert into somewords (blah)
values ('the query will definitely not be easy to write')
insert into somewords (blah)
values ('Please read the sticky at the top of the board')
insert into somewords (blah)
values ('The physical order of data in a database has no meaning')i'm sure you understand the requirement -- which word occurs the most frequent?|||Hi,

r937 quoted the right example and i am sure he understood the problem.

I need it often in my application.

If you say to split words in multiple columns, the problem here is we are not sure about maximum number of words in field.|||Is this for doing a search and ranking the results based on multiple search criteria...if it is then Rudy did not understan...because what you are asking makes no sense

Is it really show me for all rows in a table, the rows with the most occuring types?

If it is, and you need to "do that alot", what in heavens name for?|||Oh, and why would you need a query

http://www.google.com/search?hl=en&lr=&safe=off&q=a&btnG=Search

About 8 billion hits

I think that would "win"|||the question is really very simple, brett

refer to the sample data which i posted (which you wanted to see), and answer the question: which word occurs most frequently in the blah column? hint: it isn't the word "data" and it isn't the word "word"|||OK, well, you would have to start be decontructig the data...but I still don't know what for or why there would be a need for this

create table somewords
( id integer not null primary key identity
, blah text not null
);
insert into somewords (blah)
values ('a word that appears maximum number of times in a column')
insert into somewords (blah)
values ('Is it possible to get words from text columns in a sql server database')
insert into somewords (blah)
values ('This could solve my problem if reffered column contain only single word')
insert into somewords (blah)
values ('that''s going to require that you split out every word in the column individually')
insert into somewords (blah)
values ('the query will definitely not be easy to write')
insert into somewords (blah)
values ('Please read the sticky at the top of the board')
insert into somewords (blah)
values ('The physical order of data in a database has no meaning')
GO

CREATE TABLE UniqueWords (
Word varchar(256)
, WordId int IDENTITY(1,1)
, Add_Dt datetime DEFAULT (GetDate()))
GO

CREATE UNIQUE INDEX UnqueWords_PK ON UniqueWords(Word)
GO

CREATE PROC isp_INS_UNIQUE_WORDS
AS
BEGIN
SET NOCOUNT ON
DECLARE @.Words INT, @.Pos INT, @.x Int, @.str varchar(256)
, @.word varchar(256), @.start int, @.end int, @.exitstart int
SELECT @.Words = 0, @.Pos = 1, @.x = -1, @.Word = '', @.start = 1

DECLARE myCursor CURSOR FOR SELECT Blah FROM SomeWords
OPEN myCursor
FETCH NEXT FROM myCursor INTO @.str

WHILE @.@.FETCH_STATUS = 0
BEGIN
WHILE (@.x <> 0)
BEGIN
SET @.x = CHARINDEX(' ', @.str, @.Pos)
IF @.x <> 0
BEGIN
SET @.end = @.x - @.start
SET @.word = SUBSTRING(@.str,@.start,@.end)
IF NOT EXISTS (SELECT * FROM UniqueWords WHERE Word = @.Word)
INSERT INTO UniqueWords(Word) SELECT @.word
-- SELECT @.Word, @.@.ROWCOUNT,@.@.ERROR
-- SELECT @.x, @.Word, @.start, @.end, @.str
SET @.exitstart = @.start + @.end + 1
SET @.Pos = @.x + 1
SET @.start = @.x + 1
SET @.Words = @.Words + 1
END
IF @.x = 0
BEGIN
SET @.word = SUBSTRING(@.str,@.exitstart,LEN(@.str)-@.exitstart+1)
IF NOT EXISTS (SELECT * FROM UniqueWords WHERE Word = @.Word)
INSERT INTO UniqueWords(Word) SELECT @.word
-- SELECT @.Word, @.@.ROWCOUNT,@.@.ERROR
-- SELECT @.x, @.Word, @.exitstart, LEN(@.str)-@.exitstart, @.str
END
END
FETCH NEXT FROM myCursor INTO @.str
SELECT @.Words = 0, @.Pos = 1, @.x = -1, @.Word = '', @.start = 1
END

CLOSE myCursor
DEALLOCATE myCursor
SET NOCOUNT OFF
RETURN @.Words
END
GO

EXEC isp_INS_UNIQUE_WORDS
GO

SELECT * FROM UniqueWords ORDER BY Word
GO

DROP PROC isp_INS_UNIQUE_WORDS
DROP TABLE UniqueWords, somewords
GO

I'm gonna blog this|||...but I still don't know what for or why there would be a need for this

You don't think there's a use for data mining on simple text?

let's see...

military intel
or
political speech analysis
or
most occurences in scientific notation
...|||brett! dude!! that's wonderful! and the cursors, so pretty!!

now, any chance you could actually address the problem as initially posted?

which word occurred the most often?

boy it's taking you a long time to catch on

:)|||boy it's taking you a long time to catch on

:)

Well, I'll have to step back aand rethink this then

I thought you would need a list of unique words in another table, then perhaps join to it...and something else...don't know...thought the deconstructing thing was a fun puzzle, of which I would have no other way to do that

I was think of something like

...oh jeez, I don't know what I was thinking|||well...I guess I don't know what I'm talking about...especially sice the req is not very clear

Listing my indexes...

Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
retrieve a list of all indexes for mytable. Under the "Name" column, I
notice several indexes that begin with "_WA" that aren't indexes I created;
I'm assuming these are SQL-internal indexes. Can someone explain what these
indexes are?
My ultimate goal is to populate a cursor with the names of my indexes and
then loop thru this cursor to perform a DBCC INDEXDEFRAG of these indexes.
This will eventually become a scheduled job that runs weekly. However, I
don't want to be defragmented useless indexes (or those that I haven't
intentionally built).
Any pointers, insights would be appreciated.
Thanks
Roz
Look at example E in the DBCC SHOWCONTIG topic in Books Online.
Jacco Schalkwijk
SQL Server MVP
"Roz" <Roz@.discussions.microsoft.com> wrote in message
news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
> Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
> retrieve a list of all indexes for mytable. Under the "Name" column, I
> notice several indexes that begin with "_WA" that aren't indexes I
> created;
> I'm assuming these are SQL-internal indexes. Can someone explain what
> these
> indexes are?
> My ultimate goal is to populate a cursor with the names of my indexes and
> then loop thru this cursor to perform a DBCC INDEXDEFRAG of these indexes.
> This will eventually become a scheduled job that runs weekly. However, I
> don't want to be defragmented useless indexes (or those that I haven't
> intentionally built).
> Any pointers, insights would be appreciated.
> Thanks
> Roz
|||Hi Roz
The _WA_Sys entries in sysindexes are for column statistics, not indexes.
Please read about statistics in the Books Online, and the database option
'auto create statistics'.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Roz" <Roz@.discussions.microsoft.com> wrote in message
news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
> Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
> retrieve a list of all indexes for mytable. Under the "Name" column, I
> notice several indexes that begin with "_WA" that aren't indexes I
> created;
> I'm assuming these are SQL-internal indexes. Can someone explain what
> these
> indexes are?
> My ultimate goal is to populate a cursor with the names of my indexes and
> then loop thru this cursor to perform a DBCC INDEXDEFRAG of these indexes.
> This will eventually become a scheduled job that runs weekly. However, I
> don't want to be defragmented useless indexes (or those that I haven't
> intentionally built).
> Any pointers, insights would be appreciated.
> Thanks
> Roz
|||Also, why reinvent the wheel. Tara Duggan has a proc that does just that.
Here you go:
http://weblogs.sqlteam.com/tarad
"Roz" <Roz@.discussions.microsoft.com> wrote in message
news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
> Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
> retrieve a list of all indexes for mytable. Under the "Name" column, I
> notice several indexes that begin with "_WA" that aren't indexes I
created;
> I'm assuming these are SQL-internal indexes. Can someone explain what
these
> indexes are?
> My ultimate goal is to populate a cursor with the names of my indexes and
> then loop thru this cursor to perform a DBCC INDEXDEFRAG of these indexes.
> This will eventually become a scheduled job that runs weekly. However, I
> don't want to be defragmented useless indexes (or those that I haven't
> intentionally built).
> Any pointers, insights would be appreciated.
> Thanks
> Roz
|||Or why not pick the one which is already in Books Online (under DBCC SHOWCONTIG)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
news:OH%23aPS9sEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Also, why reinvent the wheel. Tara Duggan has a proc that does just that.
> Here you go:
> http://weblogs.sqlteam.com/tarad
> "Roz" <Roz@.discussions.microsoft.com> wrote in message
> news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
> created;
> these
>
|||Because her procedure also does the index defrag he's looking to do.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uDgAxQEtEHA.3156@.TK2MSFTNGP12.phx.gbl...
> Or why not pick the one which is already in Books Online (under DBCC
SHOWCONTIG)?[vbcol=seagreen]
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
> news:OH%23aPS9sEHA.1276@.TK2MSFTNGP12.phx.gbl...
that.[vbcol=seagreen]
and[vbcol=seagreen]
indexes.[vbcol=seagreen]
I
>
|||This is exactly what the sample code in BOL, under DBCC SHOWCONTIG does. the sample might have been
added to one of the BOL updates, though, so make sure you all are on current BOL (latest is from Jan
2004). :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
news:%236tbRXGtEHA.3200@.TK2MSFTNGP14.phx.gbl...
> Because her procedure also does the index defrag he's looking to do.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uDgAxQEtEHA.3156@.TK2MSFTNGP12.phx.gbl...
> SHOWCONTIG)?
> that.
> and
> indexes.
> I
>
sql

Listing my indexes...

Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
retrieve a list of all indexes for mytable. Under the "Name" column, I
notice several indexes that begin with "_WA" that aren't indexes I created;
I'm assuming these are SQL-internal indexes. Can someone explain what these
indexes are?
My ultimate goal is to populate a cursor with the names of my indexes and
then loop thru this cursor to perform a DBCC INDEXDEFRAG of these indexes.
This will eventually become a scheduled job that runs weekly. However, I
don't want to be defragmented useless indexes (or those that I haven't
intentionally built).
Any pointers, insights would be appreciated.
Thanks
RozLook at example E in the DBCC SHOWCONTIG topic in Books Online.
Jacco Schalkwijk
SQL Server MVP
"Roz" <Roz@.discussions.microsoft.com> wrote in message
news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
> Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
> retrieve a list of all indexes for mytable. Under the "Name" column, I
> notice several indexes that begin with "_WA" that aren't indexes I
> created;
> I'm assuming these are SQL-internal indexes. Can someone explain what
> these
> indexes are?
> My ultimate goal is to populate a cursor with the names of my indexes and
> then loop thru this cursor to perform a DBCC INDEXDEFRAG of these indexes.
> This will eventually become a scheduled job that runs weekly. However, I
> don't want to be defragmented useless indexes (or those that I haven't
> intentionally built).
> Any pointers, insights would be appreciated.
> Thanks
> Roz|||Hi Roz
The _WA_Sys entries in sysindexes are for column statistics, not indexes.
Please read about statistics in the Books Online, and the database option
'auto create statistics'.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Roz" <Roz@.discussions.microsoft.com> wrote in message
news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
> Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
> retrieve a list of all indexes for mytable. Under the "Name" column, I
> notice several indexes that begin with "_WA" that aren't indexes I
> created;
> I'm assuming these are SQL-internal indexes. Can someone explain what
> these
> indexes are?
> My ultimate goal is to populate a cursor with the names of my indexes and
> then loop thru this cursor to perform a DBCC INDEXDEFRAG of these indexes.
> This will eventually become a scheduled job that runs weekly. However, I
> don't want to be defragmented useless indexes (or those that I haven't
> intentionally built).
> Any pointers, insights would be appreciated.
> Thanks
> Roz|||Also, why reinvent the wheel. Tara Duggan has a proc that does just that.
Here you go:
http://weblogs.sqlteam.com/tarad
"Roz" <Roz@.discussions.microsoft.com> wrote in message
news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
> Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
> retrieve a list of all indexes for mytable. Under the "Name" column, I
> notice several indexes that begin with "_WA" that aren't indexes I
created;
> I'm assuming these are SQL-internal indexes. Can someone explain what
these
> indexes are?
> My ultimate goal is to populate a cursor with the names of my indexes and
> then loop thru this cursor to perform a DBCC INDEXDEFRAG of these indexes.
> This will eventually become a scheduled job that runs weekly. However, I
> don't want to be defragmented useless indexes (or those that I haven't
> intentionally built).
> Any pointers, insights would be appreciated.
> Thanks
> Roz|||Or why not pick the one which is already in Books Online (under DBCC SHOWCON
TIG)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
news:OH%23aPS9sEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Also, why reinvent the wheel. Tara Duggan has a proc that does just that.
> Here you go:
> http://weblogs.sqlteam.com/tarad
> "Roz" <Roz@.discussions.microsoft.com> wrote in message
> news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
> created;
> these
>|||Because her procedure also does the index defrag he's looking to do.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uDgAxQEtEHA.3156@.TK2MSFTNGP12.phx.gbl...
> Or why not pick the one which is already in Books Online (under DBCC
SHOWCONTIG)?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
> news:OH%23aPS9sEHA.1276@.TK2MSFTNGP12.phx.gbl...
that.[vbcol=seagreen]
and[vbcol=seagreen]
indexes.[vbcol=seagreen]
I[vbcol=seagreen]
>|||This is exactly what the sample code in BOL, under DBCC SHOWCONTIG does. the
sample might have been
added to one of the BOL updates, though, so make sure you all are on current
BOL (latest is from Jan
2004). :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
news:%236tbRXGtEHA.3200@.TK2MSFTNGP14.phx.gbl...
> Because her procedure also does the index defrag he's looking to do.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:uDgAxQEtEHA.3156@.TK2MSFTNGP12.phx.gbl...
> SHOWCONTIG)?
> that.
> and
> indexes.
> I
>

Listing my indexes...

Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
retrieve a list of all indexes for mytable. Under the "Name" column, I
notice several indexes that begin with "_WA" that aren't indexes I created;
I'm assuming these are SQL-internal indexes. Can someone explain what these
indexes are?
My ultimate goal is to populate a cursor with the names of my indexes and
then loop thru this cursor to perform a DBCC INDEXDEFRAG of these indexes.
This will eventually become a scheduled job that runs weekly. However, I
don't want to be defragmented useless indexes (or those that I haven't
intentionally built).
Any pointers, insights would be appreciated.
Thanks
RozLook at example E in the DBCC SHOWCONTIG topic in Books Online.
--
Jacco Schalkwijk
SQL Server MVP
"Roz" <Roz@.discussions.microsoft.com> wrote in message
news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
> Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
> retrieve a list of all indexes for mytable. Under the "Name" column, I
> notice several indexes that begin with "_WA" that aren't indexes I
> created;
> I'm assuming these are SQL-internal indexes. Can someone explain what
> these
> indexes are?
> My ultimate goal is to populate a cursor with the names of my indexes and
> then loop thru this cursor to perform a DBCC INDEXDEFRAG of these indexes.
> This will eventually become a scheduled job that runs weekly. However, I
> don't want to be defragmented useless indexes (or those that I haven't
> intentionally built).
> Any pointers, insights would be appreciated.
> Thanks
> Roz|||Hi Roz
The _WA_Sys entries in sysindexes are for column statistics, not indexes.
Please read about statistics in the Books Online, and the database option
'auto create statistics'.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Roz" <Roz@.discussions.microsoft.com> wrote in message
news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
> Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
> retrieve a list of all indexes for mytable. Under the "Name" column, I
> notice several indexes that begin with "_WA" that aren't indexes I
> created;
> I'm assuming these are SQL-internal indexes. Can someone explain what
> these
> indexes are?
> My ultimate goal is to populate a cursor with the names of my indexes and
> then loop thru this cursor to perform a DBCC INDEXDEFRAG of these indexes.
> This will eventually become a scheduled job that runs weekly. However, I
> don't want to be defragmented useless indexes (or those that I haven't
> intentionally built).
> Any pointers, insights would be appreciated.
> Thanks
> Roz|||Also, why reinvent the wheel. Tara Duggan has a proc that does just that.
Here you go:
http://weblogs.sqlteam.com/tarad
"Roz" <Roz@.discussions.microsoft.com> wrote in message
news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
> Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
> retrieve a list of all indexes for mytable. Under the "Name" column, I
> notice several indexes that begin with "_WA" that aren't indexes I
created;
> I'm assuming these are SQL-internal indexes. Can someone explain what
these
> indexes are?
> My ultimate goal is to populate a cursor with the names of my indexes and
> then loop thru this cursor to perform a DBCC INDEXDEFRAG of these indexes.
> This will eventually become a scheduled job that runs weekly. However, I
> don't want to be defragmented useless indexes (or those that I haven't
> intentionally built).
> Any pointers, insights would be appreciated.
> Thanks
> Roz|||Or why not pick the one which is already in Books Online (under DBCC SHOWCONTIG)?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
news:OH%23aPS9sEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Also, why reinvent the wheel. Tara Duggan has a proc that does just that.
> Here you go:
> http://weblogs.sqlteam.com/tarad
> "Roz" <Roz@.discussions.microsoft.com> wrote in message
> news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
>> Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
>> retrieve a list of all indexes for mytable. Under the "Name" column, I
>> notice several indexes that begin with "_WA" that aren't indexes I
> created;
>> I'm assuming these are SQL-internal indexes. Can someone explain what
> these
>> indexes are?
>> My ultimate goal is to populate a cursor with the names of my indexes and
>> then loop thru this cursor to perform a DBCC INDEXDEFRAG of these indexes.
>> This will eventually become a scheduled job that runs weekly. However, I
>> don't want to be defragmented useless indexes (or those that I haven't
>> intentionally built).
>> Any pointers, insights would be appreciated.
>> Thanks
>> Roz
>|||Because her procedure also does the index defrag he's looking to do. :)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uDgAxQEtEHA.3156@.TK2MSFTNGP12.phx.gbl...
> Or why not pick the one which is already in Books Online (under DBCC
SHOWCONTIG)?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
> news:OH%23aPS9sEHA.1276@.TK2MSFTNGP12.phx.gbl...
> > Also, why reinvent the wheel. Tara Duggan has a proc that does just
that.
> > Here you go:
> >
> > http://weblogs.sqlteam.com/tarad
> >
> > "Roz" <Roz@.discussions.microsoft.com> wrote in message
> > news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
> >> Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
> >> retrieve a list of all indexes for mytable. Under the "Name" column, I
> >> notice several indexes that begin with "_WA" that aren't indexes I
> > created;
> >> I'm assuming these are SQL-internal indexes. Can someone explain what
> > these
> >> indexes are?
> >>
> >> My ultimate goal is to populate a cursor with the names of my indexes
and
> >> then loop thru this cursor to perform a DBCC INDEXDEFRAG of these
indexes.
> >> This will eventually become a scheduled job that runs weekly. However,
I
> >> don't want to be defragmented useless indexes (or those that I haven't
> >> intentionally built).
> >>
> >> Any pointers, insights would be appreciated.
> >>
> >> Thanks
> >> Roz
> >
> >
>|||This is exactly what the sample code in BOL, under DBCC SHOWCONTIG does. the sample might have been
added to one of the BOL updates, though, so make sure you all are on current BOL (latest is from Jan
2004). :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
news:%236tbRXGtEHA.3200@.TK2MSFTNGP14.phx.gbl...
> Because her procedure also does the index defrag he's looking to do. :)
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uDgAxQEtEHA.3156@.TK2MSFTNGP12.phx.gbl...
>> Or why not pick the one which is already in Books Online (under DBCC
> SHOWCONTIG)?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
>> news:OH%23aPS9sEHA.1276@.TK2MSFTNGP12.phx.gbl...
>> > Also, why reinvent the wheel. Tara Duggan has a proc that does just
> that.
>> > Here you go:
>> >
>> > http://weblogs.sqlteam.com/tarad
>> >
>> > "Roz" <Roz@.discussions.microsoft.com> wrote in message
>> > news:57D205B1-1BB3-4176-8C69-665729CFA5C3@.microsoft.com...
>> >> Hello all. I'm querying the SYSINDEXES table with the ID of mytable to
>> >> retrieve a list of all indexes for mytable. Under the "Name" column, I
>> >> notice several indexes that begin with "_WA" that aren't indexes I
>> > created;
>> >> I'm assuming these are SQL-internal indexes. Can someone explain what
>> > these
>> >> indexes are?
>> >>
>> >> My ultimate goal is to populate a cursor with the names of my indexes
> and
>> >> then loop thru this cursor to perform a DBCC INDEXDEFRAG of these
> indexes.
>> >> This will eventually become a scheduled job that runs weekly. However,
> I
>> >> don't want to be defragmented useless indexes (or those that I haven't
>> >> intentionally built).
>> >>
>> >> Any pointers, insights would be appreciated.
>> >>
>> >> Thanks
>> >> Roz
>> >
>> >
>>
>

Listening for report events

I have a series of reports and want to fire off a stored procedure to update
a "Printed date" column in my database. I don't want to do this from the
dataset that populates my datset as I only want this to occur if the report
is successfully generated. Is there any way I can do this with the scheduler?
If not, are the any report events that I can listen for? And or any other
solution to this problem.Sorry. I don't think I made my intentions very clear. I meant to say that I
have a series of report, and want to fire off a stored procedure everytime a
report is successfully generated.
"Graham Hope" wrote:
> I have a series of reports and want to fire off a stored procedure to update
> a "Printed date" column in my database. I don't want to do this from the
> dataset that populates my datset as I only want this to occur if the report
> is successfully generated. Is there any way I can do this with the scheduler?
> If not, are the any report events that I can listen for? And or any other
> solution to this problem.

List() Function

Sybase has implemented a useful aggregate function called list() which takes
a column and returns all values in a comma delimited string. In Oracle10g,
there is a Java solution to duplicate this aggregation function. Now I have
to do the same in SQLServer2005. I found the UDA (User Defined Aggregate)
support in MSSQL2005 and some sample codes in C#. Has anyone done this
before? If someone can upload a precompiled module, it will save me some
effort. TIA.
I am downloading .Net Framework 2.0 SDK right now and hopefully it contains
a C# compiler. Otherwise, I have to buy a copy of Visual Studio .Net just
for this function.Why do you think you need to use a UDA aggregate for this? Seems like
overkill, since several other methods already exist and are widely
available. You may be able to write something that performs a few
milliseconds faster, but it will come at considerable development cost, and
there is plenty of room for new problems.
"mason" <masonliu@.msn.com> wrote in message
news:uqeTYn$NGHA.1028@.TK2MSFTNGP11.phx.gbl...
> Sybase has implemented a useful aggregate function called list() which
> takes a column and returns all values in a comma delimited string. In
> Oracle10g, there is a Java solution to duplicate this aggregation
> function. Now I have to do the same in SQLServer2005. I found the UDA
> (User Defined Aggregate) support in MSSQL2005 and some sample codes in C#.
> Has anyone done this before? If someone can upload a precompiled module,
> it will save me some effort. TIA.
> I am downloading .Net Framework 2.0 SDK right now and hopefully it
> contains a C# compiler. Otherwise, I have to buy a copy of Visual Studio
> .Net just for this function.|||I know. This is a migration project. If I can duplicate as much as possible
at the backend, I'll save tremendous efforts at the frontend. Besides, there
is only one aggregate function I like to create and I found some sample
source codes, it shouldn't be too bad. Thanks.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23hYedq$NGHA.740@.TK2MSFTNGP12.phx.gbl...
> Why do you think you need to use a UDA aggregate for this? Seems like
> overkill, since several other methods already exist and are widely
> available. You may be able to write something that performs a few
> milliseconds faster, but it will come at considerable development cost,
> and there is plenty of room for new problems.
>
>
> "mason" <masonliu@.msn.com> wrote in message
> news:uqeTYn$NGHA.1028@.TK2MSFTNGP11.phx.gbl...
>|||Check out 'For Xml Path' in:
http://www.aspfaq.com/show.asp?id=2529
Her is more from Tony Rogerson SQL Server MVP:

>
In SQL Server 2005 we can very simply use some of the new XML features to
get what we want...
select distinct type,
( select name + ', ' as [text()]
from sys.objects s
where s.type = so.type
order by name
for xml path( '' )
) as concatenated_name
from sys.objects so
order by type
This is documented in books online, look up 'Using PATH mode'
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/a685a9ad-3d28-4596-aa72-119202df3976.htm)[
color=darkred]
>[/color]
www.rac4sql.net|||Thanks. I read about these solutions on the web. The issue is the list() has
been a very popular function to be called in embedded SQL statements by our
apps and in some stored procedures. If I do not implement this, we have to
hunt down those codes and perform IF ELSE logic, very tedious work. If one
day, a customer insists to use DB2, we have to go thru this process again.
Therefore, finding backend portable solution is usually the most cost
efficient for us.
"05ponyGT" <noname@.overwood.com> wrote in message
news:ekltQ0$NGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Check out 'For Xml Path' in:
> http://www.aspfaq.com/show.asp?id=2529
> Her is more from Tony Rogerson SQL Server MVP:
>
> In SQL Server 2005 we can very simply use some of the new XML features to
> get what we want...
> select distinct type,
> ( select name + ', ' as [text()]
> from sys.objects s
> where s.type = so.type
> order by name
> for xml path( '' )
> ) as concatenated_name
> from sys.objects so
> order by type
> This is documented in books online, look up 'Using PATH mode'
> (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/a685a9ad-3d28-4596-aa72-1
19202df3976.htm)
> www.rac4sql.net
>|||Oh my, a helpful post. :)

> 05ponyGT
Nice ride.|||> Oh my, a helpful post. :)

> Nice ride.
Vert.
3.73 tush,bassani axle backs and x-pipe,jba headers,
aem cai,flashed.
BAD A$& Car
:P|||05ponyGT <nospam@.nospam> wrote:
>
> Vert.
> 3.73 tush,bassani axle backs and x-pipe,jba headers,
> aem cai,flashed.
> BAD A$& Car
> :P
I'm impressed! :)|||I have implemented list() UDA function in MSSQL2005 successfully. The source
codes are adapted from Anthony Trudeau's blog page. Here are the steps if a
nyone's interested.
1. Download .Net Framework 2.0 SDK and/or Visual C# 2005 Express. Both are f
ree. The purpose is to get the C# compiler (csc.exe) and the latter gives yo
u the IDE to config the module version info if you care. Create a class libr
ary project and compile the C# source codes from Anthony Trudeau's example (
make appropriate modifications as I did if necessary). You will get a DLL. T
o skip this step, you can use the DLL I attached to this msg.
2. Run the following SQL to create the list() aggregate function:
CREATE ASSEMBLY UDAFunctions FROM 'C:\TEMP\ListClassLibrary.dll'
go
CREATE AGGREGATE list(@.value NVARCHAR(4000)) RETURNS NVARCHAR(4000)
EXTERNAL NAME [UDAFunctions].[SqlAggregateFunctions.List]
go
Now, you can issue SQLs like the following to get a comma delimited value li
st such as 2001,2003,2006 and CA,TX,NY,IL,FL.
SELECT dbo.list(mycol) from mytable WHERE ...
The only limitation is, as in Oracle10g, that ORDER BY clause is not support
ed, which you can do in Sybase.
"mason" <masonliu@.msn.com> wrote in message news:uqeTYn$NGHA.1028@.TK2MSFTNGP11.phx.gbl...[c
olor=darkred]
> Sybase has implemented a useful aggregate function called list() which tak
es
> a column and returns all values in a comma delimited string. In Oracle10g,
> there is a Java solution to duplicate this aggregation function. Now I hav
e
> to do the same in SQLServer2005. I found the UDA (User Defined Aggregate)
> support in MSSQL2005 and some sample codes in C#. Has anyone done this
> before? If someone can upload a precompiled module, it will save me some
> effort. TIA.
>
> I am downloading .Net Framework 2.0 SDK right now and hopefully it contain
s
> a C# compiler. Otherwise, I have to buy a copy of Visual Studio .Net just
> for this function.
>[/color]|||>> If I do not implement this, we have to hunt down those codes and perform
IF ELSE logic, very tedious work. If one day, a customer insists to use DB2
, we have to go thru this process again. Therefore, finding backend portabl
e solution is usually the m
ost cost efficient for us. <<
Think of this as how God punishes programmers who do not write portable
code in the firsts place. Your backend solution is probably going to
involve different proprietary code in the target product. The reason I
say that is that LIST() is a way to screw up 1NF, so it is not going to
be popular with RDBMS people and it is not part of the Standards. It
was proposed at one time and was voted down.
What you are setting yourself up for is having to maintain (n) code
bases instead of one. Bite the bullet and do it right. Oh, and beat
your developers who wrote you into this corner.
Based on a few decades of patching bad SQL, I am not sure that you will
need IF-THEN-ELSE code in your SQL, if you do it right.

list tables depending if column exists

Hi there,
Is there a quick way to list all the tables in a DB that contain a certain column name?
Thanks
Sselect name from sysobjects o
where exists (select 1 from information_schema.columns c
where o.name = c.table_name
and column_name like '%column_name_patter%')|||Thanks for this!!!!!|||Thanks again!

I've now got a list of all the tables containing a certain column name, but I'm trying to expand this further to narrow down the results to:

all tables containing columnX and where columnX >= 10000 and <= 20000

Any ideas how I can search on this criteria?

Thanks I'd appreciate any input or advice.

S|||I'll give you what you asked for... You'll have to decide if that is what you want (I suspect that it is not).SELECT o.name
FROM dbo.syscolumns AS c
INNER JOIN dbo.sysobjects AS o
ON (o.id = c.id)
WHERE c.name = 'whatever'
AND c.name BETWEEN '10000' AND '20000'What I suspect that you really want is to check the values of the column in the tables themselves to see if there are rows in the table with column values between 10000 and 20000. That is a slightly more challenging request.

-PatP|||select 'select * from ' + name + ' where ' + column_name + ' between 10000 and 20000' from sysobjects o inner join information_schema.columns c
on o.name = c.table_name
where column_name like '%column_name_patter%'

Then you can execute the resulting series of SELECT statements. Or you can always put it into a cursor and do "EXEC ('...statement...)" on each row.

List table names in a database having a particular column.

Can anybody tell me how to find out whether a particular column exists in any of the tables of a database and if it does, display the table names?

Thanks

Check INFORMATION_SCHEMA.COLUMNS view in your BOL.

AMB

|||Thanks!

list Primary and foreign keys

I have a DB with 100 tables. I was wondering if anybody knows a quick way to list primary and foreign key with the column name for all the tables.

Your help would make my life a lot easier

thanks

In 2005 you can simple perform the following query.

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS

There are a whole bunch of other system views that display similar information.

Larry Pope

List Page OverRun

Hi

Is it possible to set a list control not to grow? I have multiple tables in a list box and text boxes it is grouped by a particular column it possible to say that if it the list has to steach to the next page because to much information is to display just don’t go over to the next page just hide it or don’t display the rest of the records

No, list boxes will always grow to accomodate their contents. If an instance of a list does not fit on one page, it will be pushed to the next page. Textboxes and images are the only control that will contrain their contents.|||

Hi Brian,

Thank you for replying, so my if i have to run over to the next page for the same employee so if i am using a lot of ReportItems to have print DataSet Data in the page header and footer for eache page the data changes per employee so is it posible to make the report items repete the same data to the next page if the page is for the same employee so i can have the information for the page header and fotter for that page as well?

Thanks

List out duplicate names only

Hi all,
I am new this this site. May I know how do I do a search for duplicate items
in a column of a table only. eg If John appears twice and Jim once, in the
Name column of Student table, the Select statement should show me 2 times (
John ) ?
ThanksSee Itzik Ben-Gan's example
CREATE TABLE #Demo (
idNo int identity(1,1),
colA int,
colB int
)
INSERT INTO #Demo(colA,colB) VALUES (1,6)
INSERT INTO #Demo(colA,colB) VALUES (1,6)
INSERT INTO #Demo(colA,colB) VALUES (2,4)
INSERT INTO #Demo(colA,colB) VALUES (3,3)
INSERT INTO #Demo(colA,colB) VALUES (4,2)
INSERT INTO #Demo(colA,colB) VALUES (3,3)
INSERT INTO #Demo(colA,colB) VALUES (5,1)
INSERT INTO #Demo(colA,colB) VALUES (8,1)
PRINT 'Table'
SELECT * FROM #Demo
PRINT 'Duplicates in Table'
SELECT * FROM #Demo
WHERE idNo IN
(SELECT B.idNo
FROM #Demo A JOIN #Demo B
ON A.idNo <> B.idNo
AND A.colA = B.colA
AND A.colB = B.colB)
PRINT 'Duplicates to Delete'
SELECT * FROM #Demo
WHERE idNo IN
(SELECT B.idNo
FROM #Demo A JOIN #Demo B
ON A.idNo < B.idNo -- < this time, not <>
AND A.colA = B.colA
AND A.colB = B.colB)
DELETE FROM #Demo
WHERE idNo IN
(SELECT B.idNo
FROM #Demo A JOIN #Demo B
ON A.idNo < B.idNo -- < this time, not <>
AND A.colA = B.colA
AND A.colB = B.colB)
PRINT 'Cleaned-up Table'
SELECT * FROM #Demo
DROP TABLE #Demo
"Eric_Singapore" <Eric_Singapore.24lr9q@.mail.codecomments.com> wrote in
message news:Eric_Singapore.24lr9q@.mail.codecomments.com...
> Hi all,
> I am new this this site. May I know how do I do a search for duplicate
> items in a column of a table only. eg If John appears twice and Jim
> once, in the Name column of Student table, the Select statement should
> show me 2 times ( John ) ?
>
> Thanks
>
> --
> Eric_Singapore
> ---
> Posted via http://www.codecomments.com
> ---
>

List only the visible columns in a view?

In SQL Server 2005, when using INFORMATION_SCHEMA.VIEW_COLUMN_USAGE I get a
row for every column in a view including those that might not be visible but
used only in the WHERE or ORDER BY clauses for example.
Is there an easy way to reduce the list to only show the columns that
actually appear in the SELECT clause of the view definition?
I've tried examining Profiler when expanding the columns node under the View
in Management Studio as it seems to load only one node per visible column
but haven't been able to make much sense of how it does this.
BTW I'm using that view as it promises to only show views and columns "to
which the current user has permissions". Is this reliable or is there a
preferred way of listing visible views, talbe, & columns etc?
cheers,
Paul.Hi, Paul
Look in the INFORMATION_SCHEMA.COLUMNS view.
Razvan|||Use the catalog schema views...
SELECT
name
FROM
sys.columns
WHERE
object_id = OBJECT_ID('dbo.YourViewName');
"Paul Ritchie" <REMOVEpritchie@.REMOVExtra.REMOVEco.REMOVEnz> wrote in
message news:%23S90IfVBGHA.4004@.TK2MSFTNGP15.phx.gbl...
> In SQL Server 2005, when using INFORMATION_SCHEMA.VIEW_COLUMN_USAGE I get
> a
> row for every column in a view including those that might not be visible
> but
> used only in the WHERE or ORDER BY clauses for example.
> Is there an easy way to reduce the list to only show the columns that
> actually appear in the SELECT clause of the view definition?
> I've tried examining Profiler when expanding the columns node under the
> View
> in Management Studio as it seems to load only one node per visible column
> but haven't been able to make much sense of how it does this.
> BTW I'm using that view as it promises to only show views and columns "to
> which the current user has permissions". Is this reliable or is there a
> preferred way of listing visible views, talbe, & columns etc?
> cheers,
> Paul.
>|||Thanks Aaron - much appreciated.
Is there an easy way to determine which columns a user might have access to
when using the "sys" tables? That was what the INFORMATION_SCHEMA views
seemed to promise although there was some doubt in newsgroups as to their
accuracy in SQL2000 due to them being derived from the sysdepends table.
I'm betting that this will have changed in 2005.
However moving back to the sys tables/views will mean I have to determine
this permission information in some other way. Any seggestions would be
appreciated tremendously.
cheers,
Paul.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OCq14hWBGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Use the catalog schema views...
> SELECT
> name
> FROM
> sys.columns
> WHERE
> object_id = OBJECT_ID('dbo.YourViewName');
>
> "Paul Ritchie" <REMOVEpritchie@.REMOVExtra.REMOVEco.REMOVEnz> wrote in
> message news:%23S90IfVBGHA.4004@.TK2MSFTNGP15.phx.gbl...
>|||> Is there an easy way to determine which columns a user might have access
> to when using the "sys" tables?
Take a look at sys.database_permissions
I believe the join between sys.database_permissions p and sys.comments c
would be:
ON
c.object_id = p.major_id
AND c.column_id = p.minor_id
WHERE
p.class = 1
AND p.grantee_principal_id = SUSER_ID('username');
I am not 100% sure on that, and don't have time today to experiment with
column-level permissions. But hopefully that gets you started.

> accuracy in SQL2000 due to them being derived from the sysdepends table.
Permissions derived from sysdepends? I think that is inaccurate.
A

List of columns from tables across databases.

Hey guys,

Couldn't find this anywhere in google.

I want a list of all database column names for a specific table/view
from across database.

I tried this...
----------------
Select *
>From Information_Schema.Columns
----------------

I also tried this...

----------------
select syscolumns.name, sysobjects.name, * from syscolumns, sysobjects
where
sysobjects.id = syscolumns.id
and (sysobjects.xtype='U' or sysobjects.xtype='S')
----------------

These queries return information about the CURRENT database.

But, if I want to do it ACROSS database or across servers.. how can I
do this?

I will express my gratitude to everyone who is kind enough to answer
this question. (I've been stuck with this problem for a while now.)

Thanks!

OhMyGaw!Query other databases using the three-part name:

SELECT *
FROM database_name.information_schema.columns

SELECT C.name, O.name, *
FROM database_name.dbo.syscolumns AS C,
database_name.dbo.sysobjects AS O
WHERE O.id = C.id
AND (O.xtype='U' OR O.xtype='S')

Assuming you have set up a linked server you can query other servers with
the four-part name:

SELECT *
FROM server_name.database_name.information_schema.colum ns

SELECT C.name, O.name, *
FROM server_name.database_name.dbo.syscolumns AS C,
server_name.database_name.dbo.sysobjects AS O
WHERE O.id = C.id
AND (O.xtype='U' OR O.xtype='S')

In each case the tables are distinct objects so if you want to combine
results from multiple databases either use a UNION or write a loop that
cycles through each DB. There is actually an undocumented proc that will
access each DB in turn:

EXEC sp_msforeachdb 'USE ? SELECT DB_NAME()'

This is something you should avoid in persistent code because it won't
necessarily be supported in future but it may help you if this is just a
one-off exercise.

--
David Portas
SQL Server MVP
--|||Query other databases using the three-part name:

SELECT *
FROM database_name.information_schema.columns

SELECT C.name, O.name, *
FROM database_name.dbo.syscolumns AS C,
database_name.dbo.sysobjects AS O
WHERE O.id = C.id
AND (O.xtype='U' OR O.xtype='S')

Assuming you have set up a linked server you can query other servers with
the four-part name:

SELECT *
FROM server_name.database_name.information_schema.colum ns

SELECT C.name, O.name, *
FROM server_name.database_name.dbo.syscolumns AS C,
server_name.database_name.dbo.sysobjects AS O
WHERE O.id = C.id
AND (O.xtype='U' OR O.xtype='S')

In each case the tables are distinct objects so if you want to combine
results from multiple databases either use a UNION or write a loop that
cycles through each DB. There is actually an undocumented proc that will
access each DB in turn:

EXEC sp_msforeachdb 'USE ? SELECT DB_NAME()'

This is something you should avoid in persistent code because it won't
necessarily be supported in future but it may help you if this is just a
one-off exercise.

--
David Portas
SQL Server MVP
--|||David,

Thanks for your response. This is exactly what I was looking for.

SELECT *
FROM database_name.information_sche*ma.columns

I was trying the following

SELECT *
FROM database_name.database_owner.information_sche*ma.c olumns

BTW, where is this information_schema table? I couldn't find it when
I looked for it.

Thanks a bunch.|||David,

Thanks for your response. This is exactly what I was looking for.

SELECT *
FROM database_name.information_sche*ma.columns

I was trying the following

SELECT *
FROM database_name.database_owner.information_sche*ma.c olumns

BTW, where is this information_schema table? I couldn't find it when
I looked for it.

Thanks a bunch.|||Information_schema is a "schema" rather than a table. You can find the
definitions of the info schema views in Master.

In SQL Server 2000 "schema" is synonymous with "owner" and the
information_schema is implemented as a sort of virtual owner name that
points to the views in Master. SQL Server 2005 implements schemas
properly in a way that's consistent with other products and with the
SQL definition of the term.

--
David Portas
SQL Server MVP
--|||Information_schema is a "schema" rather than a table. You can find the
definitions of the info schema views in Master.

In SQL Server 2000 "schema" is synonymous with "owner" and the
information_schema is implemented as a sort of virtual owner name that
points to the views in Master. SQL Server 2005 implements schemas
properly in a way that's consistent with other products and with the
SQL definition of the term.

--
David Portas
SQL Server MVP
--

List Control Properties

I saw this posting below, and I just want to be clear. I have a data
set with one Column, but many rows. I would like the data to display
horizontaly, then wrap to the next line. My data is actually displayed
in through Image controls. Im pulling the images from an external
path, on the web (http://hostname/images/image.jpg)
Am I understanding correctly, I cannot do that? Is there another
control that I can use instead? If there is can someone point me in
the direction on the properties I need to use?
Thanks,
rwiethorn
*************************************************************
From: Brian Welcker [MSFT] (bwelcker@.online.microsoft.com)
Subject: Re: List Control Shortcomings?
View: Complete Thread (2 articles)
Original Format
Newsgroups: microsoft.public.sqlserver.reportingsvcs
Date: 2004-05-31 12:29:15 PST
No. You can make the entire report multiple columns but you can't make
a
list repeat horizontally.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no
rights.
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:374C89FA-582F-4B82-8A8A-C61A4D58D215@.microsoft.com...
> I have a data set bound to a list control. Is there any way to configure the list control to output horizontally aswell as vertially?
>
> e.g. my dataset has 11 rows, can the first 6 be in 1 column, the next 5 in
another column.
----http://blogs.msdn.com/chrishays/archive/2004/07/23/193292.aspx
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"rwiethorn" <rwiethorn2002@.yahoo.com> wrote in message
news:553a0349.0407301045.6cd21b18@.posting.google.com...
> I saw this posting below, and I just want to be clear. I have a data
> set with one Column, but many rows. I would like the data to display
> horizontaly, then wrap to the next line. My data is actually displayed
> in through Image controls. Im pulling the images from an external
> path, on the web (http://hostname/images/image.jpg)
> Am I understanding correctly, I cannot do that? Is there another
> control that I can use instead? If there is can someone point me in
> the direction on the properties I need to use?
> Thanks,
> rwiethorn
> *************************************************************
> From: Brian Welcker [MSFT] (bwelcker@.online.microsoft.com)
> Subject: Re: List Control Shortcomings?
> View: Complete Thread (2 articles)
> Original Format
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Date: 2004-05-31 12:29:15 PST
>
> No. You can make the entire report multiple columns but you can't make
> a
> list repeat horizontally.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Mark" <anonymous@.discussions.microsoft.com> wrote in message
> news:374C89FA-582F-4B82-8A8A-C61A4D58D215@.microsoft.com...
> > I have a data set bound to a list control. Is there any way to configure
the list control to output horizontally aswell as vertially?
> >
> > e.g. my dataset has 11 rows, can the first 6 be in 1 column, the next 5
in
> another column.
>
> ----
--