Viewing 15 posts - 1,651 through 1,665 (of 3,509 total)
If you're not allowed to create the function, ask someone with permissions to do it. If they want their answers, they're going to have to comply. =) The function can...
February 2, 2017 at 10:17 am
First step is to give whoever did this a beating. Databases like this are pretty much useless.
Here's most of a solution:
link to DelimitedSplit8K
DECLARE @MyString...
February 2, 2017 at 9:55 am
UPDATE TimeAccountMovement
SET ownerID = DutyRosterShift
WHERE A.orig_owner_ID = 999999
AND B.Orig_id = A.OwnerID;
February 2, 2017 at 12:57 am
January 30, 2017 at 4:33 pm
January 30, 2017 at 1:44 pm
January 30, 2017 at 10:39 am
January 30, 2017 at 10:31 am
January 28, 2017 at 8:46 pm
January 27, 2017 at 10:36 pm
Issue:-
I have a table with 6 columns a,b,c,d,e,f...
January 27, 2017 at 2:39 pm
January 25, 2017 at 2:48 pm
So you have Sales (or something similar) and now you want to add a Forecast fact table? They're not the same granularity. They don't belong in the same table. They're...
January 23, 2017 at 9:43 pm
Without CREATE TABLE and INSERT scripts, there's not much we can do to help you. =(
January 23, 2017 at 8:24 pm
January 20, 2017 at 3:36 pm
January 20, 2017 at 3:03 pm
Viewing 15 posts - 1,651 through 1,665 (of 3,509 total)