Viewing 15 posts - 1,756 through 1,770 (of 2,452 total)
oscarooko (10/2/2012)
Eugene Elutin (10/2/2012)
declare @Table1 table (EmailAddress varchar(20), Msg varchar(20))
insert @Table1
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 2, 2012 at 8:54 am
in response to rf44 mammoth post..... what an effort. :w00t: ..I do hope that the OP will appreciate the effort that you must have put into...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 1, 2012 at 11:40 am
Welsh Corgi (10/1/2012)
I hear a lot of laughs when professional come across tables...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 1, 2012 at 11:28 am
Welsh Corgi (10/1/2012)
Maybe I'm alone on this but I cringe when I see table names prefixed with 'tbl'.IMHO, not a good practice.
Hi Welsh...out of curiosity ....why "not a good practice"?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 1, 2012 at 10:49 am
Hi Mike
take a look at this article by Jeff Moden...may give you a few ideas
http://www.sqlservercentral.com/articles/T-SQL/72503/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 30, 2012 at 12:34 pm
would you care to provide some set up scripts (create table / sample data) this will help us to clarify your question.
thanks
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 30, 2012 at 4:54 am
something along these lines......??
--=== this relies on a "numbers" or "tally" table
--=== http://www.sqlservercentral.com/articles/T-SQL/62867/ by Jeff Moden
; WITH CTE as
(
SELECT dbo.WIPMaster.WorksOrder ,
dbo.WIPMaster.Parent ,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 29, 2012 at 10:24 am
Chris Schmidt (9/27/2012)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 29, 2012 at 8:32 am
yingchai (9/22/2012)
I have a below table with column names ACCOUNT, QTR1, QTR2, QTR3, QTR4
ACCOUNT QTR1 QTR2 QTR3 QTR4
-------------------------------
Opex 20 0 0 0
Sales 30 0 0 0
Costs 55 0...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 22, 2012 at 9:49 am
If you are talking about formatting your code into a more readily readable layout then there are several "tools/addins" that will allow you to do this...along with allowing you to...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 21, 2012 at 3:40 pm
article here may help you:
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 21, 2012 at 1:33 pm
can you please provide some sample data...it would be helpful in understanding your problem
thanks
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 17, 2012 at 11:25 am
Hi
as a start, suggest you read the article below...it seems to be very clsoe to what you are asking and will explain the method far better than I can.
http://www.sqlservercentral.com/articles/T-SQL/88244/
if you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 16, 2012 at 12:51 pm
really not sure if this is what you are after...but try it as a start and then we maybe improve
;with CTE as
(
SELECT OURID
FROM XTR
WHERE FACILITY IN(...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 15, 2012 at 10:08 am
maybe this will give you some ideas
hope it helps
http://www.csharpest.net/?p=117
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 15, 2012 at 8:48 am
Viewing 15 posts - 1,756 through 1,770 (of 2,452 total)