Viewing 15 posts - 7,336 through 7,350 (of 11,676 total)
patelmohamad (4/13/2012)
Agree with you koen but the column indexing will be lost in it and in my next step i have used the same statement but with where condition and...
April 13, 2012 at 5:22 am
patelmohamad (4/13/2012)
Please read my question then suggest some better solution,
I did read the question. Do you think I randomly type stuff in forum topics?
I did have to guess on which...
April 13, 2012 at 4:44 am
danielfountain (4/13/2012)
How come this is supposed to bring back 6 rows?
select top 5 with ties * from SSCSales order by cMonthSales desc
There are 4 records with 3500. ...
April 13, 2012 at 2:09 am
Drop the identity column and add a simple integer column with the same name.
April 13, 2012 at 1:29 am
What would have been nice is some real world examples why I should use sequences.
For now it just seems I can use an IDENTITY column as well.
April 13, 2012 at 12:46 am
First result on Google for sql server script backup all databases
Simple script to backup all SQL Server databases
[/url]
You do know you'll lose less time using Google than typing something in...
April 13, 2012 at 12:15 am
Try to implement as many of these:
Top 10 SQL Server Integration Services Best Practices
And do not use SELECT *. 🙂
April 13, 2012 at 12:10 am
masteratul25 (4/12/2012)
I am getting the below. Please correct me.:cool:
I get an error when I try to open your attachment.
April 13, 2012 at 12:08 am
Vaibhav.P (4/12/2012)
Not really..,I opened each named query and modified the schema name for the first time.
Why is search and replace not an option? A SSAS database is just a collection...
April 13, 2012 at 12:07 am
You can write a SQL statement against a text file using the JET OLE DB provider, but it needs some clever scripting.
An example:
April 13, 2012 at 12:05 am
I don't think so. In SSIS this is possible, but in SSAS?
How do you deploy from DEV to PROD?
Maybe you can do a simple search and replace on the schema...
April 12, 2012 at 11:54 pm
Case sensitivity. Name them both @model.
April 12, 2012 at 11:50 pm
That's quite a horrible practice.
Every single piece of code that you write on dev using a schema will break when you deploy it to production.
You could try to create views...
April 12, 2012 at 11:49 pm
2. Use an expression on the textbox:
="The Billing Date is from " + CStr(Parameters!StartDate.Value) + " to " + CStr(Parameters!EndDate.Value)
April 12, 2012 at 11:33 pm
Viewing 15 posts - 7,336 through 7,350 (of 11,676 total)