Viewing 15 posts - 106 through 120 (of 145 total)
I'm studying right now for the 70-432 exam and I've learned tons, especially about encryption and high availability. Those aren't features that we currently use at work, but if...
March 31, 2011 at 3:07 pm
If it helps you to make the decision, Transcender is having a 20% off sale for March. I just ordered the 30 day online access for 070-432 for about...
March 24, 2011 at 6:41 pm
That's what I thought, but I want to make sure I just wasn't being completely obtuse. After doing my regular day job, finishing up the training session with 29...
March 2, 2011 at 7:57 pm
The company's test review comes with references in the test key and explanations. I just think they are wrong on this one. Transcender does not actually offer courses...
March 2, 2011 at 1:43 pm
I've relied on Mr. Pearson's Database Journal MDX and SSRS series for a while now, so I'm thrilled to see this series here - especially since it is targetted to...
March 2, 2011 at 11:22 am
Yes, you have to manually create the c:\test folder on your computer. The TK432Documents subfolder will be created when you run the code from the book.
February 27, 2011 at 12:26 pm
I think that's the standard "Select Top 1000 Rows" Right-click functionality. It does fully qualify the table name so even though the db is set to master, the rows...
February 24, 2011 at 2:30 pm
Our service provider has our SQL port locked down via the firewall with an exception for our office IP address. That might work for you if the connection will...
February 4, 2011 at 2:43 pm
Look into SSIS and the File System Task or using a Script Task. You can select the records you want to loop through in a SQL task, put them...
January 17, 2011 at 7:54 pm
Does this work for you?
create table #Temp (A varchar(255), B Datetime)
insert into #Temp
values('Mr. ADAMS', '2011-01-07 17:00:00'),
('Mr. BEACH', '2011-01-07 16:30:00'),
('Mr. BEACH', '2011-01-07 16:00:00'),
('Mr. SCHAL', '2011-01-07 15:30:00'),
('Mr. ADAMS', '2011-01-07 15:00:00'),
('Mr. SCHAL', '2011-01-07...
January 7, 2011 at 2:06 pm
If you can stand the risk you could go the consulting route and get lots of experience in different companies.
I started out in large financial firms and found...
December 2, 2010 at 2:41 pm
The steps in the 6th comment down posted by Will SQL worked for me.
December 2, 2010 at 1:46 pm
Cascading parameters are really easy, just send in your first parameter of Database product to your query that supplies the list for the Database version parameter. Also make sure that...
October 28, 2010 at 11:55 am
You can definitely use two parameters in SSRS. You would just end up with two drop downs, and they could even been cascading so the user selects the Database...
October 27, 2010 at 12:05 pm
Try:
SELECT DP.Name, DV.Version
FROM DatabaseProduct DP
JOIN DatabaseVersion DV
ON DP.DatabaseProductID = DV.DatabaseProductID
WHERE
CASE @Version WHEN 'ALLSQLSERVER' THEN '1'
WHEN 'ALLORACLE' THEN '2'
WHEN 'ALLMYSQL' THEN '3
ELSE @Version END =
CASE @Version WHEN...
October 26, 2010 at 5:38 pm
Viewing 15 posts - 106 through 120 (of 145 total)