Viewing 15 posts - 1,096 through 1,110 (of 11,678 total)
It doesn't really make sense without screenshots. Is it possible to post some?
January 22, 2015 at 11:15 am
Innocent victim of the spam filter?
Someone apparently tried to post an attachment to a thread.
I got this notification in my email, which is a dead end:
http://www.sqlservercentral.com/Forums/FindPost1653774.aspx
In the thread itself someone...
January 22, 2015 at 11:09 am
Samuel Vella (1/22/2015)
I did reply with a package for you... not sure what happened to itSam
I think the spam filter removed it.
January 22, 2015 at 11:07 am
Do some of the images overlap? SSRS hates overlapping objects.
January 22, 2015 at 6:23 am
I did exactly the same as PB_BI suggested in his reply.
I use 0 (unknown) and -1 (N/A) as special surrogate keys in the DWH. This enforces referential integrity. If you...
January 22, 2015 at 4:55 am
SQL Server 2008R2 is an entire new version of SQL Server, so you need to either do an upgrade of SQL Server 2008 or you can install a new instance...
January 22, 2015 at 12:58 am
Depends a bit if you want SFTP or FTPS or some exotic features, but I have used WinSCP most of the time without issues.
January 22, 2015 at 12:56 am
Got this one wrong. I was thinking NULL would be counted as a distinct value, and I realized too late I was confusing it with unique indexes.
Ah well, very nice...
January 22, 2015 at 12:51 am
This great article gives you a few options to concatenate row values:
Concatenating Row Values in Transact-SQL[/url]
I prefer the XML one.
All you have to do is concatenate the column servername and...
January 21, 2015 at 1:50 pm
You can only use the CTE in the first UPDATE statement.
You either have to define the CTE again, or use a temp table or a view. (or a table variable)
January 21, 2015 at 8:09 am
Stefan Krzywicki (1/21/2015)
I see how to change my name on my account and I'll go do that here in a minute. I'm just not sure it'll cascade to everything else.
It...
January 21, 2015 at 8:07 am
Phil Parkin (1/21/2015)
Koen Verbeeck (1/21/2015)
Phil Parkin (1/21/2015)
RonKyle (1/21/2015)
I use ID. It's an abbreviation that otherwise doesn't form a word.'Id' is an abbreviation of a single word ...
As I pointed...
January 21, 2015 at 7:41 am
Phil Parkin (1/21/2015)
RonKyle (1/21/2015)
I use ID. It's an abbreviation that otherwise doesn't form a word.'Id' is an abbreviation of a single word ...
As I pointed out earlier, that is...
January 21, 2015 at 7:30 am
What exactly do you mean with parallel execution of a package?
Do you mean executing multiple packages in parallel, or executing the contents of a single package in parallel?
January 21, 2015 at 2:07 am
Viewing 15 posts - 1,096 through 1,110 (of 11,678 total)