Viewing 15 posts - 8,626 through 8,640 (of 9,399 total)
bitbucket-25253 (12/6/2013)
crookj (12/6/2013)
Cool (-6 degrees outside)Snow
Ice
December 6, 2013 at 9:17 am
Grant Fritchey (12/6/2013)
Oh well heck, everyone else has said it and now I feel left out.Congrats Gail.
What was it you did again?
...
Kidding, kidding. Put that stick down... 😛
Yeah...I hear Gail...
December 6, 2013 at 6:40 am
general20 (12/6/2013)
but it doest give me correct solution.
I want to set between which date are going to calculate .
for example 12-07-2013 between 12-09-2013
On the other hand, whats...
December 6, 2013 at 6:37 am
So you have columns named 20131206, 20131107 and 20131108? You're keeping some type of history for 30 days, but why would you store dates as columns instead of storing...
December 6, 2013 at 6:10 am
general20 (12/6/2013)
I want to calculate min and max datetime for every person one by one.
There are 50 person in this data and also there are datetime information everyday.
I want...
December 6, 2013 at 6:05 am
BWFC (12/6/2013)
Ed Wagner (12/4/2013)
crookj (12/4/2013)
Ed Wagner (12/4/2013)
JAZZ Master (12/3/2013)
crookj (12/3/2013)
Revenant (12/3/2013)
Ed Wagner (12/3/2013)
whereisSQL? (12/3/2013)
opc.three (12/3/2013)
FrameworkWrapper
Reuse
Repurpose
Hand-me-down
Seconds
Dinner 😀
Pippin
Ring (from the Lord of the Rings)
Cycle
Life Cycle
December 6, 2013 at 5:32 am
While I'm anxious to try out in-memory OLTP, it leaves me with two questions.
1. How are the transaction logs stored? If they aren't written to disk, we'll lose durability,...
December 6, 2013 at 5:31 am
Luis Cazares (12/5/2013)
DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) - 1, 0)Is getting the first day of previous month.
DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0)
Is getting the first day of current month.
- '00:00:01'
Is substracting...
December 5, 2013 at 10:52 am
GilaMonster (9/7/2013)
Don't use sa. Use specific accounts for specific users with minimal permissions. Strong passwords or preferably windows authentication.
+1. In fact, just disable the sa login completely. If you...
December 5, 2013 at 10:51 am
eobiki10 (12/5/2013)
Can someone help me interpret what this code is doing.
open_date BETWEEN DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) - 1, 0) AND DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0) - '00:00:01'
and is...
December 5, 2013 at 10:46 am
Luis Cazares (12/5/2013)
Actually you can use a variable inside IN if it is called from SSRS. The variable is replaced in the query before submitting it to SQL Server.
My knowledge...
December 5, 2013 at 10:29 am
I have a situation where I need to distribute a certain set of rows over a period of time. The number of rows, number of months and base date...
December 5, 2013 at 10:07 am
rightontarget (12/4/2013)
I was asked to create a test environment for one of our apps that is supported by 3 databases.
I can restore latest backup of production version of each,...
December 5, 2013 at 6:12 am
This uses Jeff Moden's DelimitedSplit8K function posted at http://www.sqlservercentral.com/articles/Tally+Table/72993/. If you aren't familiar with it yet, take the time to acquainted with it. It's well worth the read.
select column_a =...
December 5, 2013 at 5:57 am
Hello and welcome to the forums. To make it easier for everyone to help, could you please post the following?
1. DDL to create the tables and DML to populate...
December 5, 2013 at 5:39 am
Viewing 15 posts - 8,626 through 8,640 (of 9,399 total)