Viewing 15 posts - 91 through 105 (of 901 total)
Interesting Idea Phil, a CLR would certainly work, but the question is would the company allow a CLR to be placed on the server.
I know a few companies are...
February 18, 2015 at 4:47 am
Ok, I would ask why the change from SSIS to SQL.
IN SQL check out the HASHBYTES function.
eg
SELECT
COL1,COL2, HASHBYTES('MD5',COL1+'|'+COL2+'|')
FROM aTable
One other thing there's no guarantee that you will get...
February 18, 2015 at 4:01 am
Could you provide the Basic DDL for the source table along with the INSERT Script with the sample data, as like many others I'm adverse to opening Excel workbooks from...
February 18, 2015 at 3:33 am
A similar concept to Eirikur, but with a single CTE and LEFT Join in the main SQL.
WITH CTE_GetLatest
AS
(
SELECT
[Pax Id]
,[Flight Date]
,[Flight Number]
,[Status]
,[Last Mod Date]
,ROW_NUMBER()
OVER
(PARTITION BY [Pax Id],[Flight Date],[Flight Number]...
February 18, 2015 at 1:51 am
vipin_jha123 (2/18/2015)
in my source all the columns are varchar.I want to convert into ToBase64String value to get output like HjGrRZvXy/kMQE+NKwfXNA== ,
470xf2ZinGTq0PoQtPGiWQ==
regards,
Vipin jha
But why do you want to do this?
What...
February 18, 2015 at 1:32 am
Looking at what's been posted I'm linking this is some sort of ETL (or similar) process where you are trying to create a hash key on columns, in order to...
February 17, 2015 at 7:46 am
ChrisM@Work (2/12/2015)
It's not uncommon practice for a DBA to pass a poorly-performing query or stored procedure back to the cowboy developer with instructions to improve it. Here are a few...
February 12, 2015 at 7:16 am
What you've got is pretty close to what I was thinking, and it resembles a Party Data model, with 4 key tables, and you should get a reasonable normalisation of...
February 11, 2015 at 3:42 pm
This is the point I was trying to make why cant you just do this
CREATE TABLE #result
(
[Subject] varchar(100)
)
Create Table #result2
(
[Subject] varchar(100)
)
insert into #result ...
February 11, 2015 at 3:38 am
nwtsqlserv (2/11/2015)
I already have a spitter function mate...please have a read through my question again...thanks.
Why would you loop through a record set if the output is already a record set...
February 11, 2015 at 3:17 am
This article might provide you with the answer http://www.sqlservercentral.com/articles/Tally+Table/72993/
It provides a very efficient string splitter that return a Table.
February 11, 2015 at 2:46 am
In addition to Alan.b's link to Gails articles, there are is also another series called Stairway to SQL server Indexes, by David Durant, which is located here http://www.sqlservercentral.com/stairway/72399/
February 10, 2015 at 6:54 am
Technically SSIS isn't designed for this type of thing.
You can do Item 1 is simple just use a derived column with IIF logic see here : http://www.programmersedge.com/post/2008/09/30/SSIS-Using-IF(IIF)-logic-in-Derived-Column.aspx#.VNoLb02zVQs
The issue...
February 10, 2015 at 6:50 am
For Database design patterns Wiley has a set of three books this is a link to volume 1
http://eu.wiley.com/WileyCDA/WileyTitle/productCd-0471380237.html
In terms of Data Warehousing, any book by Inmon or Kimball will give...
February 10, 2015 at 4:49 am
This link should help
http://www.mssqlgirl.com/editing-published-ssis-package-in-sql-server-2012.html
I haven't tried to do this.
February 10, 2015 at 1:28 am
Viewing 15 posts - 91 through 105 (of 901 total)