Search Results

Search found 1086 results on 44 pages for 'sp gounder'.

Page 2/44 | < Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• Avoid MySQL multi-results from SP with Execute

  - by hhyhbpen

  Hi, i have an SP like BEGIN DECLARE ... CREATE TEMPORARY TABLE tmptbl_found (...); PREPARE find FROM" INSERT INTO tmptbl_found (SELECT userid FROM ( SELECT userid FROM Soul WHERE .?.?. ORDER BY .?.?. ) AS left_tbl LEFT JOIN Contact …

  Read the article

• How to configure ADFS 2.0 as SP and CA SiteMinder as IdP

  - by Pravinmenghani

  Hi, We want to configure ADFS 2.0 as SP and CA SiteMinder as IdP using SAML 2.0. In ADFS 2.0 we have a test application which is deployed using WIF. We have configured both the things correctly. However, while testing the federation it gives 2 options of selecting the Identity provider correctly. However, after we enter the credentials we get…

  Read the article

• Row as XML in SP

  - by user171523

  From SP i need to get a row as as XML (Includeing all fileds.) Is there any way we can get like below. Declare @xmlMsg varchar(4000) select * into #tempTable from dbo.order for xml raw select @xmlMsg = 1 from #tempTable print '@xmlMsg' + @xmlMsg Row i would like to get it as XML output.

  Read the article

• how to return comma seperated values in oracle SP

  - by john

  If I have a simple query like: OPEN cursor FOR SELECT USER_ID FROM USER_TABLE WHERE USER_ID = V_SOME_USER; this will return records in different rows but how can I return the rows in the following format: 'userid1', 'userid2', 'userid3'.....'useridN' I want to do this because I want to send this off as a parameter to another stored…

  Read the article

• does it makes sense to do SP for simple queries like select * from users

  - by Omu

  is it going to be faster if instead of doing select * from users where id = 1 or delete from users where id = 1 or select count(*) from users I would create a SP for it ?

  Read the article

• Fed Authentication Methods in OIF / IdP

  - by Damien Carru

  This article is a continuation of my previous entry where I explained how OIF/IdP leverages OAM to authenticate users at runtime: OIF/IdP internally forwards the user to OAM and indicates which Authentication Scheme should be used to challenge the user if needed OAM determine if the user should be challenged (user already…

  Read the article

• Cross-database transactions from one SP

  - by Michael Bray

  I need to update multiple databases with a few simple SQL statement. The databases are configurared in SQL using 'Linked Servers', and the SQL versions are mixed (SQL 2008, SQL 2005, and SQL 2000). I intend to write a stored procedure in one of the databases, but I would like to do so using a transaction to make sure that each…

  Read the article

• .NET Data Adapter Timeout SP Issue

  - by A-B

  We have a SQL Server stored procedure that runs fine in SQL Manager directly, does a rather large calculation but only takes 50-10 seconds max to run. However when we call this from the .NET app via a data adapter it times out. The timeout however happens before the timeout period should, we set it to 60 seconds and it still…

  Read the article

• jQuery AJAX & Multiple sp Result Sets

  - by Kevin

  Is it possible to use a stored procedure that returns multiple result sets in json format and process them as part of one request using ajax calls in jquery? In other words, I have a stored procedure that returns several result sets that are to be used with a series of select boxes that are all being filtered by the same…

  Read the article

• Execute SQL SP in Excel VBA

  - by TheOCD

  HI I am having problem with getting all the columns back when i execute following code in excel vba. I only get 6 out of 23 columns back. Connection, command etc works fine (i can see exec command in the SQL Profiler), data headers are created for all 23 columns but i only get data for 6 column. Side Note: it's not…

  Read the article

• SP Gridview link button column not working

  - by Dilse Naaz

  Hi I have one sharepoint custom page application which is rendering from a user control. In the user control page, i had used SPGridview for displaying data. My first column is Title Column (link button column), when the user click on the link, then one popup window will open with corresponding data. But the problem…

  Read the article

• Clear formatting in SP's PublishingWebControl RichHtmlField

  - by Scozzard

  Hi there, Is there a configurable way to include a "clean formatting" feature in Sharepoint's PublishingWebControls RichHtmlField? For example, if content is copied and pasted from Microsoft Word, there is a selectable option to remove all formatting of the pasted content or the content is stripped on the paste…

  Read the article

• Migrating schema and SP from informix to mysql

  - by zombiegx

  We need to redo a database in MySQL that has been already done on Informix, is there a way to migrate not only the schema, but the stored procedures as well? Thanks. We have a client whom we built a web application that uses an Informix database. Now the client wants to be able to implement the same software…

  Read the article

• Create view or SP, only if the DB contains a pattern

  - by Randall Salas

  Hi all: I am working on a script, that needs to be run in many different SQL servers. Some of them, shared the same structure, in other words, they are identical, but the filegroups and the DB names are different. This is because is one per client. Anyway, I would like when running a script, If I chose the…

  Read the article

• Cleaning up a SQL SP with Regex

  - by Douglas Osborne

  1) If I am running a find and replace in SQL 2005 - what would be the regular expression to find tab and space sequences ( or space and tab sequences ) and replace them with just tab? 2) If I have a line which begins with a space - is there a regular expression to convert that leading space to a tab? 3)…

  Read the article

