Answer Questions

• arcliner how to create an copy of a certain record except one specific column that must be different & insert the new record in the table

  Hi I have a table with a user column and other columns. User column id the primary key. I want to create a copy of the record where the user="user1" and insert that copy in the same table in a new created record. But I want the new record to have a value of "user2" in the user column instead of "user1" since it's a primary key Thanks. try this: insert into your_table ( user , field2 , field3 , ... ) select 'user2' , field2 , field3 , .... from your_table where user = 'user1' Beautiful trick thanks a lot for sharing it Here is a little trick in Query Analuzer Or SSMS press F8, this will display the Object Explorer ...Show All

• Rajat Tripathi Memory Usage Grows over time

  I am very new to TSQL and the program that follows loops many times over several hours. In task manager I have noticed that the PF usage has grown from 1.08 to 2.05 over several hours and results in a virtual memory shortage error being displayed. I am inclined to believe I am doing something wrong and accumulating some stack space. Can anyone tell me what I am doing wrong PF does drop back to normal when I drop out of SQL. thanks in advance -Soup- use sm declare @test_date as smalldatetime declare @ticker char ( 6 ) declare @buy_date smalldatetime declare @buy_price smallmoney declare @sell_date_5d smalldatetime declare @sell_price_5d smallmoney declare @sell_date_10d smalldatetim ...Show All

• xavito about datetime

  I have to convert date such as '2006-09-21 13:27:25.077' to '20060921' any ideas thanks in advance Problem solved! datatime have many styles just like convert(char(8),getdate(),112) can perform what i want I attempted to convert(char(8),getdate()),but result is 'Sep 21...' I have no idea about that ...Show All

• devstuff ORDER BY efficiency

  Hi, I'm using a table with about 5 million records, i'm preforming a select query onthe table. I retrieve from that query about 2-4 million records when i'm not sorting the data the query return very fast. If I'm sorting the data (ORDER BY timestamp - when timestamp is a BIG_INT with an index) the query takes a long time to return about 30 seconds. I tryed to do the same thing with access DB and i get better results: the query with ORDER BY takes about 1 second. I dont think it's possible that access DB have better performance then SQL server, does any one have any idea what can be me problem thanks ishay. What's the definition of the index on the timestamp column Is it the clustered ind ...Show All

• gon_no1 SSIS Deployment Question about Conn Strings? Please Help.

  Hi everyone: I have a package(SSIS) that works fine on a local SQL Server. Once I deploy it to the server A, and change the connection strings, it throws the following error: Error: The AcquireConnection method call to the connection manager "DatabaseName" failed with error code xxxxx. Error: component "OLE DB Destination"(16) failed validation and returned error code xxxx. Error: An OLE DB error has occurred. Error Code: 0x80040E4D. Al OLE DB record is available. Source: "Microsoft SQL Native Client" Description: "Communication Link Failure" Error: Error: An OLE DB error has occurred. Error Code: 0x80040E4D. Al OLE DB record is available. Source: "Microsoft SQL Native Client&quo ...Show All

• break_r Why I can't save query in Query Builder?

  Either edit the query from Dataset edit dialog or in the query builder (switch the design mode to show the query string), I can't save the query and always get the following error: TITLE: Microsoft Visual Studio ------------------------------ The query cannot be retrieved from the query builder. Check the query for syntax errors. Reporting Services will continue to use the most recent valid query. ------------------------------ ADDITIONAL INFORMATION: Query preparation failed. (Microsoft.AnalysisServices.Controls) ------------------------------ I am sure there isn't syntax error in the query string because I only add a space after a comma. Please try the SQL Reporting Services forum: http://forums.microsoft.com/ ...Show All

• Patrice1974 Who's the idiot that designed the file destination?

  It's funny: Everyone thinks that CSVs are awesome to transport data. I mean after all, SSIS defaults to Comma Delimited files. Even Excel defaults to it. Microsoft is supposed to be our leader! They should get this right. And get the terminology correct too. How many people describe the file as comma separated It's delimited! Even SQL server calls it delimited by the "delimited" drop down. CSVs suck and i will tell you why: When you transport any text field (especially Address) it has the possibility of containing a comma. This causes data to be parsed into the wrong fields. Why in God's grace would you EVER get in the habit of choosing a delimiter that SOMETIMES doesn't work I'll tell you a little short story: I hav ...Show All

