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)