Viewing 15 posts - 2,476 through 2,490 (of 2,894 total)
Nevyn (7/26/2010)
July 26, 2010 at 10:43 am
Then VARCHAR. Give it some relevant size based on sample of data you have. It looks like extract from other system, so you may ask for specification describing maximum length...
July 26, 2010 at 10:32 am
How are you going to name this column?
If it's Comments then varchar can be used.
If it's intended be "Details", then follow Gail advise and split it into separate columns,...
July 26, 2010 at 10:25 am
I think that regardless of settings such comma separated string in SQL can be easely converted to money:
select CAST ('100,200' as money)
returns 100200.00 !
and
select CAST ('100,200,300' as money)
returns 100200300.00
And...
July 26, 2010 at 10:23 am
Jeff Moden (7/26/2010)
asiaindian (7/26/2010)
Add a month to the startdatedeclare @StartDate date
set @StartDate = '01-31-2010''
select DATEADD(mm, 1, @StartDate)
Repeat above code through any number of frequencies. Hope this helps.
Ok.... you have 100...
July 26, 2010 at 7:50 am
Ok, I may be an idiot. BUT!
Did anyone, before providing answers, understood what this OP really have in his DB and what he is really trying to do?
He said that...
July 26, 2010 at 7:23 am
try:
declare @date datetime, @freq int
set @date = '2010-01-29'
set @freq = 6
SELECT DATEADD(MONTH, MM, @date) AS ReqDate
FROM (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) - 1 AS MM FROM sys.columns) TallyOnFly
WHERE...
July 26, 2010 at 6:31 am
I wonder, for
select 5, 'ABC', 2002, 27 union all
select 6, 'ABC', 2005, 27
Do...
July 26, 2010 at 6:21 am
tasnim.siddiqi (7/26/2010)
I have also run your code, with the Output Clause. I get the following error
Msg 4104, Level 16, State 1, Procedure stored_proc2, Line 50
The multi-part identifier "Temp_Event_Import.Cert_Status" could not...
July 26, 2010 at 5:38 am
1. Noodles are greate for asian cuisin but not for T-SQL :-D, therefore first step will be transforming your statement into readable form (please note how using table aliases and...
July 26, 2010 at 5:05 am
tripri (7/25/2010)
@varunfilim: thanq yarr...its not for an oltp...
its just for olap...
any how that link was very useful for brushing up my knowledge..thanx yarr
OLAP? - Even better! :w00t:
You can start learning...
July 26, 2010 at 4:37 am
If the task you are implementing going to be regulary executed, I would suggest using SSIS, as it is specifically designed to do so.
BCP will be the fasterst method to...
July 26, 2010 at 4:24 am
tasnim.siddiqi (7/25/2010)
...If so then, whats the point of using OUTPUT clause anyways, because I can easily enter that row in the table whenever I am updating or inserting.
...
There is...
July 26, 2010 at 4:19 am
malleswarareddy_m (7/22/2010)
July 23, 2010 at 5:41 am
Friend, when I have read your question first time I thought that you are drunk 😀
After looking it closely I think now I understand what you want.
Assuming that the grouping...
July 22, 2010 at 10:14 am
Viewing 15 posts - 2,476 through 2,490 (of 2,894 total)