• Tej62007 SQL standard

  I just want to know which SQL Standard does the SQL Server & Oracle follows SQL-86 SQL-89 SQL-92 SQL1999 SQL-2003 as far as i know both sql server and Oracle 9i Database support/comply to the ANSI SQL-92 , thoug these are just the standards , actual implementation differs with the vendors. SQL-92 Additional :: Both SQL Server and Oracle do support parts of SQL-99 but neither of them supports the entire standard ... Thanks Mr Nitin Khurana ...Show All

• Jitusj SQL Execute Task

  Hi how would you use a package variable in inline sql, is there a format utilized Are there any steps I need to take to do that I currently have the SQL Execute task inside a ForEach Loop container, which has the variable mapping for the ID that i need for the SQL Execute task. I just need to know the syntax to use parameters in my query in my task. here is the current code which doesnt work: INSERT INTO LAFProcess.ProcessList (WorkListID, CreatedOn, ProcessStartedOn, Status) SELECT WorkListID, GetDate(), NULL, 2 FROM LAFProcess.WorkList WHERE Status = 2 AND LoanApplicationID = " + @[User::LoanApplicationID] +" UPDATE LAFProcess.WorkList SET Status = 1 WHERE LoanApplicationID = " + @[User::LoanApplicationID] +& ...Show All

• Brazzle Send email and Post to DB using Notification Services

  Can you send out an email and also post the same data that is in the email to a database using notification services I want to be able to send out the emails using notifications services, but I also want to be able to track the emails that went out. Any ideas Thanks, S Because the NS architecture, all data you send are saved on NS database (also you have some views to take it). The service do not mind if you send if via email or you use another protocol like filechannel, all the data are collect in your notificationclass and stored in DB. Hope this help ;) ...Show All

• Alexnaldo Santos Error when browsing processed Cube

  Hi, I get an error after making calculation changes to a cube.The AS solution builds and processes fine, but when I browse to the region of the cube where the MDX change has impacted I get the following error: "An Error 0xE0040200 occurred. No Further information was provided." The popup box is titled as: Microsoft Pivottable List. I've got this same error on my PC running the September CTP, and a development server running the RTM. i.e. if I change the following working piece of MDX in a calc Aggregate( { [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc BSC Time Dim Calculations].DefaultMember } * PeriodsToDate( [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember.Level, [BSC T ...Show All

• mgaur_MSFT Error: SQL Server Internal Error. Text manager cannot continue with current statement..

  When my production server processing some queries suddenly the SQL Server service crashed and following error was in the error log: SQL Server Internal Error. Text manager cannot continue with current statement. The server is running SQL Server 2000 with SP4. I am really concerned because this is a production sever and there are over 300 users access concurrently. Please help me to find a solution. Thanks, Roshan. You can try bcp out the data and reimport the blob. However, the best thing is to contact CSS. Yes I am using sql2k. product version 8.00.2039[SP4]. Do you know "State" value in your error message It can narrow down potential causes. For example, Msg 7102, Level ...Show All

• Dexter Role design issue

  I have a strange roles problem. Is there a way we can accomplish this: Say, the fact table has 100 records. each record having a new account number (100 accounts in 100 records). The problem is we have users who have to see only some accounts. For example, user 1 has to see only accounts 1-10, user 2 has to see only accounts 11-20, user 3 has to see only accounts 21-30. and so on... I know we can create different roles and create perspectives for these roles, but the problem is the list that defines what they can see is a table of 1000 user entries, each row has its own conditions for each user type. (Actually, each condition is a combination of different dimensions. For example, user 1 has to see account 1-10 and products A-D) ...Show All

• oompa_l yesterday statement

  Hi, I am trying to substract one day from my current date and are having difficulties any suggestions =IIF(Fields!DOCDATE.Value = today-1 and Fields!SOPTYPE.Value =3,Fields!XTNDPRCE.Value, IIF(Fields!DOCDATE.Value = today-1 and Fields!SOPTYPE.Value =4,-(Fields!XTNDPRCE.Value), "0" )) The following expression calculates 'Yesterday': =Today.AddDays(-1) -- Robert Thx a stack ...Show All

• Jwrayth Yearly, monthly... basis report based on the parameter values

  Hi guys, I am created a bar chart report. The x-axis value of this chart is a timestamp(datetime) field of a dimension. Thousands of records are inserted in to this field everyday, as a result, I will have the timestamp information every second or minute. So here is the thing, If I want to present last month data in the bar chart(x-axis), the chart can not accomodate all the data and it doesn't look good to present a data in every second or minute. So I want to present the data on yearly, monthly, weekly, daily or hourly basis based on the StartDate and EndDate parameters value provided by the user. Any idea is appreciated. Sincerley, Amde Amde, Did you ever get an answer or find one out f ...Show All