Viewing 15 posts - 1,786 through 1,800 (of 2,838 total)
Let me start by asking a few questions
Does the table V_KASSTRNS exist in the FUTURA_CHINA database on the APP06 server?
It is prefaced with a V, does that mean it is...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 4, 2011 at 1:28 pm
thbaig1 (5/4/2011)
RDBMS : sqlserver 2005
OS : windows
I have to write a stored proc, for given below scenario
Table-A
id
name
col1
col2
col3
...
coln
we add column for some new values. Col1-n will have only status...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 4, 2011 at 1:05 pm
SQLMyFriend (5/4/2011)
I'm interesting to be a sql developers too, so just curious what is the work flow and how web developers...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 4, 2011 at 12:50 pm
ranuganti (5/4/2011)
(@ID varchar (30),
@code varchar (10),
@startdate smalldatetime = NUll,
@enddate smalldatetime = Null
) as
begin
select * from vw_ABC DB
where @ID = D.ID
and ((@startdate is Null or...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 4, 2011 at 12:41 pm
I'd also like to suggest that you don't delete the old data. Push it off into an Archive table of the same structure. This will help you if there's any...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 4, 2011 at 8:01 am
SQLRNNR (5/3/2011)
Something like this?
Select *
From sometable st
LEFT JOIN stable2 ac
LEFT JOIN stable3 nc
ON ac.somefield = nc.somefield
AND ac.somefield + 1 = nc.somefield
ON st.somefield = ac.somefield
I've seen this off and on over...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 3, 2011 at 1:35 pm
Congratulations Gail!
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 3, 2011 at 9:04 am
People just came to me because we have the "problem" of apostrophes and ampersands in our data. I showed them this http://xkcd.com/327/
I was surprised they hadn't seen it, so I...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 3, 2011 at 9:03 am
Fal (5/2/2011)
Stefan Krzywicki (5/2/2011)
Fal (5/1/2011)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 2, 2011 at 6:04 pm
WayneS (5/2/2011)
SQLRNNR (5/2/2011)
Stefan Krzywicki (5/2/2011)
WayneS (5/2/2011)
Stefan Krzywicki (5/2/2011)
And now I feel like I'm talking about breath mints...
So... what's the difference between a person with an alphabet soup of certs, and...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 2, 2011 at 10:44 am
WayneS (5/2/2011)
Stefan Krzywicki (5/2/2011)
And now I feel like I'm talking about breath mints...So... what's the difference between a person with an alphabet soup of certs, and a breath mint?
I'm really...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 2, 2011 at 10:29 am
[Jim].[dba].[Murphy] (5/2/2011)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 2, 2011 at 10:28 am
Ninja's_RGR'us (5/2/2011)
Stefan Krzywicki (5/2/2011)
Ninja's_RGR'us (5/2/2011)
SQLRNNR (5/2/2011)
Stefan Krzywicki (5/2/2011)
Ninja's_RGR'us (5/2/2011)
Brandie(5/2/2011)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 2, 2011 at 10:11 am
Ninja's_RGR'us (5/2/2011)
SQLRNNR (5/2/2011)
Stefan Krzywicki (5/2/2011)
Ninja's_RGR'us (5/2/2011)
Brandie(5/2/2011)
Ninja, I can hardly throw stones on that particular point. Being a speed reader tends to work against me on the online forums.
Same here... hence...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 2, 2011 at 10:03 am
Ninja's_RGR'us (5/2/2011)
Stefan Krzywicki (5/2/2011)
Ninja's_RGR'us (5/2/2011)
Brandie(5/2/2011)
Ninja, I can hardly throw stones on that particular point. Being a speed reader tends to work against me on the online forums.
Same here... hence #1...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 2, 2011 at 8:23 am
Viewing 15 posts - 1,786 through 1,800 (of 2,838 total)