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!

Register Log in
  • Congratulations derfloh 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. Alan0568

    Help with sql query...please

    ...= @date end set @max_date = @date set @curr_id = @id if @row_count = @@CURSOR_ROWS begin insert #temp_results select @curr_id,@min_date,@max_date end fetch next from a_cursor into @date, @id end close a_cursor deallocate a_cursor GO select * from #temp_results drop table #temp_results
  2. Alan0568

    Navarre report scheduler v5

    Have you looked at Sql Server Reporting Services (SSRS) ?. It has very good scheduler/subcription/email export capability built in. If you have a sql license then you basically already have this?
  3. Alan0568

    Iterate through Columns per row via Script Component

    Good stuff, glad you are sorted.
  4. Alan0568

    Iterate through Columns per row via Script Component

    ...in one select with a hard coded identifier column 'A' & 'B' for the two outputs. -- Rows with more than one which are all the same select t.* from test t inner join (select x.AUTOMATCHID, count(distinct creationid) as cid from (select AUTOMATCHID,A_CREATIONID as creationid from test...
  5. Alan0568

    How to add Server Admin from different Location

    If I have understood correctly you want to add users/groups from another domain? I think to achieve this your network guys will have to establish a 'domain trust'
  6. Alan0568

    How to convert transaction Rows into Columns on the new Table

    Sorry but in your new sample you now don't have staff (userid) and are now using RESULTCODE as appointment. If you have found a script that does what you want then go with that.
  7. Alan0568

    Not Like including nulls

    Because thats the way nulls behave for comparison. I allways just use isnull to present an arbitrary value, in this case '' (blank) SELECT * FROM [MTR_MAT_SUPER_TYPE] WHERE DATEPART(m, [MTR_LODG_DATE]) = DATEPART(m, DATEADD(m, -1, getdate())) AND [MTR_REG_CODE] is not null AND...
  8. Alan0568

    MANY txt (csv) files... I need to import them in bulk.

    Yes. The 'foreach loop container' is ideal for this used with a Foreach File enumerator. http://msdn.microsoft.com/en-us/library/ms141724.aspx
  9. Alan0568

    How to convert transaction Rows into Columns on the new Table

    As we can see from the sample data that appointments are not Unique can you provide a revised required output which caters for this?
  10. Alan0568

    How to convert transaction Rows into Columns on the new Table

    So you only want ap1,ap2 & ap3 ? and can you confirm if an ap1 record would always exist, or could you get data for a staff member with just ap2 & ap3? (that you would want)
  11. Alan0568

    How do I supress an sql column from displaying conditionally?

    Thats not the same as it outputs a column and only makes the content null based on a condition. Oracle noprint and starskys solution don't output the column at all, which is what the op wants.
  12. Alan0568

    How to convert transaction Rows into Columns on the new Table

    As Simi has said, need some more detail but shooting from the hip and assuming that the first appointment always exists ..... select ap1.staff, ap1.appointment1, ap1.date1, ap1.successful1, ap2.appointment2, ap2.date2, ap2.successful2, ap3.appointment3, ap3.date3, ap3.successful3...
  13. Alan0568

    Maybe a Crazy Idea? Build a Custom Dynamic Summary of a Table..

    Have you had a look at the SSIS Data Profiling task and the utility to read the output DataProfileViewer.exe ?
  14. Alan0568

    SQL Server remote connection problem

    Forgot to add, you will need to restart the sql server service itself after the changes.
  15. Alan0568

    SQL Server remote connection problem

    As sql express typically installs as an instance .... servername/sqlexpress you must have the 'SQL Server Browser Service' running. Also within server properties > security make sure you have the correct 'server authentication' mode. Eg if you are passing a username/password in your string...
  16. Alan0568

    Having trouble with correct T-SQL syntax for linked server trigger

    >>OPENQUERY (LDOS,"INSERT INTO LDOS.tblProjectnumbers (TransID, >>CustId)VALUES(@TransId,@CustId)" as a starter this needs a tidy. should be OPENQUERY (server ,'query') so single not double quotes in the correct place and the number of brackets are wrong also.
  17. Alan0568

    How to change DBName in connstring dynamically

    First you can create package variables of type string for the whole connection string, server name or just initial catalog properties (amongst others). Modify the properties of the connection by expanding the 'expressions' and assigning your variable(s) to the property(s) To update the...
  18. Alan0568

    ODBC System DSN Server List Is Empty

    Are the sql servers named instances? and do you have the sql server browser service running?
  19. Alan0568

    Need help with summing up results

    change the order to order by sum(a.docamnt) desc
  20. Alan0568

    Need syntax for 1 year prior the given date

    please post the sql (context) in which you are using it.

Part and Inventory Search

Back
Top