EXEC in WHERE clause

Transact-SQL

Index ‹ SQL Server

- Previous
  - 1
    - Performance Problems One of the nifty features of SSMS. WesleyB Visit my SQL Server weblog @ http://dis4ea.blogspot.com Tag: EXEC in WHERE clause
  - 2
    - Query based Textbox Got the following error: The Value expression used in textbox ‘Client’ returned a data type that is not valid. Tag: EXEC in WHERE clause
  - 3
    - OPENROWSET Error I am trying to execute the following ad-hoc query (I have already configured the remote server to allow ad-hoc queries): --EXECUTE AS USER = suser_name() SELECT c.* INTO #MyTempTable FROM OPENROWSET('SQLNCLI', 'Server=MyRemoteServer;Trusted_Connection=yes;', 'select * from mydb..mytable (nolock) where PurchaseOrderID in (''19509114'', ''24075854'')) AS c; I receive the following error message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I have admin privileges on the remote box-how can I get this to execute in the context of my account rather than this NT AUTHORITY\ANONYMOUS LOGON account Thanks, -Dave Tag: EXEC in WHERE clause
  - 4
    - Reporting services configuration NO initialization I am installing sql server 2005 reporting services on server running sql server 2005. I get to the reporting services configuration page and configure... report server virtual directory report manager virtual directory windows service identity web service identity database setup encryption keys when I get to Initialization the button is grey and inactive so I can't initialize reporting services, Do I need to restart server Tag: EXEC in WHERE clause
  - 5
    - SQL Server 2005 and DTC enabling on 2k Server I am using SQLServer 2005 and .NET when I use the following statements: using ( TransactionScope objTransaccion = new TransactionScope ( TransactionScopeOption .Required)) ... objTransaccion.Complete(); I get the following error: System.Transactions.TransactionManagerCommunicationException: Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool. (Exception from HRESULT: 0x8004D024) I am trying to enable the DTC on Windows 2000 Server but the references seem to be to Windows 2003 Server. Any idea on how to do it on 2k Server TIA, Brad.- Tag: EXEC in WHERE clause
  - 6
    - recursive calculated measure I am trying to write a calculated member that is an expression of the following series: A(t) = A(t-1)*(1+R1) + a(t)*(1+R2) where A(t) represents the aggregate value of the measure and a(t) represents the value observed during the period t. R1, R2 and a(t) are all calculated members themselves that are basically the first level of calculation above my facts. At any point along my time dimension t, I will be running the calculation for either 3 months or 12 months. The code for my calculated member is as follows but it simply runs away and never completes: [Measures].[BigA] AS iif (([Measures].[BigA],[Dim Time].[Time]. currentmember . prevmember )= null ,[measures].[littlea],([Measures].[BigA][Dim Time].[Time]. currentmember . prevmember )*(1+[Measures].[R1])) + [measures].[littlea]*(1+[Measures].[R2]) Any suggestions Tag: EXEC in WHERE clause
  - 7
    - DataPort Wizard from PrimeWorks Hi, Just to say that I was using the Data Port Wizard to convert MDB to SDF and back, and it has worked perfectly! I highly recommend it to others that have the same need. Just make sure to be using SQL CE 3.1 Try a look at http://www.primeworks-mobile.com/ it's worth a visit! Tag: EXEC in WHERE clause
  - 8
    - searching for a word in a text file and retuning it using script taks in ssis does any one how to search for a word in a text file and return it back using the script task in ssis the file may contain data like this POSITION SMSMSS20051230000 S ,,751600 ,,20051110,,20051230,20051230 S ,,751600 ,,20051110,,20051230,20051230 S ,,751600 ,,20051110,,20051230,20051230 S ,,751600 ,,20051110,,20051230,20051230 S ,,751600 ,,20051110,,20051230,20051230 what i am looking for is to be able to parse and get the date which is present in the first line "POSITION SMSMSS20051230000" as "20051230" and then return that as a variable .. Thanks for any help in advance smathew Tag: EXEC in WHERE clause
  - 9
    - Is it possible to restore from a database backup without a transaction log backup? Ekrem Onsoy wrote: dvang wrote: I was actually attempting to do it via the SSMS by right-clicking the database, then clicking on restore, then pointing to the .bak file, then execute. I get an error when i do it this way. Any insights If it's a FULL backup, then go to Restore Database... (You can see if it's a FULL or not from the Type column in "Select the backup sets in restore" list) Ensure that in the Restore Database window, in the Options pane Recovery State "RESTORE WITH RECOVERY" is selected This is what i get when i do it via smss, it's looking for the tail log or something Restore failed for Server 'DK\VANG'. System.Data.SqlClient.SqlError: The tail of the log for the database "DK01" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log. (Microsoft.SqlServer.Smo) I forgot to mention that the database that i'm trying to restore back to has been changed (tables have been altered). the backup file was a backup of the database when it hadn't been altered yet. Could this be an issue I'm in a sense trying to restore an old backup to a newer updated database of the same. Even if this will not work, what about just restoring it to a whole new database (create a database from a restore backup ). I'll read up some more. Any knowledge insights is greatly appreciated! Tag: EXEC in WHERE clause
  - 10
    - Query to get rows which match with all given values Hi, May be you can try something like this: SELECT U .* FROM tblUsers As U JOIN ( SELECT FKIDUser FROM tblScores WHERE Score = 2 UNION SELECT FKIDUser FROM tblScores WHERE Score = 4 UNION SELECT FKIDUser FROM tblScores WHERE Score = 6 ) AS T ON U . UserID = T . FKIDUser Thanks & Regards, Kiran.Y Tag: EXEC in WHERE clause
  - 11
    - SQL server 2005 snapshort agent problem I have a SQL server 2005, and created a replication function. when I run the snapshort agent, I found the opration will run the sys.sp_MSsetup_partition_groups, but need a long time, and can't stop it, I don't know what is the problem about the snapshort agent, and sys.sp_MSsetup_partition_groups is running for what Tag: EXEC in WHERE clause
  - 12
    - Unable to connect to sqlserver 2000 from Sqlserver2005 Hi, iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Unable to connect to Sqlserver 2000 which is installed remotely ....Sqlserver2000 is dev edition.i cudnot find Sqlserver2000 instance when i try to search for Network database engine name ....... I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine Tag: EXEC in WHERE clause
  - 13
    - processing cube not pumping data You seem to have checked everything that I could see as causes for the problem. 10 M fact rows is not that much that will create problems for a standard server. It is also very hard to see why the named query will not execute without a filter clause. I have searched for file limits of the SSAS2005 data files but I have not found anything this far. What hardware are you using(32bit/64bit, no of CPU:s, RAM) . Are you using the standard or enterprise version of SSAS2005 SP1 Why are you not able to create a view of the three fact tables With that large data set a named query is not the best choice, for performance reasons. Any messages in the eventlog when you process without the filter clause Have you also started a trace with SQL server profiler when you process the cube Regards Thomas Ivarsson Tag: EXEC in WHERE clause
  - 14
    - Trouble Installing Reporting Add-In for Microsoft Visual Web Developer 2005 Express Hi Folks I've downloaded & installed Visual Web developer Express and SQL Server Express and now I'm trying to install the Reporting Add-In available here: http://msdn.microsoft.com/vstudio/express/downloads/default.aspx It downloads just fine and, just as the installation progress bar is almost done and the status text says 'Registering Product', I get the following error message: "There is a problem with this windows installer package. A program run as part of the setup did not finish as expected. Contact your support personell or package vendor" Running VWD shows the ReportViewer control now appears in the 'data' group. I can add it to a form, but I cannot create a new report, as clicking on 'Design a new report' under the ReportView Tasks popup menu does nothing. Any ideas, please Thanks Andrew Tag: EXEC in WHERE clause
  - 15
    - xquery query path without elements The Demographics xml data type column in AdventureWorks. Sales . Store contains the row sample below. How would I write the path for Demographics.query() to retun all rows with AnnualSales >=300000 I'm using variations of this statement but can't find an example of a path without elements. SELECT demographics . query ( 'declare namespace AWMI="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey"; / ' ) as Result FROM Sales . Store < StoreSurvey xmlns = " http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey " > < AnnualSales > 300000 </ AnnualSales > < AnnualRevenue > 30000 </ AnnualRevenue > < BankName > International Bank </ BankName > < BusinessType > BM </ BusinessType > < YearOpened > 1970 </ YearOpened > < Specialty > Road </ Specialty > < SquareFeet > 7000 </ SquareFeet > < Brands > AW </ Brands > < Internet > T1 </ Internet > < NumberEmployees > 2 </ NumberEmployees > </ StoreSurvey > Tag: EXEC in WHERE clause
  - 16
    - Hotfix for Bug # 473675 (SQL Server could not spawn process_loginread thread) Hi, I get " SQL Server could not spawn process_loginread thread." errors. This is related to a bug in SQL 2000 and there is a hotfix for SP3a. I am running SQL2000 with SP4. I checked the fix list of SP4 & this bug is not fixed in this SP4. Can I apply the hotfix to resolve this problem on my server tia. Tag: EXEC in WHERE clause
