Viewing 15 posts - 46 through 60 (of 201 total)
mageshh11 (7/8/2011)
Using the sql server 2005 db mail provision to send mail.
In this building the body text dynamically (looping through cursor to build string) and then assigning it the @body...
July 8, 2011 at 1:27 am
Gianluca Sartori (7/7/2011)
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Hrmm interesting... you do know thats not the same link as the one that you have in your signature? ... though they address 2 different things... so nevermind....
July 7, 2011 at 5:41 am
Doubt the IN is the problem unless there are alot of values. But without having any information regarding datatypes/indexes and so on its more or less impossible to give a...
July 7, 2011 at 5:37 am
Marry Krissmess (7/7/2011)
July 7, 2011 at 1:43 am
mister.magoo (7/6/2011)
I didn't like all the RBAR so I had a go at a non-RBAR and came up with this.
It is a bit hard to read because of the complexity...
July 7, 2011 at 12:39 am
Fraggle-805517 (7/6/2011)
July 6, 2011 at 11:37 pm
rmata_76 (7/3/2011)
I'm Randy and a newbie here so pardon if i have miss some other requirement to post my question in this forum.
Here it goes, i'm supporting our legacy...
July 6, 2011 at 3:20 am
Could do this with a cross join. Though depends a bit on what you want for values in the S1, S2, S3 columns for the "fake" rows.
Select case x.nr when...
July 5, 2011 at 12:17 am
Perry Whittle (7/4/2011)
and don't be tempted to hold the power button for 4 seconds neither, it'll take just as long otherwise when you restart 😉
4s! Thats to slow... much faster...
July 4, 2011 at 11:43 pm
samiroko (7/4/2011)
Ok BABAI will look it myself but i am not gonna mark your post as answered;-)
FYI... there is no such function on these forums 😀
/T
July 4, 2011 at 6:33 am
revozex (7/4/2011)
EmployeeCode, Name, BudgetCode1,BudgetCode2,BudgetCode3...BudgetCodeN
The N part makes it harder.
revozex (7/4/2011)
Employee Table:
EmployeeId, EmployeeCode, Name, SSN, Gender
1, CL7653, Paul, WT, M
BudgetCode Table:
BudgetCodeId, EmpId, BudgetCode, Percentage
1, 1, US8765, 50
1, 2, US8543, 50
Desired Result:
EmployeeCode,...
July 4, 2011 at 6:28 am
There is a HUGE difference between "few patches" and "safe". Just because there are so few patches doesnt mean alot when judging how safe a system is or how well...
June 19, 2011 at 11:33 pm
A quick search on this site and one could for instance find
http://www.sqlservercentral.com/Forums/Topic777289-1291-1.aspx
Scroll down to Lynn Pettis first post. I would recommend reading the whole post since there is also...
May 10, 2011 at 12:58 am
f.marquis (5/10/2011)
Another way to do this :1) Add 1 month
2) Substract the day number of the previous result :
DECLARE @mydate datetime='20080224'
SELECT DATEADD(day, -DATEPART(day, @Mydate), DATEADD(MONTH, 1, @mydate))
One problem with this...
May 10, 2011 at 12:44 am
Paul Randal (5/6/2011)
tommyh (5/5/2011)
What the **** was Microsoft thinking here... ah thats right they wherent thinking as usual... sigh.Great question though, definatly worth knowing.
/T
There's no choice but to have it...
May 9, 2011 at 2:54 am
Viewing 15 posts - 46 through 60 (of 201 total)