Viewing 15 posts - 8,011 through 8,025 (of 8,760 total)
Jeff Moden (6/14/2014)
I'll be back...
:smooooth:
It certainly looks, smells and tastes like a CDR, question is what is the originating system, record type and record format? Many CDR formats are slightly...
June 14, 2014 at 9:21 am
Here is a solution based (loosely) on DelimiterSplit8K.
😎
USE tempdb;
GO
DECLARE @STGTXT TABLE
(
STGTXT_ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED NOT NULL
,STGTXT_TEXT VARCHAR(MAX) ...
June 14, 2014 at 7:15 am
Quick thought on this, I think there is a slight mix-up in the conversation. Using integer in a YYYYMMDD format as a date dimension key in a datamart is not...
June 14, 2014 at 12:21 am
Jeff Moden (6/13/2014)
Eirikur Eiriksson (6/12/2014)
Quick thought, wouldn't it be simpler to have an SSIS package for shuffling the backup files around, no need for XP_CMDSHELL etc.😎
Since you brought it up,...
June 13, 2014 at 11:02 pm
sql_novice_2007 (6/13/2014)
I am not seeing the export option even though I connected to SSMS as an administrator and I have sysadmin privileges.Thanks.
You have to use BIDS or SSDT, not SSMS....
June 13, 2014 at 12:23 pm
Kuzey (6/13/2014)
Luis Cazares (6/13/2014)
Kuzey (6/13/2014)
Hello,You commented the parameters code. If you uncomment it, you need to use @dId instead of @aId on the third parameter for sp_executesql.
When I run this;
EXEC...
June 13, 2014 at 12:19 pm
Kuzey (6/13/2014)
Eirikur Eiriksson (6/13/2014)
Quick question and bear with me hear, but why do you need the cursor, the inner sql has no exec statement?😎
SET @sql='SELECT @aId, @dId, @dStatusId, d.DateCreated, d.DocumentSize,...
June 13, 2014 at 12:17 pm
Quick question and bear with me hear, but why do you need the cursor, the inner sql has no exec statement?
😎
June 13, 2014 at 11:56 am
This should get you started, two different methods.
😎
USE tempdb;
GO
DECLARE @TDATA TABLE
(
Id INT
,Calling VARCHAR(12)
);
INSERT INTO @TDATA
(
...
June 13, 2014 at 1:13 am
Phil Stratford (6/12/2014)
June 13, 2014 at 12:59 am
Koen Verbeeck (6/13/2014)
Sean Lange (6/12/2014)
below86 (6/12/2014)
Sean Lange (6/12/2014)
below86 (6/12/2014)
June 13, 2014 at 12:38 am
Suresh Arumugam (6/12/2014)
Hi All,Can any one please share your experience or thoughts for my above query?
Thanks.
My 2 cent on this, as this is a one-off exercise, let the wizard do...
June 12, 2014 at 11:31 pm
sqladmin 33439 (6/12/2014)
how do i change connection database from master database to own database please
In T-SQL there are two main options, either use a system stored procedure sys.sp_defaultdb or ALTER...
June 12, 2014 at 10:50 pm
JustMarie (6/12/2014)
Going to have...
June 12, 2014 at 1:49 pm
Second thought:w00t:
why not backup straight to the network drive? No need to write the backup locally!
😎
June 12, 2014 at 1:32 pm
Viewing 15 posts - 8,011 through 8,025 (of 8,760 total)