Viewing 15 posts - 6,916 through 6,930 (of 13,876 total)
Anandkumar-SQL_Developer (7/21/2016)
Actually This is an interview question.
Really? Then unless your answer is along the lines of
"This cannot be done, unless a column exists on which to order, because rows in...
July 21, 2016 at 7:37 am
I also taken you literally and assumed that non-zero can be a negative rather than just greater than zero.
Good catch, thanks.
July 21, 2016 at 6:32 am
Here is a modified version.
IF OBJECT_ID('tempdb..#First_nonzero', 'U') IS NOT NULL
DROP TABLE #First_nonzero;
CREATE TABLE #First_nonzero
(
Counter INT IDENTITY(1, 1)
...
July 21, 2016 at 5:46 am
Anandkumar-SQL_Developer (7/21/2016)
Hi Friends ,input code :
CREATE TABLE #First_nonzero
(
value int
)
GO
INSERT INTO #First_nonzero VALUES
(0),
(0),
(0),
(0),
(1),
(2),
(0),
(3),
(0)
Expected_output :
1
2
0
3
0
please some one suggest me how can i do this ..?
Regardless of...
July 21, 2016 at 5:36 am
Yet another way, using DelimitedSplit8k[/url].
IF OBJECT_ID('tempdb..#test', 'U') IS NOT NULL
DROP TABLE #test;
CREATE TABLE #test
(
id INT IDENTITY(1, 1)
...
July 20, 2016 at 10:35 am
Lynn Pettis (7/20/2016)
I just watch them to escape the real world for a while, and sometimes it is nice to do it in the theater.
The word 'innuendo' comes to mind,...
July 20, 2016 at 10:02 am
lsalih (7/19/2016)
July 19, 2016 at 7:50 pm
SQL_Surfer (7/19/2016)
July 19, 2016 at 4:21 pm
Jeff Moden (7/18/2016)
lsalih (7/18/2016)
I am placing it in a package for others to use, not for my own use. Some prefer to run a package than running the script....
July 19, 2016 at 5:55 am
... for some reason the code is not doing restore as it should.
You need to provide better detail than this.
Is it doing the restore in a way that it...
July 18, 2016 at 11:41 am
mbrady5 (7/18/2016)
The view seems to be the issue. When taking the SQL from the view, it imports in less than 10 seconds using the SQL import wizard. When...
July 18, 2016 at 11:10 am
twin.devil (7/15/2016)
Phil Parkin (7/15/2016)
twin.devil (7/15/2016)
If you want to do in SSIS then...
July 15, 2016 at 7:54 am
Phil, you missed the Date column from the grouping ...
Thanks for picking that up. It was untested, pre-coffee, and it's a Friday. A dire combination, when it comes to my...
July 15, 2016 at 7:51 am
dramaqueen (7/15/2016)
So to make it clear I want to query the main table based on the temp table I have created to show more detail.
No need for a temp table....
July 15, 2016 at 6:35 am
kewlguy13 (7/15/2016)
I am struck with Junk dimension.
My target table structure is as below.
Junk_Dim
----------
JunkID -- PK
JunkTypeID -- PK
JunkCode
JunkName
JunkTypeName
Below values need to be propagated to the Junk Dimesnion.
SubscriptionStatusSubscriptionStatus
4Contract End
3Contract Cancelled
1Contract...
July 15, 2016 at 6:23 am
Viewing 15 posts - 6,916 through 6,930 (of 13,876 total)