- Next
  - 1
    - Linkserver connection fails between SqlServer 2005 and Oracle 10g Hi, Jay87, try to use the sp_setnetname stotred procedure to link the name of your linked server to the correct name of your oracle server machine sp_setnetname @server = ' server ', @netname = ' network_name ' Tag: EXEC in WHERE clause
  - 2
    - OUTPUT - help with please @SQL is my stored procedure name @Param_List is the list of enumerated parameters SET @SQL = @SQL + IsNull ( @Param_List , '' ); EXECUTE sp_executesql @SQL ; Worked like a charm. Thanks! Sandy Tag: EXEC in WHERE clause
  - 3
    - problem with Stored procedure hi everyone... Iam new with stored procedure in Sql 2005 so iam facing a problem which i need to get the result of query to store in an sql output parameter here is my SP : ALTER PROCEDURE [dbo].[CheckUser] ( @Id nvarchar(50) , @Pass nvarchar(50) , @Exist int output , @Type char(1) output ) AS BEGIN SET NOCOUNT ON; -- Insert statements for procedure here declare @tt int declare @char char select @tt=count(*) from Users where Id=@Id and Password=@Pass select @char=users.Type from users where Id=@Id and password=@Pass set @Type=@char set @Exist=@tt END so i would to retrieve the results of the 2 queries & store them in @Exist & @Type.. how can i do that Tag: EXEC in WHERE clause
  - 4
    - Creating an Windows Rdl on the fly using .net programming You are welcome and I hope that the Report Build is what you are looking for. Tag: EXEC in WHERE clause
  - 5
    - XML columns failing to Replicate I case it has some effect on this issue, I should let you know that the tables I am seeing this issue with are linked with a logical relationship filter (sp_addmergefilter @filter_type = 2). I have not done any work to reproduce this problem in other tables that do not have this type of filter relationship. Tag: EXEC in WHERE clause
  - 6
    - distinct query for table containing records more than 69347 What would be the best way to avoid distinct clause in query to get the result.My Query looks like select distinct Col1 ,col2,col3,col4 from ABC where (1=1) group by Col1 ,col2,col3,col4 order by col1 ABC Contains records like Col1 col2 col3 col4 a 1 1 1 a 2 1 1 B 2 2 2 B 1 1 1 ; ; ; how is the performance of disticnt query on Number of Rows HOw can i Improve my query performance if want to use distinct in my query will adding indexes help to boost performance Thanks Tag: EXEC in WHERE clause
  - 7
    - Checking for records where One value is NOT in the other? I am trying to display results in which a value in my first result table is NOT contained in the second result table. Any idea on how to do this . SELECT CUSTOMERID, CUSTOMER FROM TABLE1 WHERE CUSTOMERID NOT IN TABLE2 Tag: EXEC in WHERE clause
  - 8
    - Property IsLocked is not available Works great... Except now I still can't log in with the sa account that I just unlocked from any machine. TITLE: Connect to Server ------------------------------ Cannot connect to ANGEL. ------------------------------ ADDITIONAL INFORMATION: Cannot open user default database. Login failed. Login failed for user 'sa'. (Microsoft SQL Server, Error: 4064) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Tag: EXEC in WHERE clause
  - 9
    - Store currency and volume in database We are creating an enterprise application for fuel, and I am fighting with my DBA about the proper way to store volume and currency in the database. We have 2 main arguments. The first argument is whether we should store costs in the database in $ and convert in the presentation layer, or to store the amount and currency in the database. We sell product from the US in dollar but depending on the customer we may invoice in Euro. Our second argument is the same, execept with volume and UOM. We often purchase product by BBL but sell/transfer by gallon, or Ton. please tell us the best practice for our d ilemma. Tag: EXEC in WHERE clause
  - 10
    - Deploy Reports via Visual Studio 2005 try opening a command window and running "tracert <reportserver ip>" this will show you how requests are being routed to your report server. If the ip address of the report server isn't the first on the list, you are using some kind of proxy or gateway to get to the report server. Tag: EXEC in WHERE clause
  - 11
    - Question on Row Count Transformation minority80 wrote: opss.... ya.... it's Row Number Transformation.. sorry for the mistake... thanks for the replies.... in this Row Number Transformation package, start number(seed) cannot be filled with expression... so can i say that this package can only be used to generate surrogate key if it's run only once thanks again... Right click on the transformation and select properties. In that window you will find the "Expressions" box. Expand that and go from there. Tag: EXEC in WHERE clause
  - 12
    - Installing Sql Server 2005 Enterprise on Windows XP pro I am trying to install 2005 sql server enterprise edition on windows xp pro, When I get to the part where you pick which components to add, they are all grayed out except for workstation components and books. What did I do wrong Tag: EXEC in WHERE clause
  - 13
    - Need hand holding Hi - Is there a resource I can go to that lists people who I pay to talk me through stuff like getting SQL Server Express installed, get some sample data input and then get that data into Excel I just cannot seem to get any help that works for me to learn SQL Server; the books are obtuse, the online help too indirect. Once I get something working I hope to enhance it on my own, but I have been stuck at the start for a very long time. There is stuff for me to do that is not getting done. Doug Tag: EXEC in WHERE clause
  - 14
    - When to use a Nested Table? Why would someone choose to model a problem with a case and nested table versus just using a case tables with multiple rows For example, a simple customer and product scenario where you could say: Mining Model DT_CustProd ( [Id] , [Gender] , [Age] [Products] Predict ( [ProductName] , [Quantity] ) ) But you could also model as: Mining Model DT_CustProd ( [Id] , [Gender] , [Age] [ProductName] Predict, [Quantity] Predict ) and just insert multiple rows per Id/Gender/Age Is there any rule of thumb to use here when deciding to model with a nested table I understand that a nested table essentially pivots the data ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=408840&SiteID=1 ) and the data becomes an attribute, but how do you know if you want that, or you want the data as a value of an attribute Tag: EXEC in WHERE clause
  - 15
    - SQL Server 2005 Install fails on Vista I am encountering the same exact issue. Can't uninstall or re-install as the same message states that it is part of OS. Need to install SQL 2005 standard for demo purposes. SQL Express alone fails also. I have tried to work around this for an entire day, but nothing will allow SQL 2005 to detect the .net 2.0 framework. Tag: EXEC in WHERE clause
  - 16
    - error Are you using any UNION on your query.. Tag: EXEC in WHERE clause

valentin tihomirov

I wanted to have something like

SELECT * FROM refs1 WHERE (EXEC ref_id) = this.id

Should I turn the SP into a function

Top

Re: EXEC in WHERE clause

Arnie Rowland

A function 'might' work -depending on the sode in the stored procedure.

Top