Viewing 15 posts - 796 through 810 (of 3,666 total)
Did you follow these steps?
https://msdn.microsoft.com/en-us/library/cc280547.aspx
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 19, 2015 at 3:08 pm
sharonsql2013 (5/18/2015)
I am trying to join Project_Code with Manager.Code but if the project_code is blank then it should look for Project_CostCenter and Join...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 18, 2015 at 9:57 am
There's different ways to handle this, but if you had a Originating_key and Destination_key columns in your fact table, you would have to deal with changing dimensions.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 18, 2015 at 9:37 am
NineIron (5/18/2015)
I'm using a calendar table but, it doesn't identify holidays.
I would either update that calendar table so it does identify holidays, or create a Holidays table.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 18, 2015 at 8:07 am
Luis Cazares (5/15/2015)
Alvin Ramard (5/15/2015)
Grant Fritchey (5/15/2015)
Alvin Ramard (5/15/2015)
Grant Fritchey (5/15/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 15, 2015 at 9:35 am
Eric M Russell (5/15/2015)
Grant Fritchey (5/15/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 15, 2015 at 7:28 am
Grant Fritchey (5/15/2015)
Alvin Ramard (5/15/2015)
Grant Fritchey (5/15/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 15, 2015 at 7:22 am
Grant Fritchey (5/15/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 15, 2015 at 7:14 am
Here's an interview question:
Name 10 of the parameters for DBCC TimeWarp. 😛
I'd seriously consider asking a DBCC TimeWarp question at an interview, just to see how the person would...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 14, 2015 at 3:20 pm
atlantageorgia123 (5/12/2015)
ProductSkuTypeId = pst.[ProductSkuTypeID],
ProductSkuTypeName = pst.[Name],
p.ProductTaxCodeID,
Here i am trying to write a case statement.
like when the skutypename is Fab by default i have to set Tax Code as A_CLTH_FAB
like when...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 12, 2015 at 1:32 pm
sharonsql2013 (5/12/2015)
I am trying to access records which start with numbers 75Looks like LIke doesn't work.
How can I do so for
Case when Numbers like '75%'
You could try something like:
CASE...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 12, 2015 at 9:43 am
In your JOIN statements, try using the LEFT function instead of SUBSTRING to see if it will run any faster.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 7, 2015 at 12:27 pm
Sean Lange (5/5/2015)
minimay (5/5/2015)
Declare @Julycount int
Set @Julycount= (Select Count(*) From orders Where MONTH(OrderDate) = 7)
print 'The total orders for july is...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 5, 2015 at 2:22 pm
SQLRNNR (5/4/2015)
Luis Cazares (5/4/2015)
Kelley Fitz (5/4/2015)
The ? is the table nameEXEC MSFOREACHTABLE 'SELECT COUNT(*) AS ''?'' FROM ?'
TABLENAME
COUNT
Do you realize that you posted almost the same answer...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 4, 2015 at 1:45 pm
Pricing for SQL Server can be confusing.
I would contact my local Microsoft sales office for the answer.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 4, 2015 at 1:15 pm
Viewing 15 posts - 796 through 810 (of 3,666 total)