Viewing 15 posts - 2,101 through 2,115 (of 2,458 total)
No problem, good luck!
-- Itzik Ben-Gan 2001
October 3, 2013 at 9:36 am
What I want to know:
Is it possible to have the SSRS report contain links within the results of the report that can be passed back to a Webform so that...
-- Itzik Ben-Gan 2001
October 2, 2013 at 3:41 pm
Printed books -- 100%.
I read pdf's & ebooks on my phone & tablet but this is only when it would not be convenient to huff around a real book.
-- Itzik Ben-Gan 2001
October 2, 2013 at 3:02 pm
I have always done this manually because of the types of SSIS packages I have dealt with did not work well with the Visual Studio conversion wizard. That said, here's...
-- Itzik Ben-Gan 2001
October 2, 2013 at 2:21 pm
Steve Smith-163358 (10/2/2013)
The software we use often creates a lot of temporary tables that need to be deleted from time to time.
Depending on the usage, this can range from hundreds...
-- Itzik Ben-Gan 2001
October 2, 2013 at 12:28 pm
I would strongly encourage you to look at the article that Gail posted.
I currently have a database of 80[gb]. did a shrink log file to 1 mega byte.
For a database...
-- Itzik Ben-Gan 2001
October 2, 2013 at 10:11 am
erikd (9/30/2013)
-- Itzik Ben-Gan 2001
September 30, 2013 at 4:58 pm
This is what you are looking for.
DECLARE @x xml;
SELECT @x = P
FROM OPENROWSET (BULK '\\usd\SurveyComputing\Sample\SampleRepository\Visit_Survey_2013_08_16_07_21_43.XML', SINGLE_BLOB) AS FMG(P)
DECLARE @hdoc int
EXEC sp_xml_preparedocument @hdoc OUTPUT, @x
select *
from OPENXML (@hdoc, 'SURVEY_EXTRACT/VISIT_SURVEY',...
-- Itzik Ben-Gan 2001
September 30, 2013 at 12:43 pm
For what you are doing I think Sean's solution is the way to go. That said, you could run them in parallel in an SSIS package then have your proc...
-- Itzik Ben-Gan 2001
September 30, 2013 at 11:53 am
Taking what Keith said, you could re-write your query like this:
WITH cteSource(CN, U1)
AS (
SELECTr.CN, r.U1
FROM dbo.SSS AS s
INNER JOINdbo.STU AS t ON t.SN = s.SN
INNER JOINdbo.CRS AS...
-- Itzik Ben-Gan 2001
September 30, 2013 at 11:27 am
What Louis posted is the way to go; no DSQL needed for what you are doing. That said, to accomplish this with a temp table you would need to use...
-- Itzik Ben-Gan 2001
September 30, 2013 at 10:58 am
This will get you what you are looking for...
-- (1) Sample data
DECLARE @x_p TABLE (xid int, nbr1 int, cid int);
DECLARE @x_c TABLE (cid int, chr char(1), nbr2 int, nbr3 int,...
-- Itzik Ben-Gan 2001
September 30, 2013 at 10:09 am
Koen Verbeeck (9/26/2013)
erikd (9/26/2013)
Alan.B (9/25/2013)
...
marky.marks;
Made my day. 😀
Didn't even notice it at first 😀
I'm just happy someone noticed 😀
-- Itzik Ben-Gan 2001
September 30, 2013 at 9:26 am
As a DBA I used a number of tools in the DBA bundle and was a big fan.
If you ever get a chance to attend a SQL in the...
-- Itzik Ben-Gan 2001
September 26, 2013 at 11:14 am
Below is a script that will get you information about all the jobs that ran between a two dates. I was not able to figure out how to get you...
-- Itzik Ben-Gan 2001
September 26, 2013 at 11:01 am
Viewing 15 posts - 2,101 through 2,115 (of 2,458 total)