Viewing 15 posts - 8,131 through 8,145 (of 13,460 total)
your post made it a lot clearer, thanks.
i think this is what you want to do: use the formula you created on the two columns themselves...
select
callref,
...
February 10, 2011 at 7:58 am
no...i think you want to insert a FIELD instead; you have much more control. also, you can manually change the format to the desired format, with string constants in it...
February 10, 2011 at 7:50 am
while you were posting, i edited and added this:
as for deleting data...you can do the following: instead of REALLY deleting, you can add a column "isDeleted" to your data...then you...
February 10, 2011 at 7:42 am
SQLCHILD (2/10/2011)
Actually, i have a .net application through which lacs of data would be inserted by the users.
but as usual, users keep on making mistakes. so i want...
February 10, 2011 at 7:34 am
yes, you can create temporary tables in SQL...but there is a time and a place for it. temporary databases? for get it, you'l have way too many permissions problems to...
February 10, 2011 at 6:35 am
a_ud (2/10/2011)
...so don't answer change the view)I'm interested in a solution for this at table level / view level /any other level
you said don't change the view, but then asked...
February 10, 2011 at 6:24 am
you say the query doesn't work...but your calculation seems to be returning a value...
I'm just guess, maybe it wasn't obvious, but you can substitute the @variable for a column name...
February 10, 2011 at 5:41 am
if you are stuck with SLq 2000, you have to use a temp table; there's no other way around it.
here's a fine example from Jeff Moden that i copied years...
February 9, 2011 at 1:29 pm
if you run this query, do you see the mail item that failed? if it's not failing, maybe a spam filter is intercepting it?
select * from msdb.dbo.sysmail_event_log lg
inner join...
February 9, 2011 at 12:15 pm
in that case I'd recommend not using a trigger at all.
with or without the trigger you could do two things that i can think of:;
1. skip the trigger and have...
February 9, 2011 at 7:04 am
sp_send_dbmail is safe to use in a trigger;
sp_send_dbmail is asynchronous, so it returns without errors immediately...your trigger would not wait for it.
the only way i've encountered so far that it...
February 9, 2011 at 5:24 am
TSQL CASE is not the same as other programming languages...
in SQL, CASE is used to return data...to make logical decisions, you have to use IF.ELSE
How can I accomplish this?
IF...
February 8, 2011 at 3:05 pm
ok how about this: it's simply doing a REPLACE on the original phrase, and using datalength to get the differences:
No Tally, so i think it'll be faster than anything so...
February 8, 2011 at 2:09 pm
ok, you want the reverse...you have a bigint field, but want preceding zeros.
the max bigint value is 9,223,372,036,854,775,807
9223372036854775807
|______19 digits___|
123456789012345678
that's 19 digits.... assuming you want up to 18 preceding zeros, you...
February 8, 2011 at 12:44 pm
Viewing 15 posts - 8,131 through 8,145 (of 13,460 total)