You searched for the word(s): userid:644820

More Search Options

RSS Available

• Re: 1 To Many Relations

  I assume that you are trying to insert a record into tblSource1. After that, you are trying to insert the SourceID i.e. RefID of tblSourceID into tblSource2 and tblSource3. One more assumption is that RefID is identity column. First insert the record into tblSource1 Then use IDENT_CURRENT ( 'tblSource1' ) to get the latest ID of tblSource1 and explicitly insert this value into tblSource2 and tblSource3. Your stored procedure can be something like the following: Insert into tblSource1(faq

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vijayakrishna on 10/9/2008

• Re: Matching each value out of multiple values to single column value

  I verified the function ufn_ALINES and it is working fine. To see it as working, run the following query in your SQL Server Management Studio. select * from dbo.ufn_ALINES('Builder Owner Agent', ' ' ) And at the same time you can run your stored procedure in the same place something like using the following dbo.flatsearch '1BHK','First Floor', 'unit,500,'Andheri',1000000,2000000,2,2,'feature1,feature2,feature3','agent builder' If user does

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vijayakrishna on 10/7/2008

• Re: Matching each value out of multiple values to single column value

  I have changed the inner join in Naom's query to Left Outer Join, try the following. I am not sure whether your column name is Poste_by or postedby. However I used postedby as you used it in the select query. SSMS means SQL Server Management Studio i.e. where you are creating your stored procedure. SELECT ptype, rate, location,area,areaunit, bedroom,features,bathroom,moreinfo,tel,mobile,email,postedby FROM sellproperty INNER JOIN dbo.FN_SPLIT(@featuresofflat) r ON sellproperty.features LIKE

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vijayakrishna on 10/7/2008

• Re: Can this be done using Response Object ??

  Google for RegisterClientScriptBlock and RegisterStartupScript

  Posted to Client Side Web Development (Forum) by vijayakrishna on 10/4/2008

• Re: File.delete() isnt deleting the file after it's downloaded....help please

  Response.TransmitFile(file.FullName) just sends a copy of your file to the user, it is not going to delete it. If it is so, you need not require the File.Delete() statement.

  Posted to Getting Started (Forum) by vijayakrishna on 10/2/2008

• Re: File.delete() isnt deleting the file after it's downloaded....help please

  [quote user="Mazenx"]I read somewhere that i cant download the file unless it's in the website directory [/quote] The above is wrong. To write a file to a folder permissions are required. In fact, you yourself accessing the files from C:\Uploads folder. So, try to transmit that file itself. There is no necessity of copying and removing it.

  Posted to Getting Started (Forum) by vijayakrishna on 10/2/2008

• Re: Convert Stored Procedure to T-SQL

  Your query can be something like this strSQL += "IF NOT EXISTS (SELECT UserID, PhoneID from Hyperion_Workflow WHERE (UserID=" + txtAssignedUser.Text + ") and (PhoneID=" + txtPhoneID.Text + "))" ; strSQL += " INSERT INTO Hyperion_Workflow(UserID, PhoneID, DateAssigned) VALUES (" + txtAssignedUser.Text + "," + txtPhoneID.Text + "," + "GetDate())" ; If the UserID and PhoneID are not numeric then make sure to enclose them with single

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vijayakrishna on 10/2/2008

• Re: File.delete() isnt deleting the file after it's downloaded....help please

  I achieved this in some different way. protected void Page_Load( object sender, EventArgs e) { string path1 = Server.MapPath(@ "images\Thirsty Crow.wav" ); FileInfo file = new FileInfo(path1); Response.ClearContent(); Response.AddHeader( "Content-Disposition" , "attachment; filename=Thirsty Crow.wav" ); Response.AddHeader( "Content-Length" , file.Length.ToString()); Response.ContentType = "application/octet-stream" ; FileStream fs = new FileStream

  Posted to Getting Started (Forum) by vijayakrishna on 10/2/2008

• Re: Convert Stored Procedure to T-SQL

  The following is working at my end on SQL Server 2005 protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strSQL = ""; strSQL += " IF NOT EXISTS ( SELECT [Name] FROM test1 WHERE [Name] = 'Paruchuri' )"; strSQL += " INSERT INTO test1([Name]) VALUES ( 'Paruchuri' )"; SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["vijayConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vijayakrishna on 10/2/2008

• Re: Convert Stored Procedure to T-SQL

  Try this IF NOT EXISTS ( SELECT UserID, PhoneID from Hyperion_Workflow Where (UserID=@assignedUser) and (PhoneID=@assignedPhoneID)) INSERT INTO Hyperion_Workflow(UserID,PhoneID,DateAssigned) VALUES (@assignedUser,@assignedPhoneID, GetDate ( ))

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by vijayakrishna on 10/2/2008