• Getting the rows cell to line up with parameters in a sp c# winform

  - by Yaron Buki

  I am using a datagridview on a win app designed in c#2010 express. In the _row leave event of my datagrid I would like to use the TableAdapter.usp_insert() that I created. But how does one match up the data in the cells of the datagridview row to the parameters in the stored procedure. Thanks in advance…

  Read the article

• Passing multiple parameters of same column to SQL Server select SP

  - by Bill

  I have a string value in the web.config — for example 2 guids seperated by a ",". I need to query the database dynamically (i.e i have no idea how many values could be seperated by a comma in the web.config) and run a select statement on the table passing these values and getting all that is relevant for…

  Read the article

• Selecting previous and next row using sp

  - by davor

  I want to select previous and next row from table based on current id. I send current id to stored procedure and use this query: -- previous select top 1 id from table where id < @currentId order by id desc -- next select top 1 id from table where id < @currentId order by id asc The problem is…

  Read the article

• Why does a bash-zenity script has that title on Unity Panel and that icon on Unity Launcher?

  - by Sadi

  I have this small bash script which helps use Infinality font rendering options via a more user-friendly Zenity window. But whenever I launch it I have this "Color Picker" title on Unity Panel together with the icon assigned for "Color Picker" utility. I wonder why and how this is happening and how I…

  Read the article

• Thread to receive the messages from serial port is not working using c#

  - by karthik

  I am using Serial port to receive the messages. The below function is running in a thread. When i debug i find that the thread is running properly. But "if (sp.IsOpen)" is always false, due to which the code is not executing inside the IF condition at all. It says the Port is closed. I will be having…

  Read the article

• assembly of pdp-11(simulator)

  - by lego69

  I have this code on pdp-11 tks = 177560 tkb = 177562 tps = 177564 tpb = 177566 lcs = 177546 . = torg + 2000 main: mov #main, sp mov #kb_int, @#60 mov #200, @#62 mov #101, @#tks mov #clock, @#100 mov #300, @#102 mov #100, @#lcs loop: mov @#tks,r2 …

  Read the article

• SerialPort not taking input. It throws it back at me!

  - by Mashew

  When I try to write an AT command to my GSM modem, it does not seem to take the command. I have used PuTTY to check that the command words, it does. I have checked to see if the port is opening, it does. What could I possibly be doing wrong? NOTE: The "lol" part is for debugging purposes. ;3…

  Read the article

• [C#] SerialPort not taking input. It throws it back at me!

  - by Mashew

  When I try to write an AT command to my GSM modem, it does not seem to take the command. I have used PuTTY to check that the command words, it does. I have checked to see if the port is opening, it does. What could I possibly be doing wrong? NOTE: The "lol" part is for debugging purposes. ;3…

  Read the article

• Sun T5120: Memory issue with 8GB DIMMs, "Unsupported memory configuration"

  - by watain

  I'm trying to upgrade RAM in a Sun T5120 server, replacing 2GB (Sun P/N: 501-7953-01) with 8GB DIMMs (Sun P/N: 511-1262-01). When bringing up the host system, I get the following errors on the ILOM: -> show faulty Target | Property | Value …

  Read the article

• Why does Python's math.factorial not play nice with threads?

  - by W1N9Zr0

  Why does math.factorial act so weird in a thread? Here is an example, it creates three threads: thread that just sleeps for a while thread that increments an int for a while thread that does math.factorial on a large number. It calls start on the threads, then join with a timeout The sleep…

  Read the article

< Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >