Viewing 15 posts - 4,636 through 4,650 (of 7,619 total)
Sergiy (11/19/2015)
ScottPletcher (11/19/2015)
Yes, by deleting them from the current promo table, not by just flagging them. They...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 19, 2015 at 3:30 pm
To have the index automatically built, you can add a persisted, computed column, like this:
CREATE TABLE search_T
(
num INT,
value VARCHAR(max),
value_for_indexing as cast(left(value,896) as varchar(896)) persisted
,UNIQUE CLUSTERED (num,value_for_indexing)
)
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 19, 2015 at 3:27 pm
Sergiy (11/19/2015)
ScottPletcher (11/19/2015)
When it's used up initially, it's removed forever from the current table, since it has no current value.
No person...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 19, 2015 at 3:05 pm
Sergiy (11/19/2015)
ScottPletcher (11/19/2015)
Sergiy (11/19/2015)
ScottPletcher (11/18/2015)
Once they've been used up, you'd remove them so they can't be reused.
How exactly you intend to prevent used codes from being reused (regenerated as new)...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 19, 2015 at 2:35 pm
Sergiy (11/19/2015)
ScottPletcher (11/18/2015)
Once they've been used up, you'd remove them so they can't be reused.
How exactly you intend to prevent used codes from being reused (regenerated as new) if they...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 19, 2015 at 1:40 pm
Sergiy (11/18/2015)
ScottPletcher (11/18/2015)
Once they've been used up, you'd remove them so they can't be reused.
How exactly you intend to prevent used codes from being reused (regenerated as new) if they...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 19, 2015 at 8:30 am
Sergiy (11/18/2015)
ScottPletcher (11/18/2015)
Lol. So you think Amazon.com has every gift code number they've ever issued in their current gift codes table? Unbelievable.
Why not?
May be not "ever issued", may...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 18, 2015 at 3:55 pm
Sergiy (11/18/2015)
ScottPletcher (11/18/2015)
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 18, 2015 at 3:04 pm
Sergiy (11/18/2015)
ScottPletcher (11/18/2015)
First, how do you know that inactive codes are routinely searched? That's almost never the case.
Mobile top up numbers. Gift cards. iTunes cards. Game access codes. Software...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 18, 2015 at 2:49 pm
I suggest trying the BULK INSERT command, since you can stop it after only one row. Specify a never-found field terminator to make sure you read the entire first...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 18, 2015 at 12:40 pm
I would think first create a temp table that matches the output of that command:
CREATE TABLE #filelistonly ( ... )
then do this:
INSERT INTO #filelistonly
EXEC('restore filelistonly from disk = ''G:\folder1\backupfile091.bak'')
Finally, of...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 18, 2015 at 12:17 pm
Sergiy (11/17/2015)
ScottPletcher (11/17/2015)
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 18, 2015 at 8:57 am
SQL-DBA-01 (11/17/2015)
SELECT CHARINDEX('_', name) FirstIndexOf,
--CHARINDEX('_', name)+1,
CHARINDEX('_', name, (CHARINDEX('_', name)+1)) SecondIndexOf,
charindex('_',name, CHARINDEX('_',name,(charindex('_',name ) + 1 )) + 1 ) ThirdIndexOf,
charindex('_',name,CHARINDEX('_',name,(charindex('_', name ,(charindex('_',name ) + 1 )) +...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 17, 2015 at 3:49 pm
First you'll need to decide how you want to handle birthdays on Feb 29. In non-leap years, do you want to treat Feb 28 as the birthday, or March...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 17, 2015 at 9:33 am
insert into #test values
('2100110'),
('2100110,12')
select
HID,
case when last_comma = 0 then HID
when next_to_last_comma = 0 then LEFT(HID, LEN(HID) - last_comma)
else...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
November 17, 2015 at 9:10 am
Viewing 15 posts - 4,636 through 4,650 (of 7,619 total)