Viewing 15 posts - 211 through 225 (of 1,583 total)
There are countless scripts out there for this, what specifically are you wanting to track?
Try this link 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 10, 2014 at 10:52 am
Did the suggestion help or did you go another route?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 9, 2014 at 7:26 pm
Looks good!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 8, 2014 at 6:11 am
You are adding a column "DescriptionManual", yet in your queries referencing "ManualDescription" - am I missing something or this just a typo?
Your update should look something like:
UPDATE [Core.Projects]
SET ManualDescription= [Whatever...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2014 at 11:10 pm
You're getting duplicates because you're only looking at ItemCode...
select ROW_NUMBER()
over
(
partition by td.itemCode
order by td.itemCode
) as Seq, You might want to partition on [Bin Label] as well (depends on what you're...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2014 at 11:05 pm
Undo whatever you did so you can run the code below to get a baseline (as Gail and Jeff stated, your keylookup may not be a bad thing - you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2014 at 10:56 pm
Please post your actual update statement that you are "binding" from the application - we may be able to better help...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2014 at 10:45 pm
Thanks Jeff! Unfortunately like Sean's solution, it works great for smaller tables - the one I'm looking at has 127,170,878 rows of data and has a data footprint of 532,771...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2014 at 10:40 pm
You said users couldn't update the Description field, so you were adding a new column to the table named Description1. Correct?
So...in order to successfully use an update statement, you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2014 at 10:30 pm
Thanks for the code Sean. I let it run for about 20 mins and killed it...
These tables are rather large :crazy:
Going to do some creative "googling" and see what...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2014 at 7:59 pm
Is the profile set to public or private?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2014 at 9:56 am
You could try: ALTER TABLE [YOURTABLE] ADD [Description1] varchar(255) NULL
And something simple like:UPDATE [YOURTABLE]
SET Description1 = 'Your new description text'
WHERE ContactID = @ContactID
Then to get the proper description field:SELECT...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2014 at 8:07 am
You can set the "Reply Email" and "Display Name" attribute in the DB Configuration Wizard, you can also override these settings during the sp_send_mail execution
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2014 at 7:52 am
I've actually never had an issue with the SSIS task, from my perspective it works perfectly. What kinds of issues have you encountered sqlBuddy?
I set up the task:
LoginsToTransfer =...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 7, 2014 at 7:43 am
Not everyone "enjoys" using it, but it is pretty powerful - and I guess you could tell by my tone that I'm not particularly fond of it 😀
You would need...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 4, 2014 at 8:52 am
Viewing 15 posts - 211 through 225 (of 1,583 total)