I discovered the tool WWW SQL Designer (created by Ondrej Zara) years ago and was happy to notice that it…
September 30th, 2009
SSIS: Execute Package via Stored Procedure
1 Comment, IT, SQL Server, by Ralf.There are two options executing SSIS packages: – xp_cmdshell command (not recommended for security reasons) – sp_start_job command The main…
April 17th, 2009
SSIS: Split Excel cell values into rows
6 Comments, .Net, SQL Server, Uncategorized, by Ralf.Here I would like to show you a solution for following problem. One source row coming from Excel contains several…
April 17th, 2009
T-SQL: Split column in several rows
No Comments, .Net, SQL Server, by Ralf.problem If I have a column with several values (separated by CR) which I need separated into rows then following…
April 16th, 2009
SSIS: Excel Import Column Data Types
2 Comments, .Net, OpenSource, PHP, SQL Server, by Ralf.When Excel data is not coming into SSIS right, then do the following: use option “IMEX=1” in ConnectionString (Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\..\MyExcel.xls;Extended…
March 24th, 2009
SQL Server: Version, Service Pack, Edition
1 Comment, SQL Server, Uncategorized, by Ralf.SQL Server: Version, Service Pack, Edition Just run following command within Management Studio: SELECT @@VERSION, SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)…
August 10th, 2006
INSERT INTO.. aus SELECT
7 Comments, Business Intelligence, IT, by Ralf.Mit folgender SQL-Abfrage kann man in ein “INSERT INTO” ein SELECT Statement einbauen: INSERT INTO table1 (column1, column2) VALUES(@parameter1, (SELECT…
April 8th, 2006
MS Access: Multiselect in Queries
28 Comments, IT, VBA, by Ralf.In MS Access verwendet man in den Benutzerschnittstellen gern Listen mit Multiselect-Funktion, um dem Anwender flexiblere Auswahlmöglichkeiten zu bieten. In…
April 8th, 2006
MS Access: IF EXISTS DROP TABLE
1 Comment, IT, VBA, by Ralf.Leider ist es in MS Access nicht ohne weiteres möglich das Vorhandensein einer Tabelle abzufragen. Dies wird gerade wenn man…