Viewing 15 posts - 3,331 through 3,345 (of 4,820 total)
Eirikur Eiriksson (8/3/2015)
Quick suggestion, use sys.dm_exec_describe_first_result_set or sys.dm_exec_describe_first_result_set_for_object, to get the structure of the output of the stored procedure.😎
According to MS doc, that applies only to SQL 2014 and...
August 4, 2015 at 8:34 am
sharonsql2013 (7/29/2015)
Since there are lot of values , I just want to bring in alternate rows but...
August 3, 2015 at 9:58 am
You might well find that the data is not actually correctly formatted for all records. If a humang being was ever editing the file, you might well have...
August 3, 2015 at 8:56 am
ben.brugman (8/3/2015)
August 3, 2015 at 7:29 am
You can't run a DTS package unless SSIS is installed and running on the machine in question.
August 3, 2015 at 7:11 am
I don't see any obvious reason why you couldn't just do this in an SSIS package instead. SSIS can avoid the extra complexity of having to combine your...
August 3, 2015 at 6:41 am
SQL_Kills (7/30/2015)
I want to get the latest comment for each id based on the maximum createdDate and not sure how to do this, tried to do Max but it...
July 31, 2015 at 1:02 pm
PJ_SQL (7/31/2015)
I get this error :Invalid column name 'RN'.
Did you use ALL of Jason's query, including the part that has WITH at the beginning? That part is called...
July 31, 2015 at 11:19 am
Phil Parkin (7/31/2015)
Phases of the moon missing?? :w00t:
Yeah, they went missing along with that blue moon we just had... :w00t:
July 31, 2015 at 10:08 am
paul.s.lach (7/31/2015)
INSERT INTO [#gpa]
VALUES (1,'math',3),
(1,'eng',4),
...
July 31, 2015 at 9:59 am
Naina_11 (7/27/2015)
it's done. I added a Level column with 0 and 1 and ordered accordingly.Thanks
Another alternative:
DECLARE @testing AS TABLE (
DepDate datetime,
val int
);
INSERT INTO @testing VALUES ('2014-01-10 00:00:00.000', 1);
INSERT INTO @testing...
July 31, 2015 at 9:07 am
Robert klimes (7/30/2015)
Even if supplied solution did not give desired results, they did give me different ways of looking at problems and...
July 30, 2015 at 2:30 pm
Robert klimes (7/29/2015)
First, is the right answer 4.3333 ? I changed the data type in your table to decimal(5, 4), as the float data type would be unable...
July 30, 2015 at 6:21 am
Robert klimes (7/29/2015)
July 29, 2015 at 2:55 pm
I've updated my last posted query with Jason's update to the FOR XML PATH portion. FYI...
July 29, 2015 at 1:17 pm
Viewing 15 posts - 3,331 through 3,345 (of 4,820 total)