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 strongm 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. EKOnerhime

    How many Cubes on Analysis Services ?

    Jamie Thomson created an SSIS package you can download that loops through each dimension and measure group processing them individually. http://consultingblogs.emc.com/jamiethomson/attachment/4235.ashx This may lessen the load on your AS server.
  2. EKOnerhime

    [b]Using Wildcard for An Variable[/b]

    Ah I see, I used 2 variables to avoid that, it's not a great overhead.
  3. EKOnerhime

    Removing Duplicates

    The first part of the statement does a standard select and would normally give you all the records. select dbo.IPTable.rowid, dbo.IPTable.[Name], dbo.IPTable.IP, dbo.IPTable.UA, dbo.IPTable.Date from dbo.IPTable The second part of the statement finds the minimum rowId for each unique...
  4. EKOnerhime

    Removing Duplicates

    Joining the table back to itself and grouping by the fields you want should do it. select dbo.IPTable.rowid, dbo.IPTable.[Name], dbo.IPTable.IP, dbo.IPTable.UA, dbo.IPTable.Date from dbo.IPTable inner join ( select min(rowid) min_rowid from dbo.IPTable group by [Name], [IP], [UA] ) min_IPTable...
  5. EKOnerhime

    Union Query Error

    The error doesn't seem to be a SQL error - are you using Microsoft SQL Server? If so, which version?
  6. EKOnerhime

    Min() Max() and Avg() return 0 instead of NULL?

    Untested but should work: Select c.yyyy, c.mm, h.hhname, ISNULL(Max(f.MessageCount),0) As HighestSendsToOneDevice, ISNULL(Min(f.MessageCount),0) As LowestSendsToOneDevice, ISNULL(Avg(cast(f.MessageCount as float)),0) As AverageSendsToOneDevice From...
  7. EKOnerhime

    [b]Using Wildcard for An Variable[/b]

    No problem, it's something I've worked on myself. To get the File Name: In your Data Flow Task, you can use a Derived Column between your Flat File Source and your destination table. Use the Variables and drag the User::FileName expression to create a derived column. I used a DT_STR data type...
  8. EKOnerhime

    Need a query to group by consecutive minutes

    Ah, George beat me to it, I dug out a version without temporary tables. CREATE TABLE #Duration([DurationId] int identity(1,1), [Company ID] varchar(3), [Time] datetime) INSERT INTO #Duration([Company ID], [Time]) VALUES('AAA', '13:09') INSERT INTO #Duration([Company ID], [Time]) VALUES('AAA'...
  9. EKOnerhime

    Conditional database field

    Glasgow: It doesn't do a pre-check on SQL 2005 SP2. I'm using a 64-bit flavour and have tested it using the script direct and an SP. How very odd! If you find out why, please post, I'm quite curious.
  10. EKOnerhime

    Conditional database field

    Could you check directly in INFORMATION_SCHEMA.Columns view? e.g. IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Client' AND COLUMN_NAME = 'VATNo') BEGIN UPDATE Client SET VatNo='1234 564 789' END
  11. EKOnerhime

    [b]Using Wildcard for An Variable[/b]

    I've got this to work using 2 variables, a script task and a ForEach loop container. Variable #1 - WildCard at package scope. Variable #2 - FileName at package scope. Create a Script Task and set this to the wildcard desired e.g. Dim FilePart As String FilePart = Format(Now...
  12. EKOnerhime

    Indexing Help

    Not a direct answer to your question BUT there is a huge amount of indexing resource out there, but this I found to be a gem. The Ultimate Missing Index Finder by Jesse Roberge. http://www.sqlservercentral.com/scripts/Index+Management/63937/
  13. EKOnerhime

    Getting the user log in name

    If you need the currently logged in user including the domain name, SYSTEM_USER will give you this information. As long as the stored proc used by SSRS is being executed using the currently logged in users credentials, all should be well. Our current SSRS reports pass this information as a...
  14. EKOnerhime

    UNPIVOT

    Ignore the above, second attempt: CREATE TABLE #AT_TEMP([ID] VARCHAR(10), [NAME1] FLOAT, [FORM1] VARCHAR(10), [NAME2] FLOAT, [FORM2] VARCHAR(10),[NAME3] FLOAT, [FORM3] VARCHAR(10)) INSERT INTO #AT_TEMP([ID],[NAME1],[FORM1],[NAME2],[FORM2],[NAME3],[FORM3])...
  15. EKOnerhime

    UNPIVOT

    CREATE TABLE #AT_TEMP([ID] VARCHAR(10), [NAME1] FLOAT, [FORM1] VARCHAR(10), [NAME2] FLOAT, [FORM2] VARCHAR(10),[NAME3] FLOAT, [FORM3] VARCHAR(10)) INSERT INTO #AT_TEMP([ID],[NAME1],[FORM1],[NAME2],[FORM2],[NAME3],[FORM3]) VALUES('A1','7','ABC','2','ADFR','55','FRED') INSERT INTO...
  16. EKOnerhime

    SQL - One row with multiple values

    Rob Volk has created a dynamic cross-tabs/pivot table script that may meet your needs: http://www.sqlteam.com/item.asp?ItemID=2955 This article generated a huge number of responses, it's worth reading through them: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6216
  17. EKOnerhime

    continue with error

    You can do this using the GETDATE function. http://msdn.microsoft.com/en-us/library/ms188383(SQL.90).aspx Example: INSERT INTO tblgardiff_50 ([net_sales] ,[gross_sales] ,[cash_in_draw] ,[cards_in_draw] ,[your-date-column-here]) VALUES (@f1 ,@f2 ,@f3 ,@f4 ,GETDATE())
  18. EKOnerhime

    Syntax Error

    The column 1099flag does not conform to the rules for regular identifiers, square brackets are required e.g. [1099flag] http://msdn.microsoft.com/en-us/library/ms175874(SQL.90).aspx This will fix your first error but generate another: "Column 'table2.1099flag' is invalid in the select list...
  19. EKOnerhime

    continue with error

    INSERT INTO tblgardiff_50 ([net_sales] ,[gross_sales] ,[cash_in_draw] ,[cards_in_draw]) VALUES (@f1 ,@f2 ,@f3 ,@f4 ,@f5) You have 4 columns in the INSERT section and 5 variables in the VALUES section.

Part and Inventory Search

Back
Top