Viewing 15 posts - 3,436 through 3,450 (of 8,761 total)
Good stuff! Here is a quick example which should get you passed this hurdle
😎
USE TEEST;
GO
SET NOCOUNT ON;
--
IF OBJECT_ID(N'dbo.request_log') IS NOT NULL DROP TABLE dbo.request_log;
CREATE TABLE dbo.request_log(
[id] [int] IDENTITY(1,1) NOT NULL,
[request_id]...
July 21, 2016 at 6:36 am
Quick question out of curiosity, why would you move this into the SSIS dataflow when it will most likely be both simpler and faster when done at the SQL Server...
July 21, 2016 at 5:33 am
Quick question, if the date is earlier than the 1st of April then should it return the year - 2 or -3?, i.e.
a) 2016-01-01 ==> 2014-04-01 (21 months)
...
July 21, 2016 at 5:01 am
zenm (7/21/2016)
July 21, 2016 at 4:50 am
Updating from a column value is equally simple, here is a quick sample, results are equal to the previous method.
😎
USE TEEST;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.TBL_XML_MODIFICATION') IS NOT NULL DROP TABLE dbo.TBL_XML_MODIFICATION;
CREATE...
July 21, 2016 at 4:05 am
BrainDonor (7/21/2016)
Does anybody know who the "Hotshot SQL Guru" is?https://tmblr.co/Z14uHt29WaOS7
https://tmblr.co/Z14uHt29Ww0kS
https://tmblr.co/Z14uHt29ZP3zF
Somebody wasn't impressed.
One of the certainties of live: "There will always be wannabes"
😎
July 21, 2016 at 3:10 am
Quick example, should be enough to get you passed this hurdle
😎
USE TEEST;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.TBL_XML_MODIFICATION') IS NOT NULL DROP TABLE dbo.TBL_XML_MODIFICATION;
CREATE TABLE dbo.TBL_XML_MODIFICATION
(
XM_ID INT...
July 21, 2016 at 2:51 am
ocean3300 (7/20/2016)
SELECT MIN(Date),...
July 21, 2016 at 12:54 am
Turning the Azure SQL Databases on and off is not an option but you can throttle it down to a basic tier when not using it. The on/off option applies...
July 20, 2016 at 11:04 pm
I have seen many of such solutions fail, OP, do you want to answer the questions I have asked or even better improve the scheme as suggested?
😎
July 20, 2016 at 1:50 pm
Quick thought, foreign key constraint to the table from a pseudo table on a column with a default value constraint will do the trick.
😎
Edit: Typo
July 20, 2016 at 1:18 pm
Quick suggestion, based on your questions I suggest you research those topics on BOL and come back if you have any further questions.
😎
July 20, 2016 at 1:36 am
There are quite few options here and each has it's pros and cons but to recommend any of those I would like to have more information as what may be...
July 20, 2016 at 12:37 am
Quick suggestion, add max on the values and group by the ID.
😎
July 19, 2016 at 5:09 am
mxy (7/18/2016)
Hello all,i would like to know if there is a way to display results in random order for each execution.
Out of curiosity, why do you want to do...
July 18, 2016 at 11:52 pm
Viewing 15 posts - 3,436 through 3,450 (of 8,761 total)