Viewing 15 posts - 286 through 300 (of 653 total)
I don't know the difference between the two but I use them interchangeably.
I also use [] brackets for badly named (mostly Access style) columns like [Order Numbers]
July 6, 2007 at 2:22 am
yes its possible use
CASE ...
WHEN x THEN ....
END
look it up in BOL
July 6, 2007 at 2:17 am
Mike,
i didn't mean to be rude or anything its just that if you post something once, you are almost guaranteed that people will have a look at it. if you don't...
July 5, 2007 at 12:45 pm
no, i don't think that is possible you will need to use the second method
July 5, 2007 at 10:27 am
please stop double posting, you have another post with the same problem.
as for your solution you can have a look at these posts
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=376899
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=379131
July 5, 2007 at 10:16 am
what error message is @userid giving you when you want to use int?
July 5, 2007 at 8:32 am
its advisable to use int, bigint
try this code, i just shifted your code around. i could not figure out the function of the @date variable.
in your code you are trying...
July 5, 2007 at 8:28 am
easy on the colours there 🙂
if you want to input data into your TimeEntryTemp table, there is no need to pass the variables in the stored proc. Let me have a look...
July 5, 2007 at 8:13 am
to read your excel file you can use openrowset
SELECT
* FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',...
July 5, 2007 at 5:11 am
its much more beneficial for you if you first post your code and then we can try to see where you are going wrong.
July 5, 2007 at 5:06 am
for example if you are using a big int in your column and you have 1000 records.
bigint storage size is 8 bytes so that would be
8*1000 = 8000 bytes...
July 5, 2007 at 5:03 am
select
LEFT(errorCol,DashPoint-1) as Servername,
SUBSTRING
(errorCol
July 5, 2007 at 3:10 am
do you have any control on the source application, if so you could consider put delimiters when generating the errors.
if not you can make assumptions about the month being mmm,...
July 5, 2007 at 2:48 am
for your problem space you can use this solution but you might have to adapt for other problem spaces e.g. where sample is not a number but some characters etc
July 5, 2007 at 2:41 am
it probably because you have not enabled the use of xp_cmdshell. in sql 2005 many features are locked down by default, so you have to enable them
go to the sql...
July 5, 2007 at 2:26 am
Viewing 15 posts - 286 through 300 (of 653 total)