Viewing 15 posts - 1,141 through 1,155 (of 3,221 total)
jkp2311 (6/25/2011)
I find another solution...
declare @vint int
declare @vcount int
declare @vintnew varchar(200)
declare @vintnew1 varchar(200)
set @vint = 1
set @vintnew = cast(@vint as varchar(200))
while @vint < 5
begin
June 25, 2011 at 1:10 pm
LutzM
And no, I don't think the solution Ron (bitbucket) posted is helpful to the community, since it shows the 2nd best option in almost any case. (@Ron: no personal...
June 25, 2011 at 7:57 am
Here it is as a WHIE loop
SET NOCOUNT ON
DECLARE @s-2 INT
DECLARE @P VARCHAR(20)
DECLARE @X VARCHAR(20)
SET @X = ' '
SET @s-2 = 1
WHILE (@S < 10)
BEGIN ...
June 24, 2011 at 5:53 pm
Read this for a guide to accomplish want you desire to do.
June 24, 2011 at 1:57 pm
GilaMonster (6/24/2011)
bitbucket-25253 (6/23/2011)
A rather obvious answer. Come on Gail make your next QOD more difficult.Wait a week.
Looking forward to it.
June 24, 2011 at 6:48 am
A rather obvious answer. Come on Gail make your next QOD more difficult.
June 23, 2011 at 8:59 pm
Check out the following and determine if these might assist you.
SQL Server 2005 Log File Viewer at:
http://www.mssqltips.com/tip.asp?tip=1021
or:
http://decipherinfosys.wordpress.com/2008/04/02/log-file-viewer-in-sql-server-2005/
Now both use SSMS and some manual labor, but just might suffice for this...
June 23, 2011 at 12:08 pm
SQLRNNR (6/23/2011)
Gianluca Sartori (6/23/2011)
Jayanth_Kurup (6/23/2011)
June 23, 2011 at 11:06 am
winston Smith (6/22/2011)
If you could explain your question a little clearer, and give some context ( in the form of...
June 22, 2011 at 5:01 pm
skynet_si (6/22/2011)
SET DATEFORMAT DMY
before every insert queery.
I dont really care how the server stores my data as long as I enter it
correctly....
I tried and...
June 22, 2011 at 10:48 am
Does this help:
CREATE TABLE #MY_TABLE (TYPE VARCHAR(5),START_DATE DATETIME,END_DATE DATETIME,RATE VARCHAR(4))
SET DATEFORMAT DMY --Note this setting
INSERT INTO #MY_TABLE (TYPE,START_DATE,END_DATE,RATE)
VALUES('DBLMS','01.03.2011','16.04.2011','104');
SELECT TYPE, CONVERT(VARCHAR(10), START_DATE, 103) AS [DD/MM/YYYY]
FROM #MY_TABLE
Result:
TYPEDD/MM/YYYY
DBLMS01/03/2011
Remember that:
Values with the datetime data...
June 22, 2011 at 7:14 am
Will this make you happy?
SET DATEFORMAT ymd;
GO
DECLARE @datevar DATETIME;
SET @datevar = '1998/12/31';
SELECT @datevar AS DateVar;
GO
-- Result: 1998-12-31 00:00:00.000
--Will this make you happy?
SET DATEFORMAT dmy;
DECLARE @datevar DATETIME;
SET @datevar = '31/12/1998';
SELECT @datevar...
June 21, 2011 at 10:41 pm
WayneS (6/21/2011)
Stefan Krzywicki (6/21/2011)
June 21, 2011 at 7:14 pm
You are more likely to have someone assist you if you post your table definition, some sample data (which you have but not in a readily useable format).
May I suggest...
June 21, 2011 at 11:19 am
Viewing 15 posts - 1,141 through 1,155 (of 3,221 total)