|
how can i check the old recovery model?
i try to change it from DB options but after changing to simple LOGS backup is not possible.
DB is showing its size 221GB including LDF size..
Any suggestion to get out from this issue.
|
|
|
|
|
We all have functions and code for business day calculations, or last day of the month calculations, ect... I am adding a caveat to this for Last business day of the month, not a holiday. I.e. (hypothetical), Last day is 12/31/2015, this is a Friday, however the company give this day off as a holiday so 12/30/2015 needs to be determined as the last business day of the month.
I am looking at a couple of ways to approach this.
1) Calculate the Last Day of the month, Determine if it is not a Sat\sun, if is DateDiff to a business day, then take that date and compare to a Holiday table and adjust accordingly.
2) use a function that already exists for Last Business day of the month and then take that date and compare to a Holiday table and adjust accordingly.
3) some better what that I can not think of and no we can not use the XLeratorDB or what ever that is called.
The out put I am looking for is just a DATE, the date of the very last company business day of the month.
Thank you In advance!
No reason to re-invent the wheel, just improve upon existing.
|
|
|
|
|
swoozie1 wrote: use a function that already exists for Last Business day of the month
Maybe somneone already wrote one, but there's no such thing built in, AFAIK. What a "week" or "weekend" is, is determined by your locale, and a company may have multiple of those. Holidays are even more complex, and tend to change rather frequently.
Create a loop that inserts weekdays for your locale in a table; that way you have list with the weekends already eliminated. Next, delete every date in there that is mentioned in the holidays table (or join, or make a new table). Select the top result for that month.
There's your last theoretical work-day.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I use a view and a holiday table as I need to keep holidays for a number of countries/currencies. The view starts at the beginning of last year and goes for 10 years, arbitrarily picked by me, it has date part DayOfWeek so I can exclude weekends.
It will be fairly simple to combine the two as Eddy suggested, fiddling with the filters/joins to get the last working sate.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello .
I am quite a beginner in Sql Server, I am testing some simple sql code on Sql Server 2012.
I have a table called "AcctTransaction" composed by 4 columns :
AccountId as Int,
TransactionId as Int,
TransactionDate as DateTime,
Amount as Decimal (a8,4)
I am trying to make this simple query work :
SELECT AccountId
,SUM(Amount) OVER (PARTITION BY AccountId) AS FinalBalance
,SUM(Amount) OVER (PARTITION BY AccountId ORDER BY TransactionDate, TransactionId
) AS ProgressiveBalance
FROM AcctTransaction
I keep getting the following error :
Incorrect syntax near "order"
and in effect if I comment out the
,SUM(Amount) OVER (PARTITION BY AccountId ORDER BY TransactionDate, TransactionId ) AS ProgressiveBalance
statement, everything works correctly.
What's wrong with that statement ?
I've made this query copying almost identically a sql statement I saw in a Microsoft course, where it seems to work perfectly....
Thanks to everyone who would answer ...
modified 28-May-15 8:40am.
|
|
|
|
|
A sudden thought ... is it possibile that I am getting this error only because I am using the Express version of Sql Server 2012 ? Maybe the express version, being not complete, lacks the "LAG" function....
Just a random thought .....
|
|
|
|
|
Are you sure you're using SQL 2012? I've just tried an equivalent query on my copy of 2012 Express, and it works perfectly.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Well, that's what it says on "Help | About" section from the top menu ....
Other infos are :
Microsoft SQL Server Management Studio 11.0.2100.60
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9.11.9600.17801
Microsoft .NET Framework 4.0.30319.34209
Operating System 6.1.7601
Is it possible I have some components that's missing ?
|
|
|
|
|
You might be using SQL 2012 Management Studio, but are you connecting to a SQL 2012 instance?
Try running:
SELECT @@VERSION
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
You are right my friend .... executing the query you suggested I realized I am actually using Sql Server 2008 ....
and this maybe will solve some other problems I think I have ...
Thank you very much
|
|
|
|
|
I want to learn rdbms can anybody give me brief concept of RDBMS.
Thank you
|
|
|
|
|
Use a search engine; look for concepts. Start reading.
If you have a particular question, post your code/SQL statement here and someone will probably try to help.
|
|
|
|
|
|
What is your question? Where is your code? There are not enough details here.
|
|
|
|
|
That is not a question, it is an assignment; one that is lacking enough data to complete it.
If you need to dump data from table1 into table2, I'd recommend a single "select" statement. No need for cursors there. If you are wondering how to build a cursor, I'd recommend the examples on MSDN.
You're welcome.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
TSQL - Cursor[^]
TSQL - Select statement[^]
TSQL - Insert[^]
This is some links to the msdn documentation on various method that you will need to employ to complete your task as you have stated. BUT as others have stated I would also look into the SELECT INTO commands
TSQL - Select Into[^]
if you need more help after this please post your sql statements that you have you and describe the problem that you are facing. Sadly no one will be willing to just hand you the code without any effort.
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
Your request is rude. Consider yourself lucky you got some pointers.
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
modified 22-May-15 10:27am.
|
|
|
|
|
I want a code of java prog
which can take million integers as input,
sort them (bubble or quick or selection sort).
It should display time taken to sort first 10 integer, then for first 100 integer, then for 10000 and total.
Please help me soon I have very less time to complete my project.
iamsohail.srk@gmail.com
|
|
|
|
|
You'll have a greater chance of getting an answer if you post in the JAVA forum[^].
And when you do, be sure to say what you've tried and where you're stuck.
|
|
|
|
|
Sohail Sowell wrote: I want a code of java prog
You can get help if you are stuck with a specific question on writing the code; but if you are looking for someone to do your work, this is the wrong place.
Good luck.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Your less time is not a problem for us. We are help to help, not to serve.
In Java integers have a limit. You cannot exceed those limits, otherwise you will face a problem known as "Integer Overflow" or "Integer Underflow". It depends on the size of that type, int or long etc. However, there is another special class in Java, BigInteger[^]. You can use it to overcome these limitations in Java.
Rest of the stuff are just fancy algorithm based functions. If you are well aware of these functions and algorithms then you can definitely write them yourself. What is so difficult in these problems? Learn more on them, https://en.wikipedia.org/wiki/Bubble_sort[^], https://en.wikipedia.org/wiki/Selection_sort[^], https://en.wikipedia.org/wiki/Quicksort[^].
Then use timer to check how long does it take to complete the task. Simple!
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Afzaal Ahmad Zeeshan wrote: Learn more
I think this may be an invalid assumption 
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I want a code of java prog
which can take million integers as input,
sort them (bubble or quick or selection sort).
It should display time taken to sort first 10 integer, then for first 100 integer, then for 10000 and total.
Please help me soon I have very less time to complete my project.
iamsohail.srk@gmail.com
|
|
|
|
|
No, this is not how it works. We gladly help when you get stuck but we aren't going to do all your work for you.
You didn't even manage to post this in the correct forum.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
I am using sql server 2005.
I have a column with date values (say column1). I need to fetch the date which does not exist in the past 15 days.
Means : user insert records daily. But on May 1st due to leave no records got inserted. So I need to analyse past 15 days (from current date) and fetch only May 1st.
I tried below query.But its return the past 15 days (excluding weekends). But i need days which not exist in past 15 days.
select distinct top 15 inserteddate from table1 where
((DATEPART(dw, inserteddate) + @@DATEFIRST) % 7) NOT IN (0, 1) and ( inserteddate >= DATEADD(DAY,-15,inserteddate) and inserteddate <= getdate())
order by inserteddate desc
Help me pls.
modified 11-May-15 9:22am.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
