Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. burakcan

    Configuration file parameters

    Hello, I have 2 SSIS packages. Basicaly they do the same thing except Package_1 is using configuration file and Package_2 doesn't. Configuration file has 3 variables, Extract_Start_date, Extract_End_date, and Historical_load, depending on Historical_load value StartDate and EndDate get value...
  2. burakcan

    Loading and Updating Temp tables in SSIS

    ...any error. Please see the creation of the tables script and update script below : Any help greatly appreciated. Thanks IF exists ( SELECT * FROM tempdb.dbo.sysobjects o WHERE o.xtype IN ('U') AND o.id = OBJECT_ID(N'tempdb..##PI_CC_CreditLimitChngAccounts') ) DROP TABLE...
  3. burakcan

    How to convert string DD-MMM-YY date to Date format in SQL.

    Thanks Olaf/Greg/Borislav/Skip. It works now. :)
  4. burakcan

    How to convert string DD-MMM-YY date to Date format in SQL.

    Yes there is no birthdates in your table from 1900 through 1917.
  5. burakcan

    How to convert string DD-MMM-YY date to Date format in SQL.

    Thanks Borislav As I mentioned this is the birth date field. If we get someone birtdate in after 2000. Date will be something like 15-Jan-01. then this approach wont work :-(
  6. burakcan

    How to convert string DD-MMM-YY date to Date format in SQL.

    Thanks Greg but My date year is 1949 not the 2049 (This is birth date field)
  7. burakcan

    How to convert string DD-MMM-YY date to Date format in SQL.

    Hello, How to convert string DD-MMM-YY date to YYYY-MM-DD Date format in SQL? Sample '17-Jun-49' --> 1949-06-17 Thanks for the help.
  8. burakcan

    How to read data between 2 servers using tempdb in ssis

    ...from another tables in server1 then load the table in server2 In SSIS I created temptable using Execute SQL Task Editor. IF exists ( SELECT * FROM tempdb.dbo.sysobjects o WHERE o.xtype IN ('U') AND o.id = OBJECT_ID(N'tempdb..##PI_CC_CreditLimitChngAccounts') ) DROP TABLE...
  9. burakcan

    Hierarcy

    Hi All, I have dimension table as you see in the picture. District_Key is the key joining the fact table. But I like to create a hierarchy with New_DVP column and summarize the measure based on the New_DVP. Can anyone help me for this? Thanks...
  10. burakcan

    Reading .csv file

    Hi All, I have a .csv file (, separated) which I read into the SQL server, but there is a value like "Manitoulin, Unorganized, West Part". Because of the ,s in the value SSIS put each word into next field. Is there any way to put whole value into the one field? Thanks
  11. burakcan

    How to convert Null or empty datetime value to default datetime value using SSIS derived column

    Hello, How can I convert Null or empty datetime value to default datetime value ("1900-01-01") using SSIS derived column transformation in SSIS? I need to check both empty or Null date values. Thanks
  12. burakcan

    How to hide unwanted dimension values in SSAS cube

    Hello, There is a key in my fact table which I don't want to show them in the cube. I mean I redirect some values as a -1 key (N/A) in fact table. In dimension table -1--> N/A. I am trying to hide those N/A values in the dimension to not to show them to the user. Any suggestion? Thanks...
  13. burakcan

    How to increase a counter for each changed rows in SQL query

    Hi Olaf, Thank you very much for your help. I am using below script and it seems working :) ;with cte as (SELECT a.[ApplicationID] , a.[DecisionTypeDetailDate] , SUM(ConVert(Int,b.[ResubmitTOD])) AS ResubFreqTOD , SUM(ConVert(Int,b.[ResubmitTOS])) AS...
  14. burakcan

    How to increase a counter for each changed rows in SQL query

    :( Thanks Olaf. Still I need to find a another way.
  15. burakcan

    How to increase a counter for each changed rows in SQL query

    Hi Olaf, The compatibility_level is 100.
  16. burakcan

    How to increase a counter for each changed rows in SQL query

    Hi Olaf, Please see the screen shot to see the error messages. It works in server 2012 but not in 2008 R2. I need to do this in server 2008. Also this is just an example data I need to order by DATE and ID Please...
  17. burakcan

    How to increase a counter for each changed rows in SQL query

    Thanks Olaf, Getting error on the query .
  18. burakcan

    How to increase a counter for each changed rows in SQL query

    (No column name) Microsoft SQL Server 2008 R2 (SP3)
  19. burakcan

    How to increase a counter for each changed rows in SQL query

    Unfortunately I am using Server 2008 :-(
  20. burakcan

    How to increase a counter for each changed rows in SQL query

    Hello, I need to increase a counter for each changed rows in SQL query . I have a column holds values 0 or 1. Id like to create a new column based on the column C which holds 0 or 1. If the value is 0 then my new value will be 0 if it is 1 then my new column value at the first 1 then for the...

Part and Inventory Search

Back
Top