nevermind.. found it under cubedesign

like this , use count and group by your field.

create table #a(text varchar(20))

insert #a values('abc')

insert #a values('abc1')

insert #a values('abc')

insert #a values('abc1')

insert #a values('abc')

select count([text]) , [text] from #a group by...

Resolved by creating an named query table from the Data source view.

That is..

Dropped my table dimworktyped. Instead from the data source view of the cube I created a new...

Actually yes this i quit an good solution. tho i would rather put this in a table in the master database 🙂

thanx for the ideas

intresting...... these are some good ideas i'll try to check this out.

select min(column name1 ) , min(column name 2),min(column name 3)

Brilliant , thax ... and yes i am doing new stuff, so i can alter my initial design.

Interesting how you can find a solution just 2 min after you ask for help 🙂

It's not the best solution but it works.

create procedure test1 @list varchar(80)=null

as

begin

declare @sql varchar(max)

...

it might be that I’m only on my first cup of coffee, but i fail to see what you intend to gain by adding the GOTO lines, except only writing...

Thanx for the info.. What i will do is just redefine my stored procedure, so i'll filter down on user groups. I managed to find out how to use the...

Sorry , the previous quote was in regards to breaking the log chain

I was under the asumption that this could be avoided by doing full backup and transaction log backup before the...

Well. im using about 150 databases , so that varies. 🙂

In cases where Transaction log size has been come an issue. We have scheduled an transaction log backup every 4...

first take a full backup.

after the full backup do an transaction log backup

then you should be able to shrink the file with

dbcc shrinkfile('logfile' , destination size)

if that dosen't work...

true.. the correct answer would be sys.sql_logins