Viewing 15 posts - 6,856 through 6,870 (of 8,753 total)
punnaiah.pendyala (10/5/2014)
HiUse this
select min(wan),max(wan),subscriber from retail group by subscriber having count(*)>1
Will not work if the earlier wan is higher than the later wan as noted in the previous posts.
😎
October 5, 2014 at 11:23 pm
The assumption made in the code was that the WAN values would be in an increasing order, as that's correct according to the last sample, one has to add a...
October 5, 2014 at 10:10 pm
Quick thought, if the table/object is not in either the user's default schema or in the dbo schema, the reference to the table must be fully schema qualified
😎
(Changes in bold)
DECLARE...
October 5, 2014 at 2:08 pm
Quick thought, the output parameter must be declared with the output keyword
😎
ALTER PROCEDURE [dbo].[spTelling]
(
@scannummer Nvarchar(13)-- input only
@myOutputParam INT OUTPUT -- output parameter
)
AS
BEGIN
Then the keyword is used...
October 5, 2014 at 2:03 pm
TomThomson (9/30/2014)
Eirikur Eiriksson (9/30/2014)
October 5, 2014 at 11:29 am
ramana3327 (10/5/2014)
It is showing try_parse is not a recognized built-in function
What is the output of
SELECT @@VERSION
on your system?
😎
October 5, 2014 at 11:25 am
SQL-DBA-01 (10/5/2014)
WARNING: Failed to load the 'SQLAS' extension: An exception occurred in SMO while trying to manage a service. --> Failed to retrieve data for this request. --> Invalid class
This...
October 5, 2014 at 9:51 am
challakarthik (10/5/2014)
I have a scenario like ........I have 6 flat files(Country1,Country2,Country3,.......Country6) in the source and i need to fetch the records of Country1 flat file to Country1 table in...
October 5, 2014 at 3:33 am
armm1388 (10/4/2014)
I created a database in sqlserver 2005 . now I wants to attach it in sqlserver 2008. But I would be face to error:
Failed to retrieve data for this...
October 4, 2014 at 11:24 pm
desperadomar (9/28/2014)
Just a quick question.
You used the MAX(wan)<>MIN(Wan) instead of COUNT(wan)>1
When I checked the estimated execution plan there is one less operator(compute scalar) in the first operation...
October 4, 2014 at 11:15 pm
Steve Jones - SSC Editor (10/4/2014)
Eirikur Eiriksson (10/4/2014)
October 4, 2014 at 4:56 pm
Luis Cazares (9/19/2014)
October 4, 2014 at 4:00 pm
...or from a command promt
net stop "instance name"
😎
October 4, 2014 at 3:54 pm
Viewing 15 posts - 6,856 through 6,870 (of 8,753 total)