Viewing 15 posts - 1,576 through 1,590 (of 2,452 total)
maybe worth a read ....
http://www.sqlservercentral.com/stairway/72494/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 24, 2013 at 3:29 pm
etirem (9/22/2013)
One more CID=333 is added below SQL.
IF OBJECT_ID('Tempdb..#tTable')...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 22, 2013 at 2:34 pm
maybe something along these lines.....???
WITH cte AS
(
SELECT CID,
CDate,
Dept,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 22, 2013 at 5:12 am
RamSteve (8/15/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 15, 2013 at 3:06 pm
RamSteve (8/15/2013)
HI ,Could some one please provide me with 4-4-5 Calender table creation Script where i would need the following columns .. Thanks in Advance
Columns :
Year
Quarter
Period
Month
FiscalWeek
Week
WeekDay
Date
days
for how many years...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 15, 2013 at 2:46 pm
not sure if this will help, buy may set you on your way
http://www.sqlservercentral.com/articles/T-SQL/71550/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 13, 2013 at 2:30 pm
mario.rbrandao (8/13/2013)
foundations
banks
Any suggestions on how we can identify that the first word is the foundation or bank bring full name?
TABLE
FUNDAÇAO XXX ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 13, 2013 at 2:24 pm
remove the "SELECT"
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 15, 2013 at 6:17 am
Beniamin Joke (7/14/2013)
sorry it's kmso the column and not gmso ,i am a little sleepy
ok...sleep well
try running the "simplified" queries I posted earlier, when you are able.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 14, 2013 at 2:07 pm
Beniamin Joke (7/14/2013)
the expected result should be where the gmso colums is equal to 003 from GLMSO table and which have in table GLCTA the column KCTR equal to 01...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 14, 2013 at 1:50 pm
s_v_narayanan (7/14/2013)
Is that possible to write in single query to get the below results -
I need to get the month wise records from the transaction table. If records for that...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 14, 2013 at 10:10 am
shohelr2003 (7/13/2013)
I have a customer table containing many duplicate names and custid is the unique key. But the customer names are not 100% similar. For example,
CustIDCustName
--------------------
100ABC CO
101ABC CO.
102ABC CO&
103ABC...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 14, 2013 at 9:38 am
jcobb 20350 (7/13/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 14, 2013 at 9:25 am
Beniamin Joke (7/14/2013)
table GLMSO which has the
gmso colum 0003 and has both of bot
of KCTR's in GLCTA table
06...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 14, 2013 at 5:50 am
in an effort to try and understand what you require, I have attempted to simplify your query and just return relevant columns....based on code below...what results do you want?
SELECT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 14, 2013 at 3:25 am
Viewing 15 posts - 1,576 through 1,590 (of 2,452 total)