Viewing 13 posts - 16 through 28 (of 28 total)
your last bracket is missing a / before the word code. /code
July 18, 2013 at 12:06 pm
riya_dave (7/17/2013)
my query is giving me erro
delete top(1000) from table a
join table b
on a.id = b.id
and b.date < getdate()
error: incorrect syntax near a.
i want to delete top 1000 from...
July 17, 2013 at 3:29 pm
Before modifying data it is always a good idea to create a temp table as a backup. Once you delete it all, there's no going back.
July 16, 2013 at 4:27 pm
Assuming you want all the data collected from today until two years ago to this date then the logic is:
create_timestamp > (The function you're using to go back to exactly...
July 16, 2013 at 8:18 am
Assuming you're talking about the create timestamp of the data, then this could work setting tablename to whatever your table is called.
DATEADD feature is used with CURRENT_TIMESTAMP. Useful to know,...
July 15, 2013 at 3:50 pm
Seeing as I work in medical these tables look a lot like NextGen tables 😉
July 15, 2013 at 2:05 pm
On the topic of renewing government documents.. Allow me to share a story:
Last September my car was broken into while I was at the gym. Of course, this is the...
July 12, 2013 at 11:55 am
You have more than 3 columns.
Have you written any code for this at all? Can you post it? What have you tried?
As others have said, MAX and Group By...
July 12, 2013 at 10:14 am
mromano222 (7/12/2013)
when i use these i get an error that says "Oralce ODBC Ora -00920 invlaid operational operator
You posted in a SQL server forum 🙂 He gave...
July 12, 2013 at 8:32 am
Assuming you have a DR (damage recovery) site and some sort of backup that runs nightly (RedGate for instance) then it's not 100% required to have your Devl environment equal...
July 11, 2013 at 12:25 pm
Viewing 13 posts - 16 through 28 (of 28 total)