Viewing 15 posts - 7,651 through 7,665 (of 13,460 total)
this is a tough requirement,a nd will undoubtedly require multiple passes of SQLs and lots of code; there is no way you can do this in a simple, easy...
May 5, 2011 at 2:52 pm
an HTML report ignores whitespace...so to handle that, you'd probably want to .Replace " ", "& n b s p ; " or with CHAR(160) which is a space in...
May 5, 2011 at 2:37 pm
mutobo (5/5/2011)
I have read somewhere that is is possible to define a loopback linked server ( pointing to the same source db )
and use in auditing scenarios to modify data...
May 5, 2011 at 2:14 pm
SQL stays in a single datatype when you are doing the math;
so when you do this portion of your formula:
8*1024*1024*1024, which are all integers, SQL assumes/shortcuts a decision that INT...
May 5, 2011 at 1:07 pm
Sean Lange (5/5/2011)
Lowell you beat me to the punch again. 😛
I'm hitting a lot of low hanging fruit today! I'll leave complicated PIVOTS and recursive CTE's to you, ok?
May 5, 2011 at 12:53 pm
not sure, i'm not comfortable with teh UPDATE from a subselect, so i'd use this update statement instead:
UPDATE ADDRESS
SET ADDRESS_STATE_ID = s.STATE_ID
FROM zipcode z
...
May 5, 2011 at 12:50 pm
DECIMAL (5,1) means 5 significant digits: 9999.9 is the max amount...so any value larger than that size will result in an arithmatic overflow error.
i typically always use the same decimal...
May 5, 2011 at 10:57 am
it's integer division;
sql shortcuts and says integer / integer = integer, s 3 / 2 = 1 for example, and not 1.5, so you lose decimal places.
chnage it to...
May 5, 2011 at 10:24 am
change it again. if you typed in the password in a config file, it's in clear text in that file and a security risk of the highest order.
create a...
May 5, 2011 at 9:55 am
why can't you just issue an ALTER VIEW command? don't you already know it exists, or is this script a create/recreate in case of an empty database?
May 5, 2011 at 9:42 am
Leonard see this post from yesterday, where someone posted the same question:
http://www.sqlservercentral.com/Forums/Topic1103306-146-1.aspx#bm1103313
To prevent the DROP of objects,where the user normally might have permissions to do so, you'll have to use...
May 5, 2011 at 8:19 am
just add additional columns from the original table to teh query:
SELECT
TheDate,
RUN_TIME,
USERS_COUNT,
CONNECTION_COUNT
FROM
(SELECT
DATEADD(dd, DATEDIFF(dd,0,RUN_TIME), 0)...
May 5, 2011 at 8:07 am
i think this is clsoer to what you are trying to do:
IF you can find a date in the description, set the [Date] field to that value:
UPDATE [Intermediate invoices]
SET [Date]...
May 5, 2011 at 7:58 am
doh; it should be more like GSquared; remove the USERS_COUNT, CONNECTION from the PARTITION statement.
SELECT
TheDate,
USERS_COUNT,
CONNECTION_COUNT
FROM
(SELECT
DATEADD(dd,...
May 5, 2011 at 7:23 am
I've tried updating the first one while using the below query :
INSERT INTO [Intermediate invoices] (Date)
Select distinct convert(datetime,[Description 7],105) from [Intermediate invoices]
you said trying to UPDATE, but your command is...
May 5, 2011 at 7:18 am
Viewing 15 posts - 7,651 through 7,665 (of 13,460 total)