Viewing 15 posts - 1 through 15 (of 40 total)
Thank you all for your respose. It relieved me.:cool:
Currently we are using hosting dot com service which has Windows Server 2008 R2. 24GB Ram.
What should be the server configuration in...
June 15, 2012 at 3:43 am
Can we have more than one windows user configured as proxy? How?
Actually, I have two Application servers using same database server. Both of them have two seperate users, which i...
December 22, 2011 at 3:26 am
Thanks a lot for the awesome logic...
Some problem with the logic, when the data is like this:
drop table #test1
drop table #Master
select * into #test1 from (
select 1 ID, 'Dog'...
June 21, 2011 at 8:53 am
Two steps involved in this:
1. Convert DT_NTEXT to DT_WSTR
2. Convert DT_WSTR to DT_STR
Thats it.
May 1, 2011 at 7:58 am
GilaMonster (8/11/2010)
Post the view definition?
CREATE VIEW [View1]
AS
SELECT ROW_NUMBER() OVER (ORDER BY VERSIONID) AS ROW_NUMBER,* FROM
(SELECT Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8, [value]
from Table1
WHERE PARAMETERNAME in (SELECT convert(varchar(max),decryptbypassphrase('SKey',PARAMETERNAME))...
August 11, 2010 at 3:04 am
Guys thanks for your concern.
Grant Fritchey (8/10/2010)
What business need is being satisfied by pulling all the data? .why are you querying everything?
We have created a view using this Table (lets...
August 11, 2010 at 12:33 am
A simple script to get comma seperated result.
declare @empids varchar(max);
set @empids = '';
select @empids = convert(varchar, empid) + ', ' + @empids
FROM employee
select @empids
--output
--,...
December 30, 2009 at 6:48 am
Paul White (9/5/2009)
A more usual solution would be to update the state populations individually. The country population would then be auto-magically updated from the total for the states added...
September 8, 2009 at 7:58 am
m_goulay (9/7/2009)
Subquery returned more than 1 value.
and BranchID=(Select BranchID from Damagedcategory where DamagedID in
This is where your query might be returning more than one value.
try changing it something...
September 7, 2009 at 6:24 am
Have a look at this url
check the code below:
----------------------------------------
create proc sp_test123
as
begin
SET NOCOUNT ON;
create table #temp ( testName varchar(50))
insert into #temp values ( 'abc'); insert into #temp values ( 'abc1');
insert into...
September 7, 2009 at 6:03 am
claudiosil100 (9/7/2009)
I can't because the output of SP1 it's an XML
In the 1st SP. Make the return type as varchar or something..
refer below example
--creating some temp table for reference
create table...
September 7, 2009 at 5:43 am
claudiosil100 (9/7/2009)
I need the result of 1st SP to work into 2nd.
In the 1st SP. Make the return type as varchar or something..
refer below example
--creating some temp table for...
September 7, 2009 at 5:11 am
Jeff Moden (9/5/2009)[/b
Yes... you shouldn't use a stored procedure to format data for a GUI or reporting system. That also includes many cross-tabs and pivots (not to be confused...
September 5, 2009 at 11:16 am
Hi,
It is a good practice to use stored procedure, even always.
Stored procedures offer several distinct advantages over embedding queries in your Graphical User Interface (GUI). Your first thought may be:...
September 5, 2009 at 2:51 am
Jeff Moden (9/5/2009)
BWAA-HAAA!!! Considering that you're the one asking the question, you're not the one to make such a judgment. Welcome ALL answers because even the wrong ones...
September 5, 2009 at 2:13 am
Viewing 15 posts - 1 through 15 (of 40 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy