Viewing 15 posts - 3,961 through 3,975 (of 8,731 total)
Brandie Tarvin (10/27/2015)
We have the URLDefense ProofPoint software to prevent bad URL links. But when the site goes down, so does our ability to navigate to the sites in the...
October 27, 2015 at 7:32 am
Grant Fritchey (10/27/2015)
October 27, 2015 at 7:29 am
crookj (10/26/2015)
whereisSQL? (10/26/2015)
Ed Wagner (10/26/2015)
DonlSimpson (10/26/2015)
Ed Wagner (10/26/2015)
eccentricDBA (10/26/2015)
Luis Cazares (10/23/2015)
happygeek (10/23/2015)
SpicesGirls
Pop
Coke
Cartel
Tunnel
Smuggle
Snuggle
Struggle
October 26, 2015 at 1:50 pm
Would this produce the correct behavior?
CREATE TABLE EDI_data_proc_log(
ID int IDENTITY(1,1),
comment VARCHAR(3000),
time_recorded DATETIME DEFAULT GETDATE(),
run_by varchar(100),
duration int );
GO
CREATE TRIGGER TI_EDI_data_proc_log ON EDI_data_proc_log
INSTEAD OF INSERT
AS
INSERT INTO EDI_data_proc_log(
...
October 26, 2015 at 1:36 pm
Lynn Pettis (10/26/2015)
Does this work (can't test it, on a flight to Seattle)?
declare @startdate datetime = "20151126";
select dateadd(day,5,dateadd ( month,10,dateadd ( year,year(@startdate) - 1900 - 1),0)));
Corrected version for...
October 26, 2015 at 12:32 pm
The only columns mentioned have been Price, Rating and Location. If rating is a single value, I'll assume that location would be as well (You won't be looking for hotels...
October 26, 2015 at 10:47 am
Here's a different approach with 2 variants:
DECLARE @StartDate DATE = '01/01/15';
SELECT DATEADD( YY, DATEDIFF( YY, 0, @StartDate), '18991106'),
DATEADD( YY, DATEDIFF( YY, 0, @StartDate), -56),
...
October 26, 2015 at 10:23 am
Or maybe this: =Format(Fields!Total.Value,"C")
October 26, 2015 at 10:17 am
I'm not sure about this, but you could give it a try:
https://msdn.microsoft.com/en-us/library/3352e6f5(v=vs.90).aspx
October 26, 2015 at 10:15 am
Then you need to trust your queries. Try tweaking this to get what you need.
SELECT OBJECT_NAME( object_id), *
FROM sys.sql_modules
WHERE definition LIKE '%ColumnName%'
AND definition LIKE '%TableName%'
SELECT OBJECT_NAME( object_id), OBJECT_NAME( referenced_major_id)
FROM sys.sql_dependencies
October 26, 2015 at 9:50 am
Ok, trying to bring this to the original topic.
This is what I was thinking as an approach.
Select Top(10) HotelName, Price, CustomerRating
From dbo.VacationDestinations
where Price <= @price AND CustomerRating = @CustomerRating
Order...
October 26, 2015 at 9:41 am
An easy way to do it, is by using SQL Search: https://www.red-gate.com/products/sql-development/sql-search/
You could also query things on sys.sql_modules.
October 26, 2015 at 9:10 am
Jeff Moden (10/24/2015)
October 24, 2015 at 7:46 pm
happygeek (10/23/2015)
Ed Wagner (10/23/2015)
djj (10/23/2015)
whereisSQL? (10/23/2015)
Ed Wagner (10/23/2015)
DonlSimpson (10/23/2015)
djj (10/23/2015)
Ed Wagner (10/23/2015)
happygeek (10/23/2015)
whereisSQL? (10/23/2015)
Ed Wagner (10/23/2015)
djj (10/23/2015)
Eirikur Eiriksson (10/23/2015)
Ed Wagner (10/23/2015)
anthony.green (10/23/2015)
Ed Wagner (10/23/2015)
anthony.green (10/23/2015)
djj (10/23/2015)
anthony.green (10/23/2015)
Ed Wagner (10/22/2015)
MathSchool
Study
Invest
Risk
Assessment
Process
Inflation
Tire
Wear
Tear
RIP
Tombstone
Limestone
Marble
Granite
Counter-top
Kitchen
Cooking
Spices
Girls
October 23, 2015 at 1:54 pm
I'm not sure if this is what you're looking for:
SELECT e.id,
e.NAME,
e.sdate,
e.edate,
CASE WHEN ROW_NUMBER() OVER(...
October 23, 2015 at 1:33 pm
Viewing 15 posts - 3,961 through 3,975 (of 8,731 total)