SQL Server

Page 2459




  • Topics
    Replies
    Last post
  • Retrieve record just updated
    by Tim Riley
    3 Replies
    Last post by Tim Riley
      • I want to add an update trigger to keep a LastDateModified column up to date. I also want to make the trigger as generic as possible so I can cut&paste into others, the column has the same name throughtout the system. How can I retrieve the record I just updated so I can change the date Also, if my update trigger updates a record, will this cause a loop
  • Beginning MDX
    by tenchyz
    1 Replies
    Last post by tenchyz
      • I'm pretty new at Mdx , so bare with me. I want to make a calculated member called Occupant Fatalities. The occupant fatalities looks like this right now: ( [Measures].[Fatalities] , [Crash Person].[Person Type].&[Driver]) Now the question is , How do i add another person type to this calculated member. It wont work when i do this. ( [Measures].[Fatalities] , [Crash Person].[Pe
  • Order by using @Params
    by AndyRayner
    6 Replies
    Last post by hunchback
      • Hello, Basically I am trying to do an order by statement using variables. I have the SQL: IF @SortOrder = 'ASC' BEGIN SELECT DISTINCT D . Code as 'T1' , D . CompanyName as 'T2' , S . SpendAmount as 'T3' , E . SpendAmount as 'T4' , E . SpendAmount - S . SpendAmount as 'T5' , Case When S . SpendAmount > 0 Then (( E . Sp
  • Overflow the disk I/O buffer
    by SQLChamp
    14 Replies
    Last post by SQLChamp
      • Hello, I am getting "overflow the disk I/O buffer" in my SSIS, and what's weird is that when I construct the same SSIS in a new package, it works perfectly. I almost want to believe that it could be a bug. Some days when I import the files, it works fine, but some days it errors out with this error on the last column. Is there some setting with CR/LF or LF that I have to pay attention
  • I just need to know - is this even possible to do w/o scripting???
    by sadie519590
    13 Replies
    Last post by K108
      • What I need to do - can it be done without scripting 1.) I need to get a list of sp's from a table (EXEC SQL task) 2.) Next, loop through the list of sp's and execute (FOREACHLOOP) 3.) Then, write the output of each sp to a uniquely named file. (DATA FLOW task) So far, I have had success with 1 and 2. But getting the DATA FLOW task to work has been imposssible thus far.
  • Bitmask query?
    by taylonr
    2 Replies
    Last post by taylonr
      • I'm working on a new app with Sql CE and before I got too deep in DB design, I wanted to make sure that it can support a bitmask query. What I want is a bit-packed field to handle support for region. So I'd like to be able to take a field (e.,g. [Support]) and do a bitwise and with the current region code and see if it is supported. I know I could get all the data and write a method
  • How to shchedule the jobs in SQL EXPRESS
    by Trivedi Nikesh
    1 Replies
    Last post by Deepak Rangarajan
      • hi friends, I didn't get that, how do I schedule the jobs like full backup or transactional backups in the SQL EXPRESS with hope or reply from your side.
  • Script component Errors
    by bob the unknown from mars
    6 Replies
    Last post by DarrenSQLIS
      • How come when i compile the package and try and run the package outside of the Developement enviroment(Visual studio) it complains about all my ssis scrip tasks. It brings up an error saying, it can not run under this edition of Integration services. It requires a higher level. Is there another type of ssis that i do not know about, can you supply me a URL to help solve this problem Than
  • Primary Key Function
    by manoool
    12 Replies
    Last post by John Gordon - MSFT
      • Hi..... I want to ask about two thing and I hope that some one can help me: 1- I want to create apimary key from 6 integer digits that contain two part the first part is the first two number from the year the second part is auto generation number from 0000 to 9999 for example: in this year "2007" the number will be from 070000 to 079999 how can do this
  • error when attempting to configure a local distributor
    by Duane Douglas
    11 Replies
    Last post by Gary Chen
      • i'm getting the following error message when i attempt to configure my server as a local distributor: TITLE: Connect to Server ------------------------------ Cannot connect to 9A6375C3046246B. ------------------------------ ADDITIONAL INFORMATION: Failed to connect to server 9A6375C3046246B. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ An error ha
  • Help with SQL Query
    by MdGo
    12 Replies
    Last post by [rh4m1ll3] Rhamille Golimlim
      • Given the following two tables below, I need help in writing a query that would retreive only 3 or less distinct values of BDesc from tbB table for every row found in tbA. for example: I expect result to be: Aid Bdesc 100 1st Desc for 100 100 2nd Desc for 100 100 3rd Desc for 100 200 1st Desc for 200 200 2nd Desc for 200 200 3rd Desc for 200 300 1st Desc for 300 300 2nd Desc for 3
  • Sub-Report suppression
    by JrDevRon
    0 Replies
    Last post by JrDevRon
      • Hey guys!! Another interesting question for you...I am trying to implement the suppression of sub reports but this is proving difficult. I have attempted to filter for Guid's and in the result of not having any then just supressing the whole subreport. However, Reporting Services doesnt like me using GUID's. I have implemented to filtering on the required fields from the application and this
  • Importing from Excel to Sql Server 2005
    by Anonymous1233333333333333
    3 Replies
    Last post by Anonymous1233333333333333
      • I have about 50 Excel files from which I have to import data with some transformations to Sql Server. My first approach was to use Excel Source component in a data flow to read the data . However, as it turned out column X in some files was being converted to a DT_NTEXT blob and in other files it was mapped to WSTR. The reason I guess is because column X contained string of varying sizes - some gr
  • Store and Retrieve Unicode Data
    by ShihabSumon
    3 Replies
    Last post by Jens K. Suessmeyer
      • HI, I want to store unicode data and retrieve them using C#. How can I do so Data is saved but can not retrive. The data displayed as ( ). Could Anybody Help me.
  • error when trying to browse SSRS on a remote machine
    by gcs_78
    4 Replies
    Last post by Chanduu
      • Hi, I deployed SSRS reports to my local report server and set the connection string to access a server on the network with Analysis Server. Result: I can access and use the reports from my computer. But when I use any other computer on the network I can't use the reports. I can access them but they don't find the database ant therefor they don't present any data. Error message as fo
  • SQL 2005- Cursor Loop
    by Fahad786
    2 Replies
    Last post by Fahad786
      • Please advice when i used loop in the below code its only returning last value from the sub table however i wanted to fetch all values from the sub-table---- Please advice.. ALTER Procedure [dbo] . [SyncEmpContGrid] @EmpID As Varchar ( 20 ) As Declare @CountryEOF bit , @i int , @CtR Varchar ( 1000 ) begin Declare @C_list Cursor Declare ContCr
  • Deleting records from multiple tables in SQL server
    by Juwar
    4 Replies
    Last post by Arnie Rowland
      • I'm new to relational database concepts and designs, but what i've learned so far has been helpful. I now know how to select certain records from multiple tables using joins, etc. Now I need info on how to do complete deletes. I've tried reading articles on cascading deletes, but the people writing them are so verbose that they are confusing to understand for a beginner. I hope someone could help
  • diferent way to a query
    by luisdanielurea
    4 Replies
    Last post by DaleJ
      • is theres a way to return the same result of this query without making the inner joins Code Snippet create view missEeCuts as select distinct e.* from events e inner join ( select eventid, sum(px) as sum_px from isolatedLeptons group by eventid ) l on e.idevent=l.eventid inner join ( select eventid, sum(py) as sum_py from isolate
  • Database diagrams
    by Sarah21
    6 Replies
    Last post by gryzz12
      • I have just installed SQL server Express and am trying to create a database diagram. When I right click on database diagram, I just get the options to use help or to refresh. There is no option to create a new diagram, Thanks, Sarah
  • Hello? Left Join?
    by Telos
    7 Replies
    Last post by DanR1
      • Am I missing something I thought LEFT JOIN made the first table return a value even if there was nothing in the second table. Yet this query: SELECT b . name , isnull ( c . call_no , 0 ) FROM business b LEFT JOIN call c ON b . business_id = c . service_business_id WHERE b . business_id = 1000634 AND c . create_time BETWEEN @startDate AND @endDate I
  • Starting SQL Server BEFORE login
    by li4li4tsai4
    7 Replies
    Last post by Arnie Rowland
      • Hi, I would like to access data from SQL database (SQL 2005 express) BEFORE Windows login (actually, the data I want to retrieve is the login name and password for Windows login). Is there a way that I can start the engine before I login Thanks in advance
  • Weird behavior using variables in script component
    by KoryS
    14 Replies
    Last post by jwelch
      • I have a script component in a data flow that is exhibiting some strange behavior. In the PreExecute event of the data flow, I stuff a recordset into a variable that is declared at the data flow scope. Within the data flow, I use a script component to read in the data from the recordset. Example: Dim olead As New Data.OleDb.OleDbDataAdapter Dim dt1 As New System.Data.Da
  • Conditional checks in SSIS.
    by ASOOD
    14 Replies
    Last post by Dave Sundell
      • I have two connections in a package pointing to two different databases on the same server. I have to insert records from 'DB1' table 'Gender1' to 'DB2' table 'Gender2'. Before I do that though, I have to make sure the minimum value (of all the Gender Keys that are going to be inserted) of 'DB1' 'GenderKey' (which is an identity field) is greater than the maximum value of DB2-GenderKey (which is a
  • can not create/modify maintainence plan after apply sp2
    by Jessie J
    8 Replies
    Last post by Jessie J
      • I set up two sql server 2005 64-bit enterprise edtion servers. First one, I installed SQL server 2005, then apply sp1, created 2 maint plans and they were working fine. Once sp2 is out this Feb, I applied it and found out today that I can not modify the 2 plans that I created. I can not create any new plan due to error "method not found". On the second server, I installed sql server 2005
  • change the sheet name while exporting sql data to excel
    by raj416
    3 Replies
    Last post by Paul.G.
      • i have designed a rdl form which contains 3 tables .. i gave page break for each table. when exporting the file to excel it generates 3 sheets .. three sheets name comes like sheet 1, sheet2 ,sheet3.. i dont want it to be like these.. instead of that i have to give my own name while generating reports from rdl form like this (s1,s2,s3)...