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...
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...
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...
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...
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...
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...
May 3, 2011 at 1:35 pm
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...
May 3, 2011 at 9:03 am
Fal (5/2/2011)
Stefan Krzywicki (5/2/2011)
Fal (5/1/2011)
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...
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...
May 2, 2011 at 10:29 am
[Jim].[dba].[Murphy] (5/2/2011)
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)
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...
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...
May 2, 2011 at 8:23 am
Viewing 15 posts - 1,786 through 1,800 (of 2,838 total)