Viewing 15 posts - 3,316 through 3,330 (of 4,087 total)
PIVOT groups on every field from the inner query that is not the aggregated value or the pivoted column. That includes the TrnMonth. Try removing that from the...
February 23, 2012 at 2:30 pm
Your trigger is written under the assumption that there will only ever be one row inserted/updated at a time and you can't guarantee that will always be the case. ...
February 23, 2012 at 9:12 am
I don't see any way to easily distinguish between the end of a field and the end of a record using this file format. That's going to cause problems...
February 22, 2012 at 12:53 pm
WHY? How are you planning on using these aliases? Any queries written using these aliases would be virtually impossible to read. You're better off using aliases that...
February 22, 2012 at 11:40 am
bitbucket-25253 (2/17/2012)
Looking for something like this:
DECLARE @HireDate DATETIMEDECLARE @CurrentDate DATETIME
SET @HireDate = '01-06-2012'
SET @CurrentDate = GETDATE()
SELECT DATEPART(wk, @CurrentDate) - DATEPART(wk,@HireDate) AS 'Weeks Worked'
--Result:
Weeks Worked
6
This only works if the hire...
February 22, 2012 at 7:33 am
A more useful statistic for comparing two queries is the number of reads. If you SET STATISTICS IO, TIME ON and then run both queries, you will be able...
February 22, 2012 at 7:00 am
GuruGPrasad (2/17/2012)
But we have converted the date to format 103 then why its not formatted.
And also when using getdate() its formatting but when we give the date its...
February 20, 2012 at 9:27 am
SQL Kiwi (2/16/2012)
Rowles (2/14/2012)
A table hint would be used in a T-SQL query. So table hints would then be a sub-type of query hint, right?
I'm not sure I would...
February 20, 2012 at 9:13 am
T-SQL is not a reporting tool, yet you are trying to use it like one. What you are trying to do would be relatively easy in a reporting tool,...
February 20, 2012 at 8:57 am
R.P.Rozema (2/15/2012)
February 16, 2012 at 7:21 am
I agree with Sean that you'll probably want to use a calendar table.
There are also problems with your posted code. You're trying to convert a date to nvarchar—which is...
February 15, 2012 at 9:31 am
There are essentially two different options: XQuery and OPENXML. There are plenty of examples in BOL and online. If you need help with a specific problem, you'll need...
February 15, 2012 at 7:13 am
There's not much we can do without sample data and expected results. Check out the following link: Forum Etiquette: How to post data/code on a forum to get...
February 13, 2012 at 1:43 pm
asita (2/13/2012)
from dbo.Guarantees chl
left join dbo.Guarantees par on par.HyperionEntityId = chl.ParentHyperionEntityId
left join dbo.Guarantees gpar on gpar.HyperionEntityId = par.ParentHyperionEntityId
left join dbo.Guarantees ggpar on ggpar.HyperionEntityId...
February 13, 2012 at 11:24 am
This forum is for programming in T-SQL using the XML datatype. It is not for troubleshooting installs of third party products.
Try this link http://lmgtfy.com/?q=error+25541+office+2010
Drew
February 8, 2012 at 2:35 pm
Viewing 15 posts - 3,316 through 3,330 (of 4,087 total)