Viewing 15 posts - 11,506 through 11,520 (of 15,376 total)
TheSQLGuru (6/22/2012)
Eugene Elutin (6/21/2012)
I cannot understand why would you need dynamic sql for statements there.
Why not to have the same stored procedures in every database and call them dynamic sql....
June 22, 2012 at 9:41 am
Shot in the dark...
WHERE Date_Used between @date1 and @date2
???
June 22, 2012 at 9:38 am
Lynn Pettis (6/22/2012)
Sean Lange (6/22/2012)
Lynn Pettis (6/22/2012)
I'm trying to decide if I should be happy or insulted, I mean really, Lynndrome? 😉 :w00t: 😛
I certainly hope you don't feel...
June 22, 2012 at 9:29 am
Lynn Pettis (6/22/2012)
I'm trying to decide if I should be happy or insulted, I mean really, Lynndrome? 😉 :w00t: 😛
I certainly hope you don't feel insulted!!! It just hit...
June 22, 2012 at 9:21 am
Lynn Pettis (6/22/2012)
Sean Lange (6/22/2012)
Lynn Pettis (6/22/2012)
Sean, why all the concatenation?
That my friend is a might fine question. 😛 Sometimes the keyboard starts before the brain kicks in.
Not only is...
June 22, 2012 at 9:17 am
Lynn Pettis (6/22/2012)
Sean, why all the concatenation?
That my friend is a might fine question. 😛 Sometimes the keyboard starts before the brain kicks in.
Not only is your solution cleaner it...
June 22, 2012 at 9:12 am
OK I modified your ddl a little bit so the sample data will work.
CREATE TABLE #mytable
( ID INT ,
Product Char(50),
Sum INT,
YearValue INT,
MonthValue INT
)
INSERT INTO #mytable
(ID, Product, Sum, YearValue, Monthvalue)
SELECT '4','Green','1000','2012','2'...
June 22, 2012 at 9:04 am
Sachin 80451 (6/22/2012)
( ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, ...
June 22, 2012 at 8:57 am
where Num % 1 <> 0
OK I am done now...otherwise we are going to start into completely ridiculous string manipulation. 😉
June 22, 2012 at 8:53 am
Or a better twist on mine than casting to an int.
select * from Nums
where Num <> floor(Num)
June 22, 2012 at 8:48 am
LOL got distracted while posting, seems Lynn beat me to the punch with a different approach to the same thing.
June 22, 2012 at 8:46 am
Not the best for performance because it isn't sargable but this should work.
;with Nums(Num)
as
(
select 100.00 union all
select 200.00 union all
select 350.01 union all
select 235.07 union all
select 38.10 union all
select 4.006...
June 22, 2012 at 8:46 am
Then you will need to become familiar with date routines.
Lynn has some great ones here. http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D
You can use that to figure out your starting date. Then you just need...
June 22, 2012 at 8:26 am
sunshine-587009 (6/22/2012)
I'm trying to get the last update statement to work and it is not work for me. I receive errors on the join. Any help appreciated!
Results I'm looking...
June 22, 2012 at 8:23 am
Koen Verbeeck (6/21/2012)
Lynn Pettis (6/21/2012)
OMGPlease, I really hope this person was joking.
Oh god not him.
He's the most important reason I have such a high post count. Trying to help him...
June 22, 2012 at 8:11 am
Viewing 15 posts - 11,506 through 11,520 (of 15,376 total)