SQL Server database programming

Hi, I am trying to combine information from two or more records into one and I am completely stuck on a solution for my problem so I hope there is someone out there who can help me. My table looks like this: ...

Hi all. We have a question regarding rounding of values. From Books online: SELECT ROUND(123.4545, 2); Results in 123.4500 Why not 123.46 In 123.4545 the last digit(5) pushes the 4 up to 5 and that again pushes the ...

I am using sp_send_dbmail to send emails from SQL Server 2005. The problem is that if I have 2 recipients, then each recipient gets the email twice. If I have 3 recipients, then each recipient gets the email 3 times. And so on. ...

When I tried to send mail using xp_sendmail on a PC which is on network but not a part of a domain I get the following error: Server: Msg 17985, Level 16, State 1, Line 0 xp_sendmail: Procedure expects parameter @user, which was not supplied. ...

Hello there I have two servers connected by linked server. I'm trying to insert data on server2 from server1 Here is what i'm trying to run: INSERT SVR2.db.dbo.Table1(Field1, Field2, Field3) VALUES(1,2,3) ...

Why this query declare @sku char(20) set @sku = '02113' select * from vamcpd...icitem where citemno = @sku is much slower then select * from vamcpd...icitem where citemno = '02113' Thanks ...

Hello there I need do build a script that will use more then one server. How can i do it with SQLCMD? ...

CREATE PROC New_Populate AS INSERT INTO tblSIPLinesSiteInputs (InputID, SiteID, InputValue) SELECT GetInputs.InputID, 1, IsNull(GetInputs.defaultValue,0)     FROM         (SELECT tblAllInputs.InputType, tblAllInputs.InputID, tblAllInputs.ReleaseID          FROM tblAllInputs ...