Viewing 15 posts - 346 through 360 (of 642 total)
select name, type_desc from sys.server_principals;
When I run that and do a visual comparison with results of database->security-> Logins, it does not match.
I need to be able to make a distinction...
March 25, 2013 at 2:32 pm
I didn't select default instance during install. I thought it would default to default during the install, but no, named is the default. I selected default during install.
Phew.problem solved.
THANKS
November 14, 2012 at 3:14 pm
Hey guys, so I take it that SQL Agent doesn't run in Express and that is not the root cause of the problem. (Thanks for link IpTech). That led...
November 14, 2012 at 2:37 pm
Thanks Iptech!
November 14, 2012 at 2:24 pm
if it's just DDL you're trying to create, try on second laptop (personal one?) and see if still happening. maybe you can still make progress on creating your DDL.:-)
April 18, 2012 at 8:30 am
SELECT ...
FROM Something C -- selects from the second Common Table Expression
But how does the middle CTE come to be recognized as 'C' as it isn't named explicitly....
April 17, 2012 at 4:58 pm
Yes, first embarrassed that I didn't change the alias for the Maxticket CTE or flip/flop the order of the columns and statements to reflect the hierarchy I was imposing. :blush:
Thanks...
April 17, 2012 at 2:18 pm
stuck on an error in the SELECT statement
Msg 207, Level 16, State 1, Line 32
Invalid column name 'Portfolio'.
WITH Maxticket AS (SELECT AD.ID, AD.OrgName,
...
April 17, 2012 at 12:15 pm
Fair enough. Will definitely do. I appreciate it!!!!!!!!;-)
April 17, 2012 at 11:39 am
--I need to join earlier statement with this temp table on ProjName column and outcome
Here' the temp table I'd like to use:
select
ID
,Portfolio =
...
April 17, 2012 at 9:43 am
Oh no, capn.hector. The problem is much harder than that.
I don't want to rename an existing column, I need to create a brand new column and wedge *in between* #ofWorkItemsPerOrg...
April 17, 2012 at 8:52 am
My secretary reads my mail and takes dictation...
looking over now. Thank you! Main thing is progress!!!!
April 17, 2012 at 8:39 am
It's really helpful capn.Hector. Thanks for mentoring.
I have one last thing to do.
The report must have one additional level to it's hierarchy that doesn't even exist in the datawarehouse....
April 16, 2012 at 5:05 pm
Hi stevro.
Like this? No workie.
; WITH CTE AS
(
SELECT AD.ID , AD.OrgName , AD.ProjName , AD.Ticket#
, RN1 = ROW_NUMBER() OVER (PARTITION BY AD.OrgName ORDER BY AD.ID)
, RN2 =...
April 16, 2012 at 2:45 pm
Viewing 15 posts - 346 through 360 (of 642 total)