Viewing 15 posts - 8,131 through 8,145 (of 13,469 total)
I know if you right click the diagram in 2005 and above, there is a "Copy To Clipboard" option, but it copies as an image/bitmap, so you can paste it...
February 10, 2011 at 3:25 pm
those "ISO-11179 rules" aren't rules, they are guide lines, or at least an attempt at best practices; calling them anything other than is misleading.
no DBMS system anywhere prevents you from...
February 10, 2011 at 3:07 pm
the trick here is to the the SUM of a CASE which tests the columns you are after;
take a look at my example below;
based on your post, something like this...
February 10, 2011 at 1:59 pm
here's something i put together a long time ago; this requires one tablescan for the EXISTS() of every table that has a char/varchar/nchar/nvarchar column in it's definition...
so if you have...
February 10, 2011 at 1:51 pm
standard answer...it depends: experience is based on challenges and problems you learn to overcome, right? it depends ont he work environment.
if you write reports, you could expect your...
February 10, 2011 at 11:36 am
what have you tried so far?
SQL supports the TOP command, ie
--last 90 days of data
SELECT TOP 50 ColumnList From MyLogTable Where SomeDate > dateadd(dd,-90,getdate())
February 10, 2011 at 11:18 am
i got thru turning your post into consumable data, and ran out of gas....
if the data was already in consumable format, i probably would have worked on a solution instead.
here's...
February 10, 2011 at 11:13 am
No we are on the same page.
a mailmerge substitutes [Fieldname] in the word document with whatever value is coming from the database. but in many cases, you wan thte value...
February 10, 2011 at 8:15 am
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
Viewing 15 posts - 8,131 through 8,145 (of 13,469 total)