Viewing 15 posts - 91 through 105 (of 14,953 total)
You could open the RDL in an XML editor (Notepad++ works great for that), and use search-and-replace in there.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 31, 2016 at 12:52 pm
Why depend on two asynchronous processes?
Can the process that generates the files log when it's done, and then the process that uses the file checks that log? Make it...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 31, 2016 at 10:57 am
I've seen plenty of BS in databases, but I've never seen anyone advertise for it in a job description...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 31, 2016 at 10:52 am
I'm a little confused on your requirements.
Is this correct:
LOT must be more recent than 90 days in past
Most recent SHIPMENT must be earlier than 90 days in past
Is that what...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 31, 2016 at 9:48 am
Any reason to not use UNPIVOT for this?
SELECT
Batch,
Account,
Item,
Ref,
PageNo,
ItemNo
FROM
(SELECT
*
FROM
sktrans) AS S
UNPIVOT ( ItemNo FOR ItemCol IN (ItemNo1, ItemNo2, ItemNo3, ItemNo4, ItemNo5) ) AS UP;
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 31, 2016 at 9:44 am
Check with Microsoft on that. They have phone and online support for licensing questions. Answers you get from them are official. Anything you get from us is...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 31, 2016 at 9:31 am
Goes right along with new words for old concepts. "Cloud" = "client-server", and so on.
We have words with multiple meanings ("DBA" is right up there for unlimited ambiguity), and...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 31, 2016 at 8:52 am
Try...Catch can do what you need.
Example:
CREATE PROC dbo.Proc2 (@Input_in VARCHAR(100))
AS
SET NOCOUNT ON;
RAISERROR('Proc2 failed', 16, 1);
SELECT
@Input_in;
GO
CREATE PROC dbo.Proc1
AS
SET NOCOUNT ON;
BEGIN TRY;
EXEC dbo.Proc2 @Input_in = 'Hello world';
END TRY
BEGIN CATCH
SELECT
ERROR_MESSAGE();
END CATCH;
GO
EXEC dbo.Proc1;
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 31, 2016 at 8:43 am
David.Poole (5/27/2016)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 31, 2016 at 8:37 am
In the scope of your Exec statement, "exec (@qry)", @value4 is not declared. It's declared outside of that.
Take a look at sp_executesql, instead of exec, for running dynamic SQL...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 31, 2016 at 8:26 am
...NT Service\MSSQL$SQLSERVER2014 with the currently configured password due to the following error:
This user isn't allowed to sign in to this computer.
The problem isn't your login. It's the service...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 27, 2016 at 11:35 am
I don't think you can batch-modify maintenance plans.
That's one of the advantages of writing your own, using SSIS and T-SQL, instead of using the built-in tools. When you write...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 27, 2016 at 11:20 am
Customize the sub-query Where clause to suit your needs, of course.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 27, 2016 at 11:16 am
Recombinant (5/27/2016)
GSquared (5/27/2016)
Don't leave because you think something else might be better. Leave because you know it will be better.
Completely agree but most people leave because they know that...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 27, 2016 at 11:15 am
martin.whitton (5/27/2016)
I can't imagine any situation where it would be good practice to do this (although I understand how it could be tempting).
Does anyone have an example of...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 27, 2016 at 11:09 am
Viewing 15 posts - 91 through 105 (of 14,953 total)