Viewing 15 posts - 2,056 through 2,070 (of 11,678 total)
Seems like an (almost) duplicate post from this one:
http://www.sqlservercentral.com/Forums/Topic1604321-364-1.aspx
There is a lot of text in your message, but actually not a single question. 😉
Personally I'd try with a simple lookup...
August 18, 2014 at 3:26 am
This is possible, but only when using partial caching (which might not be as performant). Is there a reason to use the variable?
What about just joining the staging table and...
August 18, 2014 at 3:21 am
Shiva N (8/18/2014)
Hi Try this:Print('select case when '''+@action+'''='''+@dbname+''' then '+cast(@a as varchar)+' else '+cast(@b as varchar)+' end')
I consider leaving out length specifications for strings (and leaving it up to the...
August 18, 2014 at 1:46 am
I have an article on how to implement SCD in SSIS using different methods and I compare them against each other.
Four Methods for Implementing a Slowly Changing Dimension in Integration...
August 18, 2014 at 1:09 am
Since you are mixing integer data types with string data types, the + operator is not used for string concatenation but for the mathematical addition.
And you can't "add" a string...
August 18, 2014 at 1:06 am
SQLRNNR (8/15/2014)
sestell1 (8/15/2014)
XML... yuck. :sick: :laugh:+1
+2
Thanks for the question.
August 18, 2014 at 12:44 am
Luis Cazares (8/14/2014)
Grant Fritchey (8/14/2014)
Evil Kraig F (8/14/2014)
djj (8/14/2014)
ChrisM@Work (8/14/2014)
remember '76/'77
Wish I could remember what last year was like, I remember some nice days for '77 as I have...
August 16, 2014 at 6:30 am
GilaMonster (8/15/2014)
Eirikur Eiriksson (8/14/2014)
You can try out these methods as previously suggested
However OP said
I really don't like this temp table creation
So, no row number, no temp tables. Really limits...
August 15, 2014 at 2:55 am
akash_singh (8/14/2014)
Can you please give solution in SQL 2008 as well as IIF does not work in SQL 2008.
IIF is shorthand for a CASE statement. I'm sure you can figure...
August 14, 2014 at 6:26 am
For such questions, it would be nice if you provided table DDL, sample data and desired output.
See the first link in my signature on how to do this.
CREATE TABLE [dbo].[Salaries](
[ID]...
August 14, 2014 at 5:56 am
GilaMonster (8/14/2014)
Koen Verbeeck (8/14/2014)
- create a running total on this column.
You can use the quirky update method laid out by...
August 14, 2014 at 4:07 am
GilaMonster (8/14/2014)
Koen's suggestion wasn't serious (I nope) and besides would violate your 'no loops' requirement I suspect.
I was not serious 😀
This is serious though:
- add a column with only the...
August 14, 2014 at 3:59 am
Indu-649576 (8/14/2014)
I really don't understand the CLR /CTE concepts ..somebody ..plz explain
It was an attempt to a joke. Don't use CLR unless you like being miserable.
Go with the temp table/identity...
August 14, 2014 at 3:54 am
Viewing 15 posts - 2,056 through 2,070 (of 11,678